Critical round error

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Valgardur
Posts: 164
Joined: Tue 24 Nov 2009 19:33

Critical round error

Post by Valgardur » Sat 19 Dec 2015 14:23

Just updated to 7.2.9 for Delphi 10 Seattle. It seems that any number less than 0.1 is incorrect, all zeroes after the decimal point are ignored, 0.07 returns as 0.7, 0.0008 as 0.8 etc.

For example.. my table holds value 0.07 in a field.. verified by dbForge for SQL (and other tools as well).

However my simple query now returns 0.7 in my application. I also get 0.7 if I execute my query directly with the TMsQuery component in Delphi.

This is correct in 7.2.8. But I also use ODAC and finally got an fix that I have been waiting for... so going back is not an attractive option.

LHSoft
Posts: 104
Joined: Sat 18 Aug 2012 08:33

Re: Critical round error

Post by LHSoft » Mon 21 Dec 2015 05:00

Same problem too.
On Seattle and XE5.
Hope for a fast solution.

best regards
Hans

OlliWW
Posts: 9
Joined: Mon 25 Mar 2013 17:03

Re: Critical round error

Post by OlliWW » Mon 21 Dec 2015 14:31

Same Problem here.

With 6.11 (i upgraded from there to 7.2.9) its ok.

OlliWW
Posts: 9
Joined: Mon 25 Mar 2013 17:03

Re: Critical round error

Post by OlliWW » Wed 23 Dec 2015 10:02

Hey there,

Any Update on this? I mean this is a serious bug, which can cost your customers a lot of trouble. :shock:

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Critical round error

Post by azyk » Wed 23 Dec 2015 15:27

Thank you for the information. We have reproduced this problem and are investigating it. We will notify you about the results as any are available.

Post Reply