Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help. Auditing data changes.
Message
De
26/12/2003 08:40:16
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
26/12/2003 08:08:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00862104
Message ID:
00862107
Vues:
15
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform