Page 1 of 1

tibctransaction closed the tibcquery

Posted: Thu 12 Aug 2010 03:35
by jalmalier_aja
hi .. i was try demo of ibdac ..
buat i have smething problem ..
when i use ticquery and the transaction use tibctransaction
after the transaction is commit
the tibquery is alway close;
is there any way to make the tibcquery not closed after the tibctransaction is commit...

if i use tiboobject(tiboquery) thats is nothing problem

here my code

Code: Select all

try
ibcquery1.post;
ibctransaction1.commit;
except

end;



Posted: Thu 12 Aug 2010 11:57
by AlexP
Hello,


To leave IBCQuery opened after commit, it's necessary to call the IBCTransaction.CommitRetaining method instead of IBCTransaction.Commit. It's connected with the specificity of Interbase.