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