Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How to trap /log Modifications to a Table
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
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