Subject | Return from SP always starts Transaction |
---|---|
Author | ehandbury |
Post date | 2002-05-09T03:03:58Z |
Hello,
(IBO4.2Gc, BCB4, FB-1.0-796)
I have a very simple SP (TIB_StoredProc) and everytime I run it and
check TransactionIsActive upon its return, it's always true.
I have reduced the SP to a single line (I = 1;), and still the same
problem.
Can IBO determine if a SP has updated the database or does it
always give the worst-case?
I have changed StoredProcForSelect and StoredProcHasDML to no avail.
TIA. Eric.
(IBO4.2Gc, BCB4, FB-1.0-796)
I have a very simple SP (TIB_StoredProc) and everytime I run it and
check TransactionIsActive upon its return, it's always true.
I have reduced the SP to a single line (I = 1;), and still the same
problem.
Can IBO determine if a SP has updated the database or does it
always give the worst-case?
I have changed StoredProcForSelect and StoredProcHasDML to no avail.
TIA. Eric.