Thank you Artur

--- In firebird-support@yahoogroups.com, "Artur Anjos" <artur@a...>
wrote:

> Hi Santiago,
>
> > I get the following error:
> > "multiple rows in singleton select"
>
> This means that Fb expects a singleton as result (only one row) but

your

> query results are more than one row.
>
> You will need to change the query, or use a FOR cycle. A small

change to

> your coede will be:
>
>
> /*
> > FOR
> > select pro_PAI_NOMBRE,
> > FAC_NUMERO,
> > FAC_FECHA,
> > PRO_NOMBRE,
> > FAC_TOTALIMPORTE from factura_v
> > order by pro_pai_nombre, FAC_FECHA
> > into :pro_PAI_NOMBRE,
> > :FAC_NUMERO,
> > :FAC_FECHA,
> > :pro_nombre,
> > :FAC_TOTALIMPORTE /* I have removed this here -
> ; */
> > /* This will make your results return to calling */
> > DO SUSPEND;
>
> Artur