The SCATTER NAME creates an object, with field names as properties, which COMPOBJ() than compare.
BTW, could you just zap tables and append records from VFP tables instead?
>
>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
>>...
--sb--