Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Audit Trail using a grid to modify data
Message
From
19/06/2003 13:49:59
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Audit Trail using a grid to modify data
Miscellaneous
Thread ID:
00801858
Message ID:
00801858
Views:
66
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
Next
Reply
Map
View

Click here to load this message in the networking platform