TFloatField and number issue
Posted: Thu 05 Sep 2019 10:09
Hi team,
we recently updated ODAC components from 10.3.9 to 11.0.1 in Delphi 10.3.2.
We encountered a problem updating the value of a NUMBER field through declared TFloatField in TOraQuery.
In a specific example, we execute a post using a DB aware component:
The value in the specific example is 81,21 but the value received by the database is 81,20999999999999.
The problem is that we have an ON BEFORE UPDATE trigger testing the equality of OLD and NEW values of the NUMBER field.
That decimal difference raises an error and blocks the UPDATE.
This problem was introduced in 10.4.10 or 11.0.1, the 10.3.9 doesn't have this issue.
We temporary downgraded to 10.3.9 waiting for the resolution.
Thank you!
Best regards,
Simone Montigiani
Generazione Informatica S.r.l.
we recently updated ODAC components from 10.3.9 to 11.0.1 in Delphi 10.3.2.
We encountered a problem updating the value of a NUMBER field through declared TFloatField in TOraQuery.
In a specific example, we execute a post using a DB aware component:
The value in the specific example is 81,21 but the value received by the database is 81,20999999999999.
The problem is that we have an ON BEFORE UPDATE trigger testing the equality of OLD and NEW values of the NUMBER field.
That decimal difference raises an error and blocks the UPDATE.
This problem was introduced in 10.4.10 or 11.0.1, the 10.3.9 doesn't have this issue.
We temporary downgraded to 10.3.9 waiting for the resolution.
Thank you!
Best regards,
Simone Montigiani
Generazione Informatica S.r.l.