|Subject||Re: [IBO] Handling shared tables among databases|
|Author||Geoff Worboys (TeamIBO)|
> I have several databases and they need several shared tables in aAre you using native or TDataset stuff ???
> 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 ??
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