At 03:26 PM 30-01-01 -0500, you wrote:

>Hello
>
>Using IBO, how do I setup a query that will combine
>data from 2 different DBs?
>
>1. Setup Components?
>2. Write the SQL?

InterBase doesn't support cross-database joins, so it's not possible to
process a statement that tries to do it.

You can set up queries from two databases simultaneously, though, and
process data in one using data from the other. Pass parameters to populate
your SQLWhereItems.

You need one connection component for each database. To put both queries
inside a single transaction and take advantage of 2-phase commit, drop down
a transaction component, name it, and assign it to the ib_transaction
property of each connection object. Make sure the queries point
respectively to the correct connection object and assign the ib_transaction
property of both to this transaction.

hth
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________