Subject Re: Stored procedure - variables for FIRST x SKIP y??
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, dhay@l... wrote:
>
> Hi,
>
> Thanks for previous help on stored procedures - got several running
nicely.
>
> Now trying to pass in parameters for the FIRST x SKIP y part of the
select
> clause. Is this possible?
>
David, when using parameters in First/Skip you should place them in
parenthises like

SELECT FIRST (:N) SKIP (:S) forms.id, forms.title ...

Best regards,
Alexander