Subject | Re: [IBO] Numeric value changed by 0.01 using TwwIBOquery/TwwDBedit. |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-06-19T15:16:20Z |
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 :)
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.
================================================================
murmurrer@... wrote:
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 acurately
represented.
================================================================
murmurrer@... wrote:
>
> Using:
> IBO 3.6a
> Infopower 2000
>
> I have a table with a field NUMERIC(13,2)
>
> I put a TwwIBOquery and TwwDbEdit on a form and set requestlive to
> true.
>
> When I enter 123456789.22 and exit the field the value
> is changed to 123456789.21 (??)
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/