Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To: Set the updated records...
Message
De
11/10/2004 13:05:06
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00950441
Message ID:
00950477
Vues:
13
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform