Compare record - two database.

[Luc Lessard]

Hi All,

I want to compare two record (same table) different database
with the buffer-compare statement.
I have a screen that the user gone select the databases he
want to compare (so don't no the database name in advance 5
different), a combo with the table he want to compare.
I want to print-out the a report with the record that is different
ex. customer number, and the field (field label) that are different

So i don't know the database name, the table name and the
field that i'm gone a show on the report. Why not showing
the difference of the content ex. name = JOE and name = JO.

Any idea how i can do this.

TIA

 

[Norman Biggar]

How do you intend to check you are comparing the "same" record on each database?

If you have a method to solve the above, and you are running V9, you could build and interrogate dynamic queries.