General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Hello all, I need suggestions on detecting changes to my data at the form level. I want to enable Save and Revert buttons and prompt to save/revert when form looses focus. I've seen several complex solutions based on reusability and toolbars, but I just need to manage it at the form level. I always have an application object available, and am using table buffering and private data sessions.
>>
>>Any help greatly appriciated.
>>
>>Dean
>
>dean, If you are using Table buffering (as opposed to record), you will need a combination of GETNEXTMODIFIED and GETFLDSTATE.
>
>Changed table fields report that they have been changed to GETFLDSTATE by showing something other than a "1". To check for anychanges, use something like
>
>llChanged = GETFLDSTATE(-1) <> REPLICATE("1", FCOUNT() + 1)
>
>see the help for GETFLDSTATE for details.
Eric, Thanx, I looked at GetFldState before, but was thrown off by Help indicating the return value was numeric. Using str() on it was bugging out (cause it is really returning a string).
But where is the best place to implement this test? I want to enable the save/revert buttons on my form when a change occurred in a row. The user can decide to update now, or continue editing.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only