Doing heterogeneous queries, is a good thing in the BDE, but it's all done
on the client - that's a bad thing.

As far as I remember, the IB engine is able to do this through QLI
(InterBase's old query interface), but it has not been surfaced through to
SQL. I don't think IBX is able to do it, but maybe Jason Wharton's
IBObjects has something up its sleeve - because he has been playing with
BLR (Binary Language Representation, which is how you can talk directly to
the engine - SQL gets converted to BLR too). So maybe he has done some
magic, which enables you to query the engine, and get work done on the
server.

But now that IB 6.0 is open source, it might be a good idea to surface some
of the other powerfull stuff IB is capable of, through SQL or elsewhere,
not breaking standards :-)

There probably a lot of errors in the details above, but it should answer
your question :-)

steffen





Fabrice Vendé - INFOCOB <fabrice@...> on 28-07-2000 10:03:52

Please respond to IBDI@egroups.com

To: <IBDI@egroups.com>
cc:

Subject: [IBDI] Interbase and heterogeneous query...


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 ?
I try to do it but it doesn't work !


Thanks.

Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com








Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com

Shortcut URL to this page:
http://www.onelist.com/community/IBDI