Subject | continue_loop |
---|---|
Author | duilio_fos <irel_llc@libero.it> |
Post date | 2003-02-16T12:09:52Z |
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
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