Yes I just noticed that. There wasn't a transaction associated with
the script and the transaction that I thought was associated wasn't.

Thanks.

--- In IBObjects@yahoogroups.com, Lester Caine <lester@l...> wrote:
> Shaq wrote:
>
> > Since I am dynamically creating the script object it has its default
> > values. My code is basically the following:
> >
> > try
> > Transacion.Autocommit := False;
> > Transaction.ServerAutoCommit := False;
> > if not InTransaction then StartTransaction;
> > Script.Execute;
> > Transaction.Commit;
> > except
> > Transaction.Rollback;
> > end;
> >
> > I have a flag in the Script.OnError event letting me know that an
> > error occurred.
> >
> > Its seems pretty straight forward. I don't know what other properties
> > to check.
>
> And just to check - you have that Transaction selected in Script ;)
> What is the actual script and what is being committed even when
there is
> an error?
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services