Subject | Re: Return values from stored procedure |
---|---|
Author | sgharp |
Post date | 2004-06-01T18:23:27Z |
--- In IBObjects@yahoogroups.com, "constantijnw" <wolfs@x> wrote:
is what I have in the SQL property of the TIB_DSql component:
execute procedure spGetLedgerID(:pVendorID, :pInvoiceNumber);
I don't know where or how to define the return parameter. I've
tried using key words like RETURNS or RETURNING_VALUES but they both
barf.
>The
> > When I do this I get an error "FieldName: pSuccess not found".
> > component must need the return parameter defined somewhere.I need to know how and where to specify the return parameter. This
>
> Strange. I have one erratum:
>
> dsql.sql := ...
> must be: dsql.sql.clear;
> dsql.sql.add('......
>
> I've run a test which worked ok (without extra settings).
> Are you sure 'psuccess' equals the name of the sp's outputpar?
> How does the sp look like?
is what I have in the SQL property of the TIB_DSql component:
execute procedure spGetLedgerID(:pVendorID, :pInvoiceNumber);
I don't know where or how to define the return parameter. I've
tried using key words like RETURNS or RETURNING_VALUES but they both
barf.