Thanks Fabio. I will give it a try.

>Hi James,
>
>Read: Thread ID: 767979 Message ID: 767979
>
>
>Not to use Manual transactions. It is a nest of dangerous bugs.
>
>Uses Automatic transaction and explicit transaction commands :
>
>SQLEXEC(h,"IF @@TRANCONT>0 COMMIT")
>
>SQLEXEC(h,"IF @@TRANCONT>0 ROLLBACK")
>
>these are slow, but sure.
>
>Fabio