General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
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