Request on two table on different DB Interbase 6.0

Eric Despontin

Delphi Developer

Sun, 01 May 2005 00:17:38 GMT

Request on two table on different DB Interbase 6.0

How create select request between two differents tables situate on two
different databases on Interbase6.0 ?

Bill Tod

Delphi Developer

Sun, 01 May 2005 00:44:03 GMT

Re:Request on two table on different DB Interbase 6.0

You cannot. InterBase does not support cross database joins.

On Tue, 12 Nov 2002 17:17:38 +0100, "Eric Despontin" <e...@dnd.be>
wrote:

Quote

>How create select request between two differents tables situate on two
>different databases on Interbase6.0 ?

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Paul

Delphi Developer

Wed, 04 May 2005 03:35:48 GMT

Re:Request on two table on different DB Interbase 6.0

Quote

"Eric Despontin" <e...@dnd.be> wrote:
> How create select request between two differents tables situate on two
> different databases on Interbase6.0 ?

Tu dois faire ca par programmation - il ne faut pas dependre de la
base de donnees.

You can do it programmatically - not through the db engine - but you
have to be careful.

Paul...

plinehan__AT__yahoo__DOT__com

Other Threads

1. Connecting to two different tables, which stored in two different IB-databases

2. Access to different tables in the same Database in two different threads simultaneously

3. Inserting Data into Two Different Tables by querying from a single Table

4. Inserting Data into Two Different Tables by querying from a single Table

5. Joining 2 different InterBase Tables with 2 different Database

6. Joining 2 different InterBase Tables with 2 different Database

7. Accessing a TQuery or TTable against Paradox Db from two different machines on a network

8. Interbase 6.0 and IBX freeze when opening two connections in the same time

9. Record locking - no auto lock for two instances of paradox.db in different TTable comonents

10. Record locking - two instances of paradox.db in different TTable components not locking