Hello Mike,
Thank you
for the suggestions. I had thought
of checking each variable by placing all the values of the variables into a
hold variable field when the variables were populated and then compare the hold
variables to the form variables just prior to updating. I was hoping there might be an easier
way to do this. Form_Dirty_Flag
would be helpful, but as you say I would not know which fields had been
affected.
I will
check out the CVAL function.
Thank you
for the advice.
Rich S.
-----Original
Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Of Michael Young
Sent: Saturday, April 28, 2001
3:02 PM
To: [EMAIL PROTECTED]
Subject: Re: Checking Variables
for any change?
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.
