🚀 go-pugleaf

The only way ( I know of ) to achieve this with ADO ( and any other DB
connection layer ) depends on serverside options for example :

With Oracle you could create something called "Database link" - I use this
feature to connect between oracle instances... :
SELECT * FROM TABLE1 A, TABLE2@DBLINK B WHERE B.ID = A.ID

As far as I read there are options available from oracle to make this
feature work with DB Servers from other vendors too...

Something similar is available in Sybase etc...


With ADO another options could be ( it is really not a good one ) :
- Execute the SELECTs and put the results into a locally created MDB-file...
- Execute the JOINs with the local file...

It is a bit similar to the implementation in BDE ( the BDE relies on
clientside cursors to implement "heterogenous SQL" )...


Yahia

"Pavel Stejgerle" <pavel.stejgerle@tribut.cz> schrieb im Newsbeitrag
news:3ef2b4e6@newsgroups.borland.com...
> I use personally Sybase and Paradox on my computer, but our Software
Product
> should be Database independent (and with BDE is), up to now was tested
with
> Sybase, Paradox, Oracle, MS SQL.
>
> PS
>
> "Yahia El-Qasem" <Yahia.El-Qasem@mgh.metro-ag.de> wrote in message
> news:3ef1a6f2@newsgroups.borland.com...
> > This sort of query uses a special feature of BDE... ADO does not have
> > anything similar...
> >
> > What sort Databases ( Oracle / Sybase... ) are you querying ?
> > Perhaps there is some other solution for this...
> >
> >
>
>