Close, but wrong keyword (replace 'WHERE' with 'WHILE'):

FOR SELECT ..
WHILE .. :wk_hours > 0
DO
BEGIN
...
wk_hours = -1;
end

Regards,
Andrew Ferguson
-- 42.7 percent of all statistics are made up on the spot.

--- In ib-support@y..., "Nick Upson" <uebridger@h...> wrote:
> 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