Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do something when a column changes in a grid row
Message
From
01/04/2003 20:25:55
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00772771
Message ID:
00772776
Views:
5
>I have a "Changed_Date" field per record and it appears as the last column on each row in a grid.
>I want to change that field to the current date if any column is changed on that row (and only if there is a change).
>How do I determine if a record has changed in a row and what would be the code.

You may use the AfterRowColChange() event to know when a move is done. Then, you'll have to deal if the changes are commited or not directly to the table once the user moves out of the field. For example, if buffering is enabled on the table, then, you have an issue. The reason is that even if the user changes a field, skip record, this doesn't mean necessary that that change will be saved. So, you will probably want to only save the timestamp only when saved in the table. We usually do that type of process at save time. This is where timestamp fields are being managed. Thus, with buffering enabled, it becomes quite easy to monitor and compare the value of a field with the current value in the table.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform