Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Audit Trail using a grid to modify data
Message
De
19/06/2003 13:49:59
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Audit Trail using a grid to modify data
Divers
Thread ID:
00801858
Message ID:
00801858
Vues:
67
I am using a grid in some cases to modify data directly in the grid with the columns' datasource linked to certain fields. I like to keep an audit trail showing when data is changed, who made the change, what the old value was, new one, etc. With text boxes, we have the got focus and lost focus, so I store the value of the field/object in gotfocus into a temp variable, then in lostfocus, if the new value of the field is different than the temp variable, then I use my audit trail table and log the changes. The problem is that columns in grids don't have lost and gotfocus events. They have before/after row change, but that could go up or down and involve inefficient code. Does anyone have any good suggestions of how I can EFFICIENTLY perform this task doing modifications on fields within a grid?

Kev

- Appreciate a normal day, it is always better than a bad one.
``` Appreciate a normal day, it is always better than a bad one ```

Kev
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform