Subject Re: stored procedure parameter
Author pgozzini
--- In IBObjects@yahoogroups.com, Paul Vinkenoog <paul@v...> wrote:
> Hi Pietro,
>
> > CREATE PROCEDURE CLIENTI_INI
> > RETURNS (
> > DITTA VARCHAR(10))
> > AS
> > BEGIN
> > FOR SELECT MIN(DITTA)
> > FROM CLIENTI
> > INTO :DITTA
> > DO
> > BEGIN
> > SUSPEND;
> > END
> > END
> >
> > My code:
> >
> > with CLIENTI_INI do //ibostoredprocedure
> > begin
> > EXECPROC;
> > codric := parambyname('ditta').asstring;
> > end;
> >
> > Code work fine with ver. 4.2.ie and precedent
> > fb 1.5 rc7 delphi 7
> >
> > with 4.3a error is: parameters 'ditta' not found
>
> Ditta is an output parameter, I'm surprised ParamByName used to work
> here (but I don't know the IBOxx components very well, maybe it has
> to do with TDataset compatibility).
>
> Try FieldByName.
>
>
> Greetings,
> Paul Vinkenoog

ibo 4.2.ie
with TIB_STOREDPROC
work fine fieldbyname
with TIBOstoredproc
work fine parambyname

ibo 4.3
with TIBOstoredproc
not work parambyname