> At 09:41 AM 7/10/2009, you wrote:
>>> At 07:55 PM 6/10/2009, you wrote:
>>>>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.
>>>>Using Mysql the syntax is:
>>>><database>.<table>.<field>
>>>>to refer to a database. How can I do this one with Firebird?
>>>
>>> Not this way.
>>>
>>> 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
>>>
>>Can this also be done, in FB 2.5, with "execute statement on external
>>datasource svr:alias with common transaction ..." ?
>>
>>I haven't tried - but intend to
>
> Yes. Note, this is off-topic in this list. If you want more info than
> you can read in the release notes, please ask in firebird-devel.
>
> ^ heLen ^
>

Thanks Helen - the release notes are very adequate :) - I just wanted to
confirm the original query could also be handled this way -> Max