Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement