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