Nick,

Raising the exception, and trapping it straight after the loop WILL end the
loop, and will NOT end the procedure. Look at the code I sent you.

However, FB has changed the way exceptions are handled, and so any updates
inside the loop may be lost. You'll have to test it.

Vince

----- Original Message -----
From: Nick Upson <uebridger@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, 20 May, 2002 11:03 AM
Subject: Re: [ib-support] should this work?


> I just want to end the loop, not raise a user-visible exception or end the
> procedure.
>
>
> >From: "Vince Duggan" <vince@...>
>
> >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/
> > >
> > >
> >
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp.
>
>
>
> 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/
>
>