Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a last modified field.
Message
From
26/11/1997 17:33:27
 
 
To
26/11/1997 14:47:36
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00062468
Message ID:
00062498
Views:
23
>I am using VFP5 and would like to create a last modiied field in my tables. All of the tables
>reside in a Database.
>
>I created a field called "lastmod" and call an update trigger from the tables properties to up
>the "lastmod" field in this table. However when I try to call this code I get a
>"Cannot Update Cursor" error message. Here is what I try to do;
>
>SELECT thistable
>REPLACE thistable.lastmod WITH DATETIME()
>
>Can a table update one of it's fields from it's update trigger?
>
>I can update a different table from a DBC's stored procedure but not the calling table's fields
>
>Is this what I'll have to do?
>
>Thanks,
>
>Jerry Tovar

I seem to remember this question coming up on CIS. I think that you cannot modify the row during the trigger but you can from within the row rule.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform