It would be wise not to swallow the exception and do something like this:

> if IB_Transaction2.TransactionIsActive then
> IB_Transaction2.Rollback
> else
> begin
> IB_Transaction2.StartTransaction;
> try
> IB_StoredProcedureUpdateData.ExecProc;
> IBOQueryReport.Prepare;
> IBOQueryReport.Open;
> IB_Transaction2.Commit;
> except
> IB_Transaction2.Rollback;
> Raise;
> end;
> end;

Jason Wharton