Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement