Here is one idea to be implemented but I should caution you, it's not really quick nor dirty. you should have:
1. DBC
2. Buffered tables.
3. Function or a method of your Application object that is called from insert, update and delete triggers of the tables you want to track. its parameters are updatetype (add, edit or delete), the table name. That function will update a table called, let's say 'appaudit' which has the structure like:
ckeyfield c(15)
ctable c(15)
cuser c(20)
tupdate datetime
oldvalue M
NewValue M
Oldvalue will have old values for all fields of the updated record and Newvalue have all the new values.
See if that could work for you.
Previous
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