Subject Re: [IBO] Numeric value changed by 0.01 using TwwIBOquery/TwwDBedit.
Author Jason Wharton
> Numeric (13,2) consumes a 32 bit word in IB5 or lang level < 3.

No, much less than that. Numeric( 9, x ) stays in a 32 bit ordinal type. If
you go over this InterBase maps it into a double precision column on the
server. Thus, you will potentially confront rounding issues.

> 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 of
> course now with a 64 bit integer word, larger values can be accurately
> represented.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com