Tim wrote:

> /* Stored procedures */
>
>CREATE PROCEDURE "GETFIELDS"
>(
> RECORDNUMBER INTEGER
>)
>RETURNS
>(
> FIELDA VARCHAR(128) CHARACTER SET ASCII,
> FIELDB INTEGER
>)
>AS
>
>BEGIN
> FOR SELECT FIELDA, FIELDB FROM TABLE1
> WHERE
> RECORDNO = :RECORDNUMBER
> INTO
> :FIELDA :FIELDB
> DO
> BEGIN
> SUSPEND;
> END
>END
>
>

But i need to return a set of records, not a single record.

TIA

German.