Kevin Stanton wrote:

> Question:
> Should I not rely on the Break statement?

Use LEAVE rather than BREAK. At the BLR level, Firebird implements
labeled loops and leave statements that take a loop label as an
argument. BREAK can only exit one level of loop. Over time, LEAVE will
allow you to choose the loop level you want to exit from... BREAK was
one of the first efforts made to expose underlying capabilities after
Firebird started... a good idea, but one that we didn't think through
quite far enough. LEAVE is the next generation and shows more promise.

Regards,


Ann