Subject | SQL transaction handle |
---|---|
Author | B.D.S. Bell |
Post date | 2001-06-18T18:59:18Z |
Hi everyone,
Can anybody help please, I have a peculiar problem?
I have been using a TIB_StoredProc for some time with no
problems.
I've not made any explicit changes to the way the
transaction works,
set as Isolation := tiCommitted.
The input parameters named for the SQL look correct but I
get the error, on Prepared := true; as...
Invalid Transaction Handle, (Expecting explicit transaction
start)
isc error 335544332.
Before the prepare I have,
with MessageTrn do
if not InTransaction then StartTransaction;
and after the ExecProc, ( which it doesn't reach ),
MessageTrn.Commit;
Any help will be most appreciated.
Thanks
Bryan
[Non-text portions of this message have been removed]
Can anybody help please, I have a peculiar problem?
I have been using a TIB_StoredProc for some time with no
problems.
I've not made any explicit changes to the way the
transaction works,
set as Isolation := tiCommitted.
The input parameters named for the SQL look correct but I
get the error, on Prepared := true; as...
Invalid Transaction Handle, (Expecting explicit transaction
start)
isc error 335544332.
Before the prepare I have,
with MessageTrn do
if not InTransaction then StartTransaction;
and after the ExecProc, ( which it doesn't reach ),
MessageTrn.Commit;
Any help will be most appreciated.
Thanks
Bryan
[Non-text portions of this message have been removed]