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;

But I am getting the following error

count of column list and variable list do not match.
Dynamic SQL Error.
SQL error code = -313.
count of column list and variable list do not match.

I also need to get the latest 3 records

Any help is highly appreciated

Thanks

Muthu Annamalai