Board index » delphi » multiply dbs

multiply dbs

how do you select and join from mulitply dbs

Thanks
Kavil

 

Re:multiply dbs


Quote
> how do you select and join from mulitply dbs

You can't.

retrieving data from multiple database in a single query is not supported.

-Jaimy

Re:multiply dbs


Is there any other way of getting data from two identical dbs and from the
same table names ?
even using more then one query

Quote
"Jaimy" <ja...@nospam.sat.net.id> wrote in message

news:3b4ae560$1_1@dnews...
Quote
> > how do you select and join from mulitply dbs

> You can't.

> retrieving data from multiple database in a single query is not supported.

> -Jaimy

Re:multiply dbs


Try to make another TIBDatabase, change the TIBTable / TIBQuery Database
property to it at runtime. i use it when need to retrieve data from another
database file which has the identical structure/name.

HTH,

-Jaimy

Other Threads