So, to be sure I have it clear, IB allows for transactions
that span multiple DBs but doesn't allow for queries, updates,
etc...

That sounds strange.

I can do as you said, and pull the info into the client
and process it there, but it would have been nice if IB
could do the query.

Thanks
Michael L. Horne

> -----Original Message-----
> From:
> sentto-402930-3112-980889699-guardian=pobox.com@...
> [mailto:sentto-402930-3112-980889699-guardian=pobox.com@....
> com]On Behalf Of Art Metz
> Sent: Tuesday, January 30, 2001 3:51 PM
> To: 'IBObjects@yahoogroups.com'
> Subject: RE: [IBO] Query on two DBs - ?how do I do it?
>
>
> Michael L. Horne wrote:
>
> > Using IBO, how do I setup a query that will combine
> > data from 2 different DBs?
> >
> > 1. Setup Components?
> > 2. Write the SQL?
>
> There's no good way to do this with InterBase. You'll need two
> TIB_Connections, two TIB_Transactions, and two TIB_Queries.
> You'll have to
> do the joins, filters, whatever, on the client side.
>
> Art Metz
> AMetz@...
>
>
>
>