Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread How to determine if data changed
Mon, May 1 2006 7:18 AMPermanent Link

"Kerry Cain"
I am using a memodialog to allow users to modify a memo field - if they
wish - but I need to be able to determine if they actually did so that I can
display another dialog to allow them to determine if the record needs
further changes.

ie if they did modify the memo this might finalise the record task it
represents or they also could just be adding some comments without
finalising the task.

My problem - how do I know if the memo field has changed (changes posted on
close of dialog) ?

using D5 and dbisam 3.19

thanks kerry

Mon, May 1 2006 7:57 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Kerry


Use the OnChange event to set a flag which you can then examine. The only problem with that is it doesn't show if someone typed something and then deleted it leaving the data the same.

If you're using a DBMemo component I'm not sure at which point data is changed but you might want to look at comparing field.Value with field.OldValue.

Roy Lambert
Mon, May 1 2006 12:42 PMPermanent Link

Nick Howell
This may be overkill, but you could add a CRC field & compare pre/post edit values ... There's  some example
code for CRC computation out on Efg's:
http://www.efg2.com/Lab/Mathematics/CRC.htm

Nick
Mon, May 1 2006 9:27 PMPermanent Link

"Clive"
You could check field.lastvalue in BeforePost ?


"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:56A7DFC8-4CE6-419A-813B-30A43F10CF8A@news.elevatesoft.com...
> Kerry
>
>
> Use the OnChange event to set a flag which you can then examine. The only
> problem with that is it doesn't show if someone typed something and then
> deleted it leaving the data the same.
>
> If you're using a DBMemo component I'm not sure at which point data is
> changed but you might want to look at comparing field.Value with
> field.OldValue.
>
> Roy Lambert
>

Image