Lester

Thanks for that ! I don't suppose you have a quick example anywhere.
I am a bit of an Interbase newbie !

Tony D

--- In IBObjects@y..., lester@l... wrote:
> > 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