Re: Strange Values in Float value.

Posted in 2000

Richard harnden — Fri, 18 Feb 2000 10:37:10 +0000 — source: Informix-list mailing list archive (1991-1998)

Hi What do you get if you do: select lexrate+0 from ledger where ... ? >>> "Richard" <richard@disctronics.co.uk> 02/17/00 05:11pm >>> Hi, I am getting strange values in a float field in a couple of records ; Heres the SQL select lexrate from ledger where leserial = 738808 Heres the result : lexrate ++.00000000000 Alternatively our table browser displays the value as "inf". Has anybody seen these values in their experience ? Is it corruption ? Regards Richard French (Informix 5.10 UC6 )