🚀 go-pugleaf

ADO does not define SQL syntax. If your DBMS supports joins from two or more
databases, you can use this feature, if not - you can not. Most DBMS do
support this, look your DBMS docs for help.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Alex Ip" <alex.ip@bigpond.com> �������/�������� � �������� ���������:
news:3e5d4b66$1@newsgroups.borland.com...
> Sorry for the delayed cross-post, but I didn't get a response from
> borland.public.cppbuilder.database.desktop, so I thought I'd try here.
> Please see below.
>
> "Alex Ip" <alex.ip@bigpond.com> wrote in message
> news:3e589952$1@newsgroups.borland.com...
> > Hello all...
> >
> >     I am looking at porting a fairly extensive BDE-based Paradox-engined
> > application to ADO, having sucessfully used ADO with several different
> > engines under ODBC for other apps. One of the only gotchas I can see so
> far
> > is that I am currently using two BDE aliases for separate databases: one
> on
> > CD (read-only, naturally) and one in a temporary directory on the hard
> disk.
> > BDE allows me to perform joins on tables across the two databases, and I
> > need to be able to do this using ADO. Is this possible, or will I have
to
> > resort to doing it myself in client-side code if I go with ADO?
> >
> >     Any suggestions would be much appreciated.
> >
> > Regards,
> >
> >     Alex.
> >
> >
>
>