Board index » delphi » Q: constraints between several IB databases?

Q: constraints between several IB databases?

Is is possible to constraints stretch over several IB databases? Say that
you have a table A in database 1 and antother table B in database 2 with a
foreign key to table A in database 1?

Is this possible, can you configure it like this somehow?

TIA
Fred

 

Re:Q: constraints between several IB databases?


"Fred" <t90...@passagen.se> skrev i melding
news:3d786e2c$1@newsgroups.borland.com...

Quote
> Is is possible to constraints stretch over several IB databases? Say that
> you have a table A in database 1 and antother table B in database 2 with a
> foreign key to table A in database 1?

> Is this possible, can you configure it like this somehow?

No. Two IB databases can't intercommunicate or read each other's data.
One colution could be having a servise application running that's logged on
both databases, receiving events whenever key values are changed. A trigger
on the table may fire an event that will be processed by this application.

It won't be quite the same as having a foreign key constraint, as events are
fired when transactions are committed...and that's a little too late,
really. Records are posted...*then* a message pops in that shows the last
record contained an illegal value.

From an application, you could do the referential intgrity check manually by
issuing a query to the other database. This puts a limit on how you could
use these tables, though.

--
Bj?rge S?ther
bjorge@hahaha_itte.no

Re:Q: constraints between several IB databases?


Thanks.

I suspected that to be true ....

/Fred

Re:Q: constraints between several IB databases?


No. This is not possible.

Quote
On Fri, 6 Sep 2002 11:04:05 +0200, "Fred" <t90...@passagen.se> wrote:
>Is is possible to constraints stretch over several IB databases? Say that
>you have a table A in database 1 and antother table B in database 2 with a
>foreign key to table A in database 1?

>Is this possible, can you configure it like this somehow?

>TIA
>Fred

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

Other Threads