TIBCQuery Execute/ExecSQL uses read-only transaction
Posted: Thu 02 Dec 2010 11:58
Hi,
how could I make TIBCQuery use the UpdateTransaction when the SQL called with execute is an UPDATE/INSERT?
Example:
In this case it uses readOnlyTrans, thus resulting in an error "attempting to update during read-only transaction"
how could I make TIBCQuery use the UpdateTransaction when the SQL called with execute is an UPDATE/INSERT?
Example:
Code: Select all
qy.Transaction := readOnlyTrans;
qy.UpdateTransaction := updTrans;
qy.SQL := 'UPDATE Client SET code=code+1';
qy.Execute;