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