Subject RE: [IBO] Stored proc question
Author Nico Callewaert
It's with a TIB_StoredProcedure, not the TIBOStoredProcedure


-----Oorspronkelijk bericht-----
Van: Paul Little [mailto:paul.little@...]
Verzonden: woensdag 30 mei 2001 8:53
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? ;-)


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
> > >the preferred way to get the value ? Should I get that value through
> > >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

Your use of Yahoo! Groups is subject to