Subject Re: [ib-support] FIRST clause in Stored Procedure
Author hans@hoogstraat.ca
Is it possible that you upgraded but
for some reason it do not take?

----------------------
Marco Lauria wrote:
>
> 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
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/