It's with a TIB_StoredProcedure, not the TIBOStoredProcedure

Nico


-----Oorspronkelijk bericht-----
Van: Paul Little [mailto:paul.little@...]
Verzonden: woensdag 30 mei 2001 8:53
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Stored proc question


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? ;-)

PL

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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/