--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:

> At 11:35 AM 12-03-02 +0000, Arpe wrote:
> >Helo, we are converting a multi-enterprise application from db7 to
> >IB. The
> >application has common table has enterprise specific ones. In db7
> >could make
> >queries like this:
> >SELECT A.*,B.*
> >FROM 'c:\app\data\common\table1.dbf' A LEFT JOIN
> >'c:\app\data\enterprise001\table2.dbf' B on (A.ID = B.ID)
> >
> >How could it be done in IB?
> >Note, using several GDBs is a must (needed to use data from other
> >applications).
>
> No, IB does not support cross-database joins. There is no

mechanism for

> protecting the integrity of keys from one database to

another....This, btw,

> is off-topic for the IBO list. Do you know about
> ib-support? http://www.yahoogroups.com/community/ib-support
>
> What you can do is query multiple databases inside one single

transaction

> and pass parameters from query to query. IBO supports this very

well.

>
>
> regards,
> Helen Borrie (TeamIBO Support)
>
> ** Please don't email your support questions privately **
> Ask on the list and everyone benefits
> Don't forget the IB Objects online FAQ - link from any page at
> www.ibobjects.com

Hello, Helen,
I'm sorry with previous off-topic, but I hoped IBO could do that for
me, becouse I had read in http://www.tamaracka.com/ news browser that
BDE is able to perform that at clien side.

Thanks again, for your patience and time.
Dario - Arpe Software