Subject | Re: [IBO] stored procedure parameter |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-11-18T13:41:14Z |
Hi Pietro,
here (but I don't know the IBOxx components very well, maybe it has
to do with TDataset compatibility).
Try FieldByName.
Greetings,
Paul Vinkenoog
> CREATE PROCEDURE CLIENTI_INIDitta is an output parameter, I'm surprised ParamByName used to work
> 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
here (but I don't know the IBOxx components very well, maybe it has
to do with TDataset compatibility).
Try FieldByName.
Greetings,
Paul Vinkenoog