Subject Re: [firebird-support] FOR SELECT Commands to skip to the next record without any further processing of code contained between the BEGIN END markers
Author Markus Ostenried
On Sun, Nov 21, 2010 at 14:13, SoftTech <miket@...> wrote:
> I'm aware of the LEAVE command that will allow me to exit a FOR SELECT loop
> inside of my store procedure.
>
> Is there a command that will allow me to skip any further processing of code
> contained within the BEGIN END markers and simply process the next record?
> I cannot find my documentation on firebird.  I though maybe NEXT, SKIP, or
> LOOP might be the command, but it is not.

Looks like this hasn't been implemented yet:
http://tracker.firebirdsql.org/browse/CORE-1209

Until then you'll have to use the workaround described in the tracker item.

HTH,
Markus