"Marco Lauria" <mslauria@...> wrote in message
news:5.0.2.1.2.20010922140005.00aad248@......

> Hi,
> I am using Firebird beta 2 under w2k.
> I am using EMS quickdesk latest version to manage it.
>
> Now I have this problem,
> if I use FIRST clause in a SELECT directly in a query I see that it works
> really good,
> but if I try to use FIRST ina Stored Procedure I get an error on the

number

> that goes next to the clause for example:

Using isql:

Use CONNECT or CREATE DATABASE to specify a database
SQL> connect c:/proy/fbtest.gdb;
Database: c:/proy/fbtest.gdb
SQL> set term ^;
SQL> create procedure pfirst returns(a int) as begin
CON> select first 1 rdb$relation_id from rdb$database into :a;
CON> suspend;
CON> end^
SQL> select * from pfirst^

A
============

218

SQL>

You can consider emailing quickdesk support.
:-)

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing