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.
How i set off the implicit transaction handling
Re: How i set off the implicit transaction handling
Additional information: i use different ibctransaction for every ibcQuery / ibcSQL.
Usually.
Usually.
Re: How i set off the implicit transaction handling
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.
Re: How i set off the implicit transaction handling
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 ?
I would like to get error, when dont start the transaction explicit.
Which transaction start automatically in this case ?
ibcQuery.Transaction or ibcConnection.DefaultTransaction ?
Re: How i set off the implicit transaction handling
The transaction defined in the TIBCQuery.Transaction property will be started automatically.
Re: How i set off the implicit transaction handling
Thanks for all.
Re: How i set off the implicit transaction handling
Feel free to contact us if you have any further questions about IBDAC.