| Subject | Re: SELECT FIRST :n usage in SP |
|---|---|
| Author | Fabrice Aeschbacher |
| Post date | 2003-07-10T12:12:24Z |
Thanks Dmitry,
Sorry not having read the documentation carefully :-(
I was blinded by the fact that SELECT FIRST 10 ... works without
parenthesis, whereas SELECT FIRST ( :NumRows ) needs them.
Best regards,
Fabrice
Sorry not having read the documentation carefully :-(
I was blinded by the fact that SELECT FIRST 10 ... works without
parenthesis, whereas SELECT FIRST ( :NumRows ) needs them.
Best regards,
Fabrice
> > It seems that using a parameter for a SELECT FIRST :n statement is not
> > allowed in SP. For example:
> >
> > for select first :NumRows SomeField
>
> for select first (:NumRows) SomeField
>
>
> Dmitry