Subject | Re: [ib-support] Consult table in other database |
---|---|
Author | Svein Erling Tysvær |
Post date | 2000-12-08T06:56:07Z |
I don't use IBExpress, but it would surprise me if you could select from
two tables in different databases.
I use IBO, and there's no way to join tables from separate databases. But
IBO has the possibility of transactions covering several connections.
So my answer is:
If you want to join tables from separate databases: sorry, it's not
possible (I think the BDE may be able to do it, but if so it will select
from both databases and do the join on the client - which is not a good
solution).
If you want to make sure that updates are done to tables in several
databases (or no changes done at all if updates in one database fails): Use
IBO.
I hope someone actually using IBExpress will prove me wrong, but I doubt it.
Your English may be poor, but it's infinitely better than my Spanish ;o)
Set
At 05:39 08.12.2000 +0100, you wrote:
two tables in different databases.
I use IBO, and there's no way to join tables from separate databases. But
IBO has the possibility of transactions covering several connections.
So my answer is:
If you want to join tables from separate databases: sorry, it's not
possible (I think the BDE may be able to do it, but if so it will select
from both databases and do the join on the client - which is not a good
solution).
If you want to make sure that updates are done to tables in several
databases (or no changes done at all if updates in one database fails): Use
IBO.
I hope someone actually using IBExpress will prove me wrong, but I doubt it.
Your English may be poor, but it's infinitely better than my Spanish ;o)
Set
At 05:39 08.12.2000 +0100, you wrote:
>Hello
>
> How select table in other database ?.;-?¿
>
> Usin ibexpress no BDE.
>
>
> Sorry my english is very bad .;-(
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>