Hi, has there been a change in the way division is done since FB 2.1
I realise I may be asking this question in the wrong list, but here goes.
I have an SP which has been running since Feb 2009 every month with not
one failure. Moving this to FB 2.5 results in failure every time.
Basically all my routines are wrapped inside a coalesce statement such
as this:

water_tons = iif(water_pc=0,0,coalesce(tons*water_pc/100,0)),
tons_water_tons = iif(water_pc=0,0.01,tons),
ash_tons = iif(ash_pc=0,0,coalesce(tons*ash_pc/100,0)),
tons_ash_tons = iif(ash_pc=0,0.01,tons),

mmbtu_$ = iif(total_$=0 or tons<=1,0,coalesce(round(total_$/mmbtu,2),0)),

Have I consistently got this wrong and have just been lucky or have I
coded this completely wrong and the divide an integer by zero happens
because the calculation order is different?
The error message is
Arithmetic overflow or division by zero has occurred
......
The code attempted to divide an integer value by an integer divisor of zero.

Any help or advice on defensive coding in a different way gratefully
accepted.

Regards
Alan

--
Alan J Davies
Aldis