Subject Re: Escaping a For...Select Loop
Author Adam
--- In firebird-support@yahoogroups.com, "dr_bentonquest"
<bentonquest@m...> wrote:
> Hi there,
>
> Is it possible break out of a For...Select Loop? How?
>
> Thanks in advance,
>
> -Benton

The best solution would be to adjust the query inside the for select
loop so that it only returns the number of rows. You could use the
First N syntax if you wanted to jump out after N loops, or adjust the
where clause if it was based on a particular parameter.

If all else fails you can just call exit

Adam