Reported By: Roy Lambert Reported On: 3/11/2007 For: Version 1.01 Build 1
# 2269DECIMAL and NUMERIC Columns Allowing Larger Scale in Values without Rounding Should this field type allow me to enter 4 decimal places?
"_Balance" DECIMAL(20, 2)
CommentsActually, you can "enter" any value you would like into a DECIMAL or NUMERIC column. However, what EDB was not doing was rounding the value to the proper scale that was defined for the column. For example, entering 10.265 into a column with a scale of 2 should result in the column containing the value 10.266. Due to the bug, the value was left alone as 10.265.
ResolutionFixed Problem on 3/13/2007 in version 1.02 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial