Subject Re: [IBO] Query using to different databases (GDB)
Author arpesoft
--- 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?
> What you can do is query multiple databases inside one single
> and pass parameters from query to query. IBO supports this very
> 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

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

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