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