Board index » delphi » Tables from different databases

Ernesto D'Spirito

Delphi Developer
Tue, 06 Jan 2004 03:02:15 GMT

Tables from different databases

Hi!

I was wondering whether someone could tell me how to perform
a query taking data from two tables that are in two different
database.

Thanks in advance

 
Thomas Steinmaure

Delphi Developer
Tue, 06 Jan 2004 03:35:50 GMT

Re:Tables from different databases


Sorry but queries over tables in different database aren't possible.

--
Best Regards
Thomas Steinmaurer
IB LogManager - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com
"Ernesto D'Spirito" <edspir...@latiumsoftware.com> schrieb im Newsbeitrag
news:3b572f39_2@dnews...

Quote
> Hi!

> I was wondering whether someone could tell me how to perform
> a query taking data from two tables that are in two different
> database.

> Thanks in advance

Mike

Delphi Developer
Tue, 06 Jan 2004 06:00:54 GMT

Re:Tables from different databases


Quote
Thomas Steinmaurer <t...@iblogmanager.com> wrote in message

news:3b573682_2@dnews...

Quote
> Sorry but queries over tables in different database aren't possible.

I think you can if you use the BDE.

...MC

Thomas Steinmaure

Delphi Developer
Tue, 06 Jan 2004 06:06:28 GMT

Re:Tables from different databases


Probably right but I dropped the BDE long time ago and therefore I can't
speak for BDE :-)).

I meant the database engine doesn't support multi database queries.

Best Regards
Thomas Steinmaurer
IB LogManager - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

"Mike C" <M...@ringtek.com.antispam> schrieb im Newsbeitrag
news:3b57584f_2@dnews...

Quote
> Thomas Steinmaurer <t...@iblogmanager.com> wrote in message
> news:3b573682_2@dnews...
> > Sorry but queries over tables in different database aren't possible.

> I think you can if you use the BDE.

> ...MC

Mike

Delphi Developer
Tue, 06 Jan 2004 06:15:01 GMT

Re:Tables from different databases


Quote
Thomas Steinmaurer <t...@iblogmanager.com> wrote in message

news:3b5759ce_1@dnews...

Quote
> Probably right but I dropped the BDE long time ago and therefore I can't
> speak for BDE :-)).

> I meant the database engine doesn't support multi database queries.

I've never tried it, and I also drop-kicked the BDE long ago.     =)

And, as I read elsewhere, cross-database BDE operations are    v  e  r  y
s  l  o  w...

...MC

Aaron Ruddick[Borland

Delphi Developer
Tue, 06 Jan 2004 06:56:43 GMT

Re:Tables from different databases


You can also use JDBC (if you use java).

Quote
Mike C wrote:
> Thomas Steinmaurer <t...@iblogmanager.com> wrote in message
> news:3b573682_2@dnews...
> > Sorry but queries over tables in different database aren't possible.

> I think you can if you use the BDE.

> ...MC

--
Thank you,
Aaron Ruddick
InterBase QA
http://www.borland.com/interbase

Other Threads

1. Query with two tables in different databases

2. Joining two tables from different databases

3. Joining Tables from Different Databases

4. Joining two tables from different databases

5. QUERYING TABLES FROM DIFFERENT DATABASES WITH DELPHI

6. QUERYING MULTIPLE TABLES FROM DIFFERENT DATABASES

7. Referential integrity between tables in different databases

8. tables in different databases

9. How to insert data into a table in different database from another database?

10. Joining 2 different InterBase Tables with 2 different Database