Subject Re: Accessing multiple databases
Author Adam
--- In, "sibyltalk" <sibyltalk@...>
> It would seem to make sense to put common, essentially static,
> reference tables into a separate database that could be accessible to
> various projects, each project corresponding to a separate database.
> Helen Borrie's text mentiones transactionality across multiple
> databases, but I have been unable to find how you would refer to such
> a lookup table from another database either as a foreign key or in a
> WHERE clause. Can anyone tell me how to do it, or point me to a
> reference resource? Thanks.

You can't reference two databases from a single query in Firebird. You
may start a transaction that spans two databases which has a 2 phase
commit. Your client program would need to do the join logic if applicable.