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 > ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
