Is there a flag to tell if a user changed data on a form? 2

[ibanezGuitars]

I'm using the database container in VFP 7.0 (SP1) on a Win XP machine. When a user clicks the Exit button on the Client Form, it saves the changes and unloads the form.

Is there an indicator or some type of flag available that I can reference which would tell me if a user actually changed and/or added data to any of the 200+ controls on the form before I save it?.

Thanks for your time,

Dave R

 

[alvechurchdata]

Fox forms don't have the Dirty property like Access but it's easy enough to add this as a custom property and set it False whenever any control sees a change.

If you're buffering the data then GetFldState(-1) will tell you which field (if any) has been changed.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[JimWWinter]

Dave,

Assuming your table is buffered, you can use the CurVal() and OldVal() functions.

Regards,
Jim

 

[booleanist]

Thank you both for the quick replies.

Dave