> 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

Max