Hi, Pete,
I was about to give a code sample, but I just want to make sure of something:
You've brought data back from SQL into a DataSet (let's call it DsSQL), and also data from FoxPro into a DataSet (DsFox).
Both datasets have a common PK. You want to scan through each row in DsFox, take all the column values for the row, find the corresponding row (based on the PK) in DsSQL, and update all the columns. For any column names that are in DsFox but not in DsSQL, you want to add those columns.
So the end result in DsSQL is data that also appears in DsFox.
Am I right?
Thanks,
Kevin