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
