--- In firebird-support@yahoogroups.com, "Muthu Annamalai"
<pearlamerica@...> wrote:

>
> Hi,
>
> I am having problem in using First. Here is my SP
>
> SELECT FIRST 3 RECEIPT.RECEIPTNUMBER
> FROM RECEIPT
> WHERE RECEIPT.CUSTOMERID = :CUSTOMERID
> INTO :RECEIPT1, :RECEIPT2, :RECEIPT3;

FOR

SELECT FIRST 3 RECEIPT.RECEIPTNUMBER
FROM RECEIPT
WHERE RECEIPT.CUSTOMERID = :CUSTOMERID
INTO :RECEIPT1

DO
BEGIN
SUSPEND;
END

Adam