Subject | FIRST clause in Stored Procedure |
---|---|
Author | Marco Lauria |
Post date | 2001-09-22T12:02:35Z |
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:
SELECT FIRST 1 AGE FROM EMPLOYEE WHERE X=:X AND Y=:Y INTO :AGE;
I get an error on "1"
can someone help me with this?
is this normal so are the first and skip clauses usable only in normal queries?
Thanks in advance
Marco Lauria
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:
SELECT FIRST 1 AGE FROM EMPLOYEE WHERE X=:X AND Y=:Y INTO :AGE;
I get an error on "1"
can someone help me with this?
is this normal so are the first and skip clauses usable only in normal queries?
Thanks in advance
Marco Lauria