This sounds to me like your statement is hooking up to a transaction and a
connection where the transaction is not referencing the right connection.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "B.D.S. Bell" <bryan.bell@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, June 19, 2001 7:31 AM
Subject: Re: [IBO] SQL transaction handle


>
>
> 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]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>