| Subject | Re: [firebird-support] multiple accessa at different databases |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-10-06T09:24:28Z |
At 07:55 PM 6/10/2009, you wrote:
What you can do is access both databases in a single transaction, read the data you want from DB_a into your application and write the update to DB_b. Commit the transaction and it is done. In Firebird, you also have the option to roll back the transaction.
./heLen
>I would know if it is possible to access in the same time at two tables of two different databases. I need using records of a table from database to update a table of a second database.Not this way.
>Using Mysql the syntax is:
><database>.<table>.<field>
>to refer to a database. How can I do this one with Firebird?
What you can do is access both databases in a single transaction, read the data you want from DB_a into your application and write the update to DB_b. Commit the transaction and it is done. In Firebird, you also have the option to roll back the transaction.
./heLen