I have 2 adoconnections and 2 datatables in each connection (Local Table1_master Table1_Detail) (Network Table1_master Table1_Detail). I show them in a DBgrid and now I would like to update the (Local Table1_master Table1_Detail) from the tables in (Network Table1_master Table1_Detail). How can I update the selected records?
I have tried many ways but normally it inserts more records and doesn´t update the record.
I use a .MDB database.
You could use an old master -> new master approach. Return both datasets sorted the same way, and run down each list simultaneously. if table1.key > table2.key then you have a record in table2 that doesn't exist in table1...you can delete the record in table2 or increment the cursor. If table1.key < table2.key then you are missing a record in table2, so insert the new record. if table1.key = table2.key then you can perform your update logic. if table1 is at end but table2 is not, then the rest of table2 doesn't exist in table1 (so possible deletes). If your at the end of table2, but not at the end of table1, then the rest of table1 are inserts.
The nice thing about this approach is you only walk each table once, and its in the same loop.