Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored proc triggers read only error
Message
From
23/07/2008 15:01:54
 
 
To
23/07/2008 14:56:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01333481
Message ID:
01333518
Views:
9
>Yes, I actually have defaults in the full DBC. However, my concern is that if someone INSERT INTO FROM MEMVAR or SET CARRY ON and APPEND BLANK. I don't want the old date. Also, I want the change date to be automatic when the records is changed. The unfortunate thing is that we do a bunch of things from the command line, such as update tables like this. I supposed I could/should make an update form that handles these bits, but I haven't had time.
>
>David
In this case what you can in your trigger for the insert and update is to check if the value is updated like.
IF ChangeDate<>DATE()
   =MessageBox("Please make sure....")
   return .f.
ENDIF
This way at least you might get the attention of someone that does an update/insert.
The form of course would be better.

Yelena
Previous
Reply
Map
View

Click here to load this message in the networking platform