field changed

[ikh]

With buffering turned off is there a way to determine if field was changed ?

 

[ramani]

HI
IOf no buffering is available, then use SCATTER MEMVAR to keep a copy of the record in the memory. Then GATHER MEMVAR will restore the field contents. If memo fields are involved, SCATTER MEMVAR MEMO and GATHER MEMVAR MEMO.

Also, you can compare the field content with M.fieldname to chech, if any changed are incorporated.

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

Only if you saved off a copy of the data at the time you read it in. i.e. Scatter MEMO to arrayname to save the original data, and then scatter it again to another array. Next loop through the fields and compare the "old" with the "current" values.

This technique can be a lot slower than using the native buffering and the OLDVAL() and CURVAL() functions.