Comparing record with original when saving

[Jeff Harrison]

--- Boaz Bezborodko <boaz at mirrotek.com> wrote:

> >>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
> 

"simple MOD statement" ??  Can you give us some more
detail here?  

It sounds like there would be quite a bit more IO with
this approach - also, you mentioned that you would
still need a loop... still if it is simplier to code I
would be interested in hearing the details.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The fastest and
easiest ways to export and import Filepro data.


 
____________________________________________________________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html