| Subject | Re: [IBO] Joining tables located in different databases |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2017-08-08T09:15:24Z |
This is a question related more to the transition Paradox -> Firebird than BDE -> IBO. What is and has been doable through IBO and Firebird for a long time, is crossdatabase transactions. Cross database queries is something completely different, although Firebird 2.5 introduced some basic functionality (see http://www.firebirdfaq.org/faq16/). I don't use Fb 3 myself, so there may be something more there that I do not know about, I would recommend rephrasing your question to two separate questions and asking the Paradox -> Firebird question at the firebird-support e-mail list.
Moving from a desktop database (Paradox) to client/server (Firebird) is a considerable move (though you are already referring to queries, and table -> query is an important part of this), and I think I would recommend rethinking the database design. What is the reason for you wanting to put tables that you want to join in different databases? Firebird can handle many tables and much larger databases than Paradox. If you e.g. have different persons taking the database with them on their laptop, maybe the Firebird way of doing this would be to have one master database and transfer between the databases (through replication or some simpler tables, depending on your need and resources).
Good luck,
Set
2017-08-08 9:33 GMT+02:00 gunter.selleslagh@... [IBObjects] <IBObjects@yahoogroups.com>:
Hi,
Recently bought IBObjects as a tool to help us to migrate our application from BDE/Paradox to Firebird in Delphi2007. One of the challenges is to perform a query that joins tables located in different databases.
Is this possible with IBObjects components, such as IBOQuery, and if so how does this work?
A search on the internet did not give me a suitable solution at the moment.
Someone any suggestion?
Kind regards,
Gunter