tibctransaction closed the tibcquery

jalmalier_aja · Post by **jalmalier_aja** » Thu 12 Aug 2010 03:35

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;

AlexP · Post by **AlexP** » Thu 12 Aug 2010 11:57

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.