I've the following error "Transaction has already been started" (when an
exeption has been raised before) as result of this code:


DBO_DataModule.IB_Transaction1.StartTransaction;
FSQLCommand.InsertSQL.Text := sSQL;

try

FSQLCommand.ExecSQL(ukInsert);
DBO_DataModule.IB_Transaction1.Commit;

except

{this line do not closes transaction}
DBO_DataModule.IB_Transaction1.CancelAll;

{this line closes all queries too}
DBO_DataModule.IB_Transaction1.Close;

end;


How to close a TIB_Transaction component without have the same effect on the
Queries asociated with it?