Which transaction is used by IBCQuery.Delete ?
Posted: Mon 14 Jun 2010 10:49
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 ?
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 ?