--- In IBObjects@y..., "Ryan Nilsson-Harding" <nilsson@b...> wrote:

> Hi there,
>
> I'm trying to write my first multiple select SP, and having an
> issue, but I'm sure this is a simple problem. (I can get the SP to
> work using FB Workbench, but not using TIB_DSQL, hence asking here)
>
> The SP query is:
>
> RETURNS (PARTNUM VARCHAR(32))
> FOR SELECT PN FROM ORD_DET
> WHERE ORD_ID = :ord_id
> AND QTYREC < QTYORD
> INTO :PARTNUM
> DO
> SUSPEND;
>
> If I test this using FB Workbench, I get the results I am

expecting,

> but when I use a TIB_DSQL component in my app, I'm getting errors.
> If the SP should return NO records, I get the error:
> "Attempt to fetch past last record in a record stream"
>
> and if the result set should contain records, I get the error:
> "Multiple rows in singleton select"
> But I thought using FOR SELECT DO allows for multiple selects.

Use a TIB_Query rather than a TIB_DSQL.

Eric.