Re: adoquery reads an access number wrongly

Article View: borland.public.cppbuilder.database.ado

Article #4487

Back to borland.public.cppbuilder.database.ado Previous Next

#4487

From: Vassiliev V.V.
Date: Thu, 10 Jan 2002 08:48

25 lines
1692 bytes

That is because of internal float number representation. Use Precision or
DisplayFormat properties of TFloatField.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

<Joel> �������/�������� � �������� ���������: news:3c3c4cd6_2@dnews...
> I have a column in a table that accepts numbers with
> decimal places. the problem is when i read that number
> AsString or AsFloat it isn't the correct number.
> Ex: orginal number 10,36
>     number read    10,3599909340304
>
> or                 10,3600000000457575
>
> Something like that!
> I found a solution for this using Int and puting a comma in it. But
> it is a very painfull thing to do (can't use DefaultOnCellDraw!).
>
>  Thanks
>
> Joel Alexandre
> Lisbon , Portugal
>

Technical Details

Message-ID: <3c3d6144_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!213.204.128.162!news000.worldonline.se!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3c3c4cd6_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,e087f0856d4c5f44
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-10 01:51:00 PST
From: "Vassiliev V.V." <vv_vas@iname.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c3c4cd6_2@dnews>
Subject: Re: adoquery reads an access number wrongly
Date: Thu, 10 Jan 2002 11:48:54 +0300
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
x-mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.118.137.231
Message-ID: <3c3d6144_2@dnews>
X-Trace: dnews 1010655556 62.118.137.231 (10 Jan 2002 01:39:16 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!213.204.128.162!news000.worldonline.se!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message