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
