Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating fields in Update trigger ????
Message
From
16/07/1999 01:14:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating fields in Update trigger ????
Miscellaneous
Thread ID:
00242149
Message ID:
00242149
Views:
51
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
Map
View

Click here to load this message in the networking platform