Subject Re: [IBO] Transactions in IBO, Delphi4
Author lester@lsces.co.uk
> I am trying to send a bunch of seperate insertion queries to three /
> four data tables using IBObjects for Delphi 4 and I need to be able
> to do a Rollback on ALL of theses executions if there is one error,
> but the queries are sent from code and not via any stored proc. Is
> this possible and if so how ?

Just connect them to the same transaction, and use
StartTransaction() to set a controlled operation. Make sure
that the defaults are not AutoCommit, but I think the IBO
even ignores that once a manual start has been specified.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services