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