Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To store every record change or not?
Message
From
20/03/2011 15:50:02
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
20/03/2011 12:59:19
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01504208
Message ID:
01504256
Views:
73
>>Thank you for the suggestion. As I mentioned in my message to Kevin, right now my priority is to get the audit log as simple as possible and getting to SQL backend as soon as possible :)
>
>Understood and on the priciple of KISS full ACK. But implementing such 1 or 2 "fingerprint" fields in a base class is still much less work than an audit trail.

The purpose of audit trail is not as much in the trust issue (though that's also one of the aspect), it's more on the history side. A fingerprint, or any other field with a similar purpose, shows only who changed the record, and possibly when - but that's only the last change. A full audit trail shows all the changes as they happened, from the initial insertion of the record until today, with identities and datetimes. Including the deletion in the end, if any.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform