At 07:52 AM 30-05-01 +0100, you wrote:

>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

Paul,
That's TIBOStoredProcedure, which defines persistent field objects for the Params, just as TDataset does.

The TIB_* datasets have a different architecture, where output columns are instantiated as Fields[] and inputs as Params[]. In lieu of TDataset's PFOs, they are both arrays of TIB_Column objects.

Cheers,

Helen

>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/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________