Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To: Set the updated records...
Message
From
11/10/2004 13:05:06
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00950441
Message ID:
00950477
Views:
12
This message has been marked as the solution to the initial question of the thread.
>Hello... I'm here again! ;-)
>
>So... At the end of each day, I have to create a list of records that has been inserted, updated or deleted... My problem isn't create this list, but know which records...
>
>My idea was create a field LastUpdate DateTime and use the triggers to keep this information up to date!
>
>But, when one trigger is fired, and I try to replace some field, I got an error: Cannot update the cursor.
>

Triggers can't change data in the same table. You might try creating a log table that's updated by triggers. That is the create and update triggers for all the tables you need to track would insert a record into the log.

Your other option is to use a record-level rule. Record rules are called each time you save the record, so you can update the field there.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform