Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help. Auditing data changes.
Message
From
26/12/2003 08:40:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
26/12/2003 08:08:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00862104
Message ID:
00862107
Views:
17
>Hello folkxers,
>
>I am writing a class which tracks and audits modifications made by end-users. I need a starting point. It needs to work with OLDVAL() and CURVAL(), I work with all buffering methods.

1) If you put your auditing into the triggers instead of forms, changes will be recorded, no matter where you make them.

2) You don't need curval(), only oldval() and the actual field value.

3) This works both with, and without, buffering, although working with buffered tables is recommended for several other purposes.

See my introductory article at http://www.utmag.com/May2003/Page18.asp.

>Basically, I want to drop the class in a form and this object will monitor all changes and save them in a .log text file.

The example saves changes to a DBF, but you can easily adapt it to log changes to a text file.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform