Subject Re: [IBO] stored procedure parameter
Author Paul Vinkenoog
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