Joy Conner
31st January 2006, 20:40
As best as I can tell, this error occurred while deleting a sales line. Details in attachment.
I trying to track down the cause of this error. Does anyone understand what has happened?
dave_23
31st January 2006, 21:07
-1223 Value will not fit in a FLOAT. The FLOAT data type can accept numbers within a certain range of exponents. The maximum and minimum exponent values are different depending on the host operating system (the range is the same as that supported by the C compiler for double values in this host system). In the current statement, a constant number is being converted for storage in a FLOAT variable or column, and the exponent is too large or too small.
Dave
Joy Conner
31st January 2006, 23:01
We have recently migrated from IVc3 to IVc4. Also, upgraded Informix DB to version 10 making use of Level 2 drivers. Also upgraded porting set.
Can anyone suggest what I can do to fix the cause of this error?
dave_23
1st February 2006, 00:08
Looks like the error is in the data being inserted. so it could be a
driver bug, or it could be a session bug, or it could be legit. need to talk
to support.
Dave