Subject Re: [ib-support] continue_loop
Author Martijn Tonies
No, it doesn't ... Although it would be a nice
addition.

Alternatively, simply set a flag --

if (flag = 0) then suspend;

This should make things easier to read.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."


> I have written the following sql code in a SP:
>
> for select ... do
> begin
> if (...) /*condition1*/ then
> if (...) /*condition2*/ then
> if (...) /*condition3*/ then
> suspend;
> end
>
> I would love to write instead
>
> for select ... do
> begin
> if (not ...) /*condition1 not met*/ then
> continue_loop;
>
> if (not ...) /*condition2 not met*/ then
> continue_loop;
>
> if (not ...) /*condition3 not met*/ then
> continue_loop;
>
> suspend;
> end
>
>
> Only... statement "continue_loop" (or the like) does not exist. Does
> it ?
>
> Thank you
>
> Duilio Foschi