At 10:18 AM 25/10/2011, Alan J Davies wrote: >mmbtu=tons*:mmbtu_factor, /* factor is 8.54 supplied from another table > >near the top of SP > select mmbtu*0.002 > from paramfil > into mmbtu_factor, >tons are always <>0 by selection, so mmbtu cannot be 0 > >I come back to the same question - it works with the same data on 2.1 >but not 2.5
Did you change the dialect of the database when you upgraded it? ./hb
