Comparing record with original when saving

Boaz Bezborodko boaz at mirrotek.com
Wed Jan 17 05:48:52 PST 2007


>>I believe that he wants to compare the current values
to the original values - if you want to do that at the
time the record is saved, then I believe that you do
need an array to store the original values.
>>>

The older Filepro manual has a solution for this that doesn't use a lot
of code.

What you do is create a qualifier for the file.  On entering update copy
the record to the qualified file and record the record number of that
record in a dummy field.  When saving the record run a loop to compare
each field with the same field in the qualified record.  If you only
have to compare the item records then simply start the loop at that
field.  A simple MOD statement will tell you which of the detail items
of the associated fields you are dealing with.

When you're done you can delete the qualified record.

Boaz



More information about the Filepro-list mailing list