Jay

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.

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

Terry

>I have a utility that will compare two tables, record by record, field by field, and spits out the differences into a text file. The output is not the easiest to read, expecially if there are memo fields with lots of text in them, but it definately works. Is that what you had in mind?
>
>Update: Or you can create a quick report, send the output of each table to an ASCII file, then use something like BeyondCompare to see the difference in the text files, and export that to a nicely readable HTML file.
>
>
>>Hi Vixens
>>
>>Is there a command or function or a ready-made that compares 2 records, say, same structure but in different sister tables? I want to quickly zip through two identical tables, checking if any of the fields are different. I've got a shed-load of tables to check so I don't want to be writing bespoke code to check evry field of each.
>>
>>Am I missing (or have i forgotten) something fundamental here?
>>
>>'ppreciate it
>>
>>Terry