Bug in SDAC 7.2.9
Posted: Mon 11 Jan 2016 20:51
(I see that this appears to be the same issue discussed in the "Critical round error" thread. Sorry for the redundancy)
After I updated to 7.2.9, I found that some data returned from SQL Server were retrieved incorrectly. Some were 10 times too large (when accessed after the query using FieldByName('itemvalue').AsFloat), others were 100 too large, and the rest were correct.
This is using the 64-bit Delphi 10 Seattle compiler, but only AFTER 7.2.9 was installed. The problem does not occur when I used my Delphi 2009 32-bit compiler or after I downgraded my SDAC install to 7.2.8. (I did not try the 32-bit version of 7.2.9 in Delphi 10.)
This is a dangerous problem, as it is not an obvious error until comparisons with known good data are performed. It seems to be a side-effect of the one of the 7.2.9 fixes "Bug with storing some numbers with floating point is fixed".
After I updated to 7.2.9, I found that some data returned from SQL Server were retrieved incorrectly. Some were 10 times too large (when accessed after the query using FieldByName('itemvalue').AsFloat), others were 100 too large, and the rest were correct.
This is using the 64-bit Delphi 10 Seattle compiler, but only AFTER 7.2.9 was installed. The problem does not occur when I used my Delphi 2009 32-bit compiler or after I downgraded my SDAC install to 7.2.8. (I did not try the 32-bit version of 7.2.9 in Delphi 10.)
This is a dangerous problem, as it is not an obvious error until comparisons with known good data are performed. It seems to be a side-effect of the one of the 7.2.9 fixes "Bug with storing some numbers with floating point is fixed".