Re: Informix 5 to 7 Upgrade

In article <5mk2u1$bob@cssun.mathcs.emory.edu>, richardt@TheMusicStore.co.uk says... >(I think - memory is a bit hazy now). My application had lots of ACE >reports where the users were prompted for an integer. If a character >was entered by mistake (usually a '-' instead of '0', they are adjacent >on the keyboard!), the OnLine engine crashed with the same messages That dimly raises my own recollection; some versions of the Informix 7 engine do have problems with "illegal" numeric conversions. The example I know about was a conversion, if memory serves correctly, of a non-numeric character string to an integer or a double. We fixed the offending ESQL/C code and the problem went away. -- William Harris william@carsinfo.com