General information
Category:
Coding, syntax & commands
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only