Re: Checking Variables for any change?

[Michael Young]

Hello Rich,

I can think of 2 ways. The first and surest would be to set a whole new second set of variables and then compare them one by one and see if any have changed.

The second way would be to create an Exit procedure on the form or field and check to see if the data has changed in the form like this:
set var vtest = (ISTAT('FORM_DIRTY_FLAG'))
if vtest = 0 then
*(No changes have been made.)
do whatever
else
*(You know that something has changed but not what. This is why you
might want to use #1 above.)
do whatever
endif
return

You might want to check out the CVAL help files. You could do an EEP using some of those options that will check each field for changes as they are made.

Best regards,
Mike Young

--Original Message Text---
From: Richard A. Starkey
Date: Sat, 28 Apr 2001 10:43:11 -0400

Normal 0 DocumentEmail 5 pt 6.8 pt 2 2

Hello all,

 

I have created a form for entering or editing data about a specific client which includes Approximately 39 variables. There are also three command buttons which open MDI forms for additional information if needed. 

 

My problem is: What is the easiest way I can check which variables have been changed. I would then update only the appropriate table / tables (Approx. 10 tables) that are affected. I do not want to do a total update for all the variables, which seems to be the easiest, because there are fields in all the tables that track who and when any information has been updated/changed. I do not want to update these fields if no change has been made to that table.  

 

Any help or insight would be greatly appreciated.

 

Rich S.