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
Post date 2010-11-21T14:18:10Z
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