Thank you...
Actually, I'm doing it using the VALID of each record... but your idea about a log table sounds perfect!
Thank you again!
[]s!
>>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
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte