Compare FoxPro Tables

[anonymous]

[Originally posted by pcprgmr]

Anyone have a good solution to comparing Data in foxpro tables?

[anonymous]

[Originally posted by Sabir Mustafa]

Please tell in what way you want to compare data?

[anonymous]

[Originally posted by pcprgmr]

I want to be able to input two tables and have the program give me back a list of differences in the data.ÿ the table structures will be identical, I just want to compare the data.

[anonymous]

[Originally posted by Sabir Mustafa]

although, i am presently not using FoxPro, I had an example from my memory. Try it!

Ok, let's take an example. You have two tables, Cust1 and Cust2 Having structure of

Custid
CustName
CustAge

The Custid in Cust1 is primary key;
make a .prg or use command window and type following commands:

sele 1
use cust1 index ID1
sele 2
use cust2 index ID2

sele 1
set rela to custid into cust2
brow for cust1.custid<>cust2.custid