Thanks Sergey

I looked up ComObj() but, reading:

"..any expressions that evaluate to objects, such as object references, object variables, or object array elements. "

I thought it only compared objects as above, and not fields in tables. I'll give it a go

Cheers

Terry

>Terry,
>
>Try

>...
>  SELECT table1
>  SCATTER MEMO NAME oRec1
>
>  SELECT table2
>  SCATTER MEMO NAME oRec2
>  IF COMPOBJ(oRec1, oRec2)
>     GATHER NAME oRec1
>  ENDIF
>...

>>>Do you want to know if tables are different or which rows are different? More details, please.
>>
>>Sergey
>>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.
>>
>>