Subject Re: [IBO] Stored proc question
Author Paul Little
Hi Helen,

That's odd. I use loads of TIBOStoredProcedure components setting the
i/p parameters with ParamByName('param').Astype := value and reading the
results with x := ParamByName('param').Astype. These are called numerous
times and I have never had an error reported. I use D5 prof.

What am I doing right? ;-)


Helen Borrie wrote:
> At 11:30 PM 29-05-01 +1000, I wrote:
> >At 03:05 PM 29-05-01 +0200, you wrote:
> > >Helen,
> > >
> > > One more thing, it's a procedure that is returning a value, is ExecProc
> > >the preferred way to get the value ? Should I get that value through a
> > >IB_Cursor ? It's just a one-record select I'm doing.
> >
> >Well, you >can< do it (and, I think, solve the bug, too, i.e. avoid having to unprepare) by adding a SUSPEND to your stored procedure and using a SELECT from the SP to both execute it and get the return value.
> I should have said "using a TIB_Cursor instead of a TIB_StoredProc".
> Cheers,
> Helen
> All for Open and Open for All
> InterBase Developer Initiative ยท
> _______________________________________________________
> Your use of Yahoo! Groups is subject to