Hi Jason

Yes. Iam using TIB_connection component. You got a nice suggestion :-)
What if I assign a IB_transaction to the TIB_connection but leave the
dataset's ib_transaction empty will that give me the same effect as you
suggest? Having using the internal transaction of the dataset ... how do
i set its internal transaction properties like the Isolation ... I want
to set it to Read Committed?

Jason Wharton wrote:

> 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
>