Subject Re: [IBO] Numeric value changed by 0.01 using TwwIBOquery/TwwDBedit.
Author murmurrer@yahoo.com
--- In IBObjects@y..., hans@h... wrote:
> Numeric (13,2) consumes a 32 bit word in IB5 or lang level < 3.
>
> 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 :)

This gives me an invalid floating point operation.

> IB6 , lang level >= 3 auto changes numberic (13,2) to (18,2) and of
> course now with a 64 bit integer word, larger values can be
acurately
> represented.

I do use ib6 dialect 3.