Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a log file
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00757072
Message ID:
00757621
Views:
15
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
Map
View

Click here to load this message in the networking platform