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