Fabrice Vendé - INFOCOB wrote:

>
> Hello,
> I use Delphi with interbase 5.6 and 6.
> With the standard database component of delphi (5.0) it is possible to do
> heterogeneous queries (query on different database) like:
> select * from ":aliasBDE1:customer",":aliasBDE2:customer"
> where ":aliasBDE1:customer".code =":aliasBDE2:customer".code
> It's work fine with BDE Interbase aliases.
>
> Is it possible to do the same with ibxpress component ?

No. The BDE based TDatabase component uses a little trick to do the
heterogeneous query. It issues two separate queries - one to each database and
then does the join locally. It can be quite an expensive operation in
client/server terms.

You can achieve a similar effect if you do the same, and code the 'join'
yourself. Displaying the results in a grid might be difficult though.

Paul
--

Paul Reeves
Fleet River Software
/***************************************************************************
* v1.0 of the InterBase Heartbeat - Database Monitor is now available. *
* Visit http://www.fleetriver.demon.co.uk to download an evaluation copy. *
***************************************************************************/