>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