Page 1 of 1

Which transaction is used by IBCQuery.Delete ?

Posted: Mon 14 Jun 2010 10:49
by rmy
I have a TIBCQuery which UpdateTransaction property is connected to a TIBCTransaction component with IsolationLevel = iblReadCommited.
the Transaction property of the IBCQuery is set to default with IsolationLevel = iblReadOnlyCommited (as suggested by Devart Team).
when updating data everything works fine, the UpdateTransaction is used.
when deleting a record from the dataset with IBCQuery.Delete it seems the default transaction is used and an error occurs:
"attempted update during read-only transaction"
changing the IsolationLevel of the default Transaction to iblReadCommited removes the error.
Help says for any operations modifying the dataset the UpdateTransaction is used. Why isn't it used for delete ?

Posted: Mon 14 Jun 2010 13:28
by Dimon
TIBCQuery uses UpdateTransaction to delete a record as well.

Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com.