--- In firebird-support@yahoogroups.com, dhay@l... wrote:

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

David, if you know approximately size of the cursor, you can pass in
parameter for First reasonably greater value and 0 in parameter to
Skip. But perhaps using additional flag for IF statement and having
two branches of logic and statements you'll get more effective code.

Best regards,
Alexander.