Ann W. Harrison wrote:

>and for Jonathan Neve.,
>
>One connection can have multiple transaction, but one transaction can not
>have multiple connections. Definitely a 1 to n relationship.
>
>

I don't quite understand. It is possible to do a cross-database
transaction using two-phase commit, right? Are you simply saying that
this is not possible across multiple threads? What's to stop me doing
something like this (with IBX) :

IBDataBase1.Connected:=True;
IBDataBase2.Connected:=True;
IBTransaction1.AddDataBase(IBDataBase1);
IBTransaction1.AddDataBase(IBDataBase2);
IBTransaction1.StartTransaction;

where IBDatabase1 and IBDatabase2 are two different connections to the same database?

Is this not possible across several threads?

Thanks!

Jonathan Neve.