Critical round error
Posted: 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.
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.