Thanks, Alexander!

Does anyone know if I can pass in values to FIRST X SKIP Y, which will get
all the records? ie sometimes I want to limit them, at other times I want
them all?

many thanks,

David





"Alexander V.Nevsky" <ded@...> on 27/10/2003 11:58:59 AM

Please respond to firebird-support@yahoogroups.com

To: firebird-support@yahoogroups.com
cc:
Subject: [firebird-support] Re: Stored procedure - variables for FIRST x
SKIP y??

--- 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




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/