I've found a query entity in our system that seems to round large decimals and remove everything after the decimal if the overall character length is eight or greater.
Example:
If the value is 12345678.90 the query returns 12345679.
The DB structure has the field set to decimal(14,2), the CDT is set to a double with the annotation being decimal(14,2), and if the character length is less than eight then it returns the correct value.
How can I get the DB to return the correct value?
Thanks!
Discussion posts and replies are publicly visible
Its advisable that, if you want to retain the same form of the decimal field from db, always use text field with fixed(). Please find the attached screen to observe the value 12345678.90 variations at different fields.