> As for now I only think of dropping another ib_transaction and assign a
> different ib_transaction to each ib_query, other than that do I have
> other way?

If they are to be in separate transactions then this is what you want to do.

The other option is to use the TIB_Connection component instead of the
TxDatabase components and make sure the DefaultTransaction property is left
blank. Then, if you don't assign a dataset's IB_Transaction property it will
get its own unique internal transaction and be independant of all other
dataset's transactions.

I think people do well to explicitly control what datasets go into what
transaction. It's work that is well worth it.

Jason Wharton
www.ibobjects.com