I think I tried that at one point and did not get reliable results. What I
do is the following:

create exception loop_breaker 'Loop Breaker';

create procedure...

begin
for select....
begin

if (endcondition) then
exception exception_breaker;
end
when any do
begin
a = a;
end
end

----- Original Message -----
From: Nick Upson <uebridger@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, 13 May, 2002 2:07 PM
Subject: [ib-support] should this work?


> as there is no 'next' or 'break' instruction should I be able to do this
> within a dbproc instead to terminate the loop?
>
> FOR SELECT ..
> WHERE .. :wk_hours > 0
> DO
> BEGIN
> ...
> wk_hours = -1;
> end
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>