> Hi Alan,
>
> did you try this:
>
> CREATE PROCEDURE GET_top_ten_1
> RETURNS
> (
> nox1 numeric (9,2)
> )
> AS
> begin
> for select
> First 1 nox
> from releases
> order by 1 desc
> into :nox1
> do
> suspend;
> end
>
> Stefan

That's not the point Stefan - you can;t call two rows into 2 variables on
the first call to the row. That's what his problem was.
Alan, You can only do this by select (not with the First clause) but use the
order by clause with an arbitrary counter which exits the SP when the
counter reaches 2. You will also need to select into the same variable and
return 2 rows of this variable, not 2 fields in the one row.
Alan

>
> > -----Ursprüngliche Nachricht-----
> > Von: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] Im Auftrag von
> > Alan.Davies@...
> > Gesendet: Samstag, 30. Juli 2005 08:27
> > An: firebird-support@yahoogroups.com
> > Betreff: [firebird-support] problem using SELECT FIRST N in SP
> >
> > Hi All - can anyone help with this? I want to select the top
> > n from a table which works no problem using a select
> > statement, but fails inside an SP
> >
> > This works with a single value
> >
> > CREATE PROCEDURE GET_top_ten_1
> > RETURNS
> > (
> > nox1 numeric (9,2)
> > )
> > AS
> > begin
> > for select
> > First 1 nox
> > from releases
> > order by nox desc
> > into :nox1
> > do
> > suspend;
> > end
> >
> > This version fails the compile but works fine as a sql
> > statement This is the error message...
> > Dynamic SQL Error
> > SQL error code = -313
> > count of column list and variable list do not match
> >
> > CREATE PROCEDURE GET_top_ten_2
> > RETURNS
> > (
> > nox1 numeric (9,2),
> > nox2 numeric (9,2)
> > )
> > AS
> > begin
> > for select
> > First 2 nox
> > from releases
> > order by nox desc
> > into :nox1,:nox2
> > do
> > suspend;
> > end
> >
> >
> > --
> > Alan J Davies
> > Aldis
> > Tel: +44 (0)1926 842069
> > Mob: +44 (0)7885 372793
> >
> >
> > ------------------------ Yahoo! Groups Sponsor
> > --------------------~-->
> > <font face=arial size=-1><a
> > href="http://us.ard.yahoo.com/SIG=12h5iqi80/M=362131.6882499.7
> > 825260.1510227/D=groups/S=1705115386:TM/Y=YAHOO/EXP=1122711999
> > /A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
> > ">Get Bzzzy! (real tools to help you find a job) Welcome to
> > the Sweet Life - brought to you by One Economy</a>.</font>
> > --------------------------------------------------------------
> > ------~->
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>