--- In IBObjects@yahoogroups.com, "constantijnw" <wolfs@x> wrote:

> Hi Steve,
>
> RETURNING_VALUES is a psql language element. Use it inside a stored
> procedure when retrieving returnvalues from another procedure

executed

> there.
>
> Using a TIB_DSQL component you do something like this:
>
> .
> .
> dsql.SQL := 'EXECUTE PROCEDURE spClearIxTables(:INPUTPAR1,.... )';
> dsql.Prepare;
> dsql.ParamByName('INPUTPAR1').AsSomeType := AValue;
> .
> .
> dsql.ExecSQL;
> MyResult := dsql.FIELDByName('PSUCCESS').AsSomeType;

When I do this I get an error "FieldName: pSuccess not found". The
component must need the return parameter defined somewhere.