Helen Borrie wrote:

>
> At 07:59 PM 18-06-01 +0100, you wrote:
>
> >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;
>

I've worked further on this and it appears that the error
only occurs when I run the program in debug mode from
delphi, running the prog stand alone is ok.

Has anybody any Ideas on this and how I might avoid the
error running with the debugger?

Any help much appreciated.

Bryan

[Non-text portions of this message have been removed]