Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 3/11/2007
For: Version 1.01 Build 1
# 2269 DECIMAL 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)

Comments Comments
Actually, 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.

Resolution Resolution
Fixed Problem on 3/13/2007 in version 1.02 build 1

Products Affected Products Affected
ElevateDB 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