Re: ROUNDING PROBLEM 4GL

Posted in 1998

Brian McGinity — Mon, 06 Apr 1998 04:30:31 GMT — source: Informix-list mailing list archive (1991-1998)

On Sat, 28 Mar 1998 12:43:35 GMT, joshua@oklahoma.net (anon) wrote: > > > >Having rounding problem. AIX 3.2 RISC 6000 informix 4.11 >Database netamt decimal(16,4) = 7.475 dec(16, 4) will calculate using 4 places and round to 4 places. dec(16) will calculate using 10 decimal places and then trunc to 2. dec(16,2) will calculate and round to 2 places (works for money.) >when I equate this field to another field defined as decimal or >decimal(16) the new value is 7.48, however in other circumstances the >last digit may be truncated? Help!! > >Thanks > >Joshua > > --Working harder so you don't have too. bmcgin@bellatlantic.net