> Each statement (query) has the ib_transaction
> property. If you don't set it explicitly to a transaction object, it is
> set implicitly to the <defaulttransaction> of the connection object. If
> this is what you did with all of your queries, then all of them are inside
> a single transaction context and all will have their posted work committed
> when the transaction.commit or commitretaining is called.

I'd like to clarify this applies when the connection/database component has
a default transaction assigned. (TIBODatabase and TIB_Database always have
one since it is contained internally.)

But, if you are using TIB_Connection and you don't have a DefaultTransaction
assigned then each statement/dataset will create it's own AutoCommit
internal transaction. TIB_Connection doesn't provide a default transaction
automatically but if you do assign one then it will be as Helen says.

Jason