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.