Devart Forums

Hi

I have a very simple question

I use everywhere explicit transaction:
ibcQuery.Transaction.StartTransaction
..
ibcQuery.Open / Query.Execute
..
ibcQuery.Transaction.Commit or Rollback

But the Query.Open works, without the "ibcQuery.Transaction.StartTransaction".
How I set off this behaviour ?

Thanks in advance.

Additional information: i use different ibctransaction for every ibcQuery / ibcSQL.
Usually.

InterBase/Firebird requires an active transaction for any operation with data, even for opening the dataset. So, when calling TIBCQuery.Open, it is checked whether the transaction bound with it is started, and if not - it is started automatically. This is the standard behavior of our components, and it doesn't provide for disabling.

Ok, thanks.

I would like to get error, when dont start the transaction explicit.

Which transaction start automatically in this case ?
ibcQuery.Transaction or ibcConnection.DefaultTransaction ?

The transaction defined in the TIBCQuery.Transaction property will be started automatically.

Thanks for all.

Feel free to contact us if you have any further questions about IBDAC.