D
David Abdala
Guest
You don't need to join them: table1:TRACKING-CHANGES = TRUE. FOR EACH table2: FIND table1 NO-ERROR. IF NOT AVAILABLE table1 CREATE table1. BUFFER-COPY table2 TO table1. END. FOR EACH table1: IF NOT CAN-FIND(table2) DELETE table1. END. table1:TRACKING-CHANGES = FALSE. That will leave both tables "the same". Your issues is knowing wich fields to use for finding the right record. That largerly depends on your database, but generally speaking you can "query" the table indices and pick those fields for joining the two tables. If you have no guarantee about table structure, then there is no way of doing this in a secure way. I mean that Progress doesn't enforce any kind of primary key rule, so is up to you.. I think you should receive the list of fields that form the primery key in each table (a mapping list like used for DataSource).. Somewhere in the code, "someone" knows that.. Good luck.
Continue reading...
Continue reading...