Subject | Re: [IBO] Numeric value changed by 0.01 using TwwIBOquery/TwwDBedit. |
---|---|
Author | murmurrer@yahoo.com |
Post date | 2001-06-19T16:57:37Z |
--- In IBObjects@y..., hans@h... wrote:
> Numeric (13,2) consumes a 32 bit word in IB5 or lang level < 3.This gives me an invalid floating point operation.
>
> Max value an 32 integer can hold is +/-2147483647 or 10 digites.
>
> Numeric (13,2) is a decimal integer, thus 123456789.22 can only
> be acurate to 10 digits or 123456789.2
>
> Try 923456789.2, a real mess :)
> IB6 , lang level >= 3 auto changes numberic (13,2) to (18,2) and ofacurately
> course now with a 64 bit integer word, larger values can be
> represented.I do use ib6 dialect 3.