lysander_fb wrote:

>--- In firebird-support@yahoogroups.com, Sam Hunt <shunt@n...> wrote:
>
>
>>Gary Benade wrote:
>>According to Helen's book, FB152 handles multi-database joins using
>>2-phase commits and explicit transactions.
>>(What did I just say?!)
>>
>>
>
>Where exactly did you read that?
>If you have the same edition of the book like me, read also page 92
>and 551 - that should make it more clear. I also first have been
>stumbling about this, btw.
>
>Firebird can NOT combine two databases by means of itself.
>You need your client application to do that. In Helen's book, if you
>read closely, there also are mentioned 'Firebird APPLICATIONS', not
>the server system itself.
>
>You can, basically, start one transaction to the server.
>Within this transaction, you can make several operations concerning
>different databases. The final commit() or rollback() decides, whether
>the total of ALL operations in ALL affected databases are committed or
>rolled back.
>
>So, the support for multiple databases is restricted to transaction
>control.
>
>ciao,
>André
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

Thank you for your additional info.
I'll chk out helen's book more closely in the future.


FAI, I did study the multi-database example in the IB5.5 books and
understand that this example uses the IB API. Since I am using D7/ADO
and do not wish to mix technologies, I intend to create an application
solution to this problem by querying the "IN (SELECT" side directly and
setting the datasource of the first select statement to the result of
the second select statement.
Regards,
Sam Hunt