SELECT FIRST (:numberofarticles) ...

Ivan

----- Original Message -----
From: "Roger Pullen" <rpullen@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, June 29, 2005 4:21 PM
Subject: [firebird-support] FIRST with input parameter


> All
>
> I have written a stored procedure that selects the first 3 items, what I am
> trying to do now is allow the stored procedure to take an input of the
> number of rows to select and use this to pull of x records.
>
>
> Current sql:
> SELECT FIRST 3
>
>
> It doesn't like it if I try to put a parameter in place of the 3
> SELECT FIRST :numberofarticles
>
>
> Regards
>
> Roger