That's because you've only selecting one field, and you've got three fields
to accept values.
If you remove the 'first 3', you can see the problem.
SELECT RECEIPT.RECEIPTNUMBER (one field)
FROM RECEIPT
WHERE RECEIPT.CUSTOMERID = :CUSTOMERID
INTO :RECEIPT1, :RECEIPT2, :RECEIPT3; (three destination fields)

If you want to populate the receipt1,2,3 fields, you'll need to do it in a
loop, assigning one at a time.

Nige.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Muthu Annamalai
Sent: Thursday, 29 June 2006 9:19 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Using First in Stored Procedure


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





__________ NOD32 1.1631 (20060628) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com


[Non-text portions of this message have been removed]