Subject Re: [IBO] Handling shared tables among databases
Author Geoff Worboys (TeamIBO)
> I have several databases and they need several shared tables in a
> System database. How can I handle this with IBO or it is handled in
> IB/FB ?? Is there any chance to do it like Access' link table ??

Are you using native or TDataset stuff ???

Presuming native...

You need a TIB_Connection for each database.

You need a single TIB_Transaction - connect it to each TIB_Connection
involved in the sharing.

Create a TIB_Query for each table - attach to the appropriate
TIB_Connection and to the shared TIB_Transaction.
The SQL in the query can only relate to one database.
However you can apply master-detail links between the queries from
multiple databases and since master-detail can be one-to-one this
gives you the ability to apparently "join" the data - although not use
it in a single grid :-(

You can also do lookups across databases in a similar manner.

By using the shared transaction you take advantage of IB/FB's
"two-phase commit" capability, where changes across multiple databases
are all committed or all rolled back.

Is that what you wanted?

Geoff Worboys - TeamIBO
Telesis Computing