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 ^