General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating fields in Update trigger ????
Is it possible to use the update trigger for a table to update fields in the table that has fired the trigger.
What I would like to achieve is to have the Update Trigger set a date and time field with the date & time that the record was updated. If I try to do this using the following procedure I get an error message "cannot update the cursor".
PROCEDURE _TESTTABLEUPDATE
IF _TRIGGERLEVEL > 1
RETURN .t.
ELSE
REPLACE DATE WITH DATE() IN TESTTABLE
REPLACE TIME WITH TIME() IN TESTTABLE
ENDIF
RETURN .t.
Any advice gratefully received,
TIA
Andy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only