At 11:25 AM 19-09-01 -0300, C R Zamana wrote:

> Hi!
>
> After using the esql/c for about 1 year I'm now (re)developing
>our RDD interface again using the API: much more power!
>
> The question is: as long as I can have several connections, each
>transaction is "attached" in the context of the connection where
>it has been created?
>
> In othere words: transactions are "independent" of the
>connection in where it has been opened?

No: a transaction always belongs to a specific client connection. In START TRANSACTION the client program gets a transaction handle and has control of that transaction until it issues a COMMIT or ROLLBACK. The server takes care of isolating one transaction from another according to the parameters passed by the client but it doesn't care (or store) which client owns the transaction.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________