numeric rounding
D7, RB 11.07, SQL 2005
I have data stored with 5 digits beyond the decimal (example: 1.4321). The
data is stored in the database correctly and when queried in my app or other
utilities it appears correctly.
However, in RB it clips the last digit. It doesn't matter how I change the
format or remove the format, I get a 0 for the 5th digit.
In Data tab, the field shows up as Double with size of 5 although the size
is larger and the scale (beyond decimal) is actually 5.
Any suggestions?
I have data stored with 5 digits beyond the decimal (example: 1.4321). The
data is stored in the database correctly and when queried in my app or other
utilities it appears correctly.
However, in RB it clips the last digit. It doesn't matter how I change the
format or remove the format, I get a 0 for the 5th digit.
In Data tab, the field shows up as Double with size of 5 although the size
is larger and the scale (beyond decimal) is actually 5.
Any suggestions?
This discussion has been closed.
Comments
We have not heard of this issue before. Are you able to recreate it using a
simple empty report containing a single DBText component? If so, please
send the example in .zip format to support@digital-metaphors.com and I'll
take a look at it for you.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
query results and the last digit is missing.
I will send you screen shots and see if that helps.
Thanks
Bob