No, dialect was and still is 3
I backed up (after making another copy) installed 2.5.1.26351, then
restored.
I can run on the remote customer server (2.5.1) side-by-side with my
server (2.1) and see a fail - vs - success on the same data.

Its not a regional settings thing either because I also get a failure on
my laptop (2.5.1). My server and laptop are UK settings, the customer
server has US settings.

Looks like I'm going to have to isolate each calculation - not much fun
in some 120 or so.
Thanks all, anyway.
Alan J Davies
Aldis

On 24/10/2011 22:51, Helen Borrie wrote:
> 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
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 2012.0.1834 / Virus Database: 2092/4572 - Release Date: 10/24/11
>