Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing 2 records
Message
From
28/07/2005 08:41:31
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01036517
Message ID:
01036537
Views:
15
Sergey

My boss promised me VFP9 months ago but as yet, no joy :-)

>Terry,
>
>In VFP8 and later you could use SYS(2017) function to create record checksums and then compare them.
>
>>
>
>>Thanks for getting back. What I want is to compare 2 tables, side-by-side, record by record. If I detect any difference in one then I want simply to overwrite the matching rec in the other table with it.
>>
>>As such it would be great if this were a totally generic process, where I just need to feed the 2 tables.
>>
>>Background: I have my VFP tables and copies of them, in FoxPlus format, which are used by MapInfo GIS. Now the GIS tables can be interrogated with an "Infotool" that pops up details from a selected record/object on the map. Any of these details can be changed in my VFP app, and I do an update to the GIS tables when the mapping session is invoked, to ensure the latest data are displayed.
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform