Pulling data from separate databases

rbuser

I recently archived records for a client to a separate database, "Archive".


Now I realize that one report they relied upon requires both current
records and any records that were archived.

I can't seem to get a report generated that would allow me to merge/join
the current and archived records, or even select each database
separately and print out separate current and archive versions of the
report. If I attempt to utilize the Archive database,
(Design->Data->File->Data Settings->Connection->Database Name) the
dropdown selects it, but, the data is still from the current database.

Any help would be greatly appreciated.

John Turner

nicocizik

Hi John,

Dade (or the built-in data access in RB) is designed to access only one
database at a time. One option may be to pull the data needed back into
the original database. Another might be to create some in-memory
datasets in Delphi and use them to create the report.

rbuser

Thanks Nico.

Yes, I thought about creating a query that spans the two databases with
a join and use that...So, that appears to be the best solution based
upon your advice.

Thanks again,

John