Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to trap /log Modifications to a Table
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How to trap /log Modifications to a Table
Divers
Thread ID:
01268335
Message ID:
01268335
Vues:
60
Hi.
I want to update a Log file of all modifications to a table.
I would have numerreous screens and PRG files where the table is updated
and am looking for 1 place to put code, rather than having to go back into each screen or prg file.
I typically would have a combination of:

1. An append and Replace
Sele MyTable, Appe Blank, Replace Myfield with Newfield
2. A seek/locate and replace
Seek MyKey If Not eof() Replace Myfield with Newfield
3. An Insert
Inert into MYTbale .....

Ideally, If I could use a trigger somewhere in the Database (its in a DBC container) it would be ideal, but am not sure if these just work for inserts or will they also work woth Append and Replace ?
If I can avoid it, I dont want to have to go back into each form and Prg and start amending.

Any help appreciated
Regards
Gerard
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform