Search code examples
sql-server-cewebmatrixnumericcurrencysql-server-ce-4

WebMatrix SQL CE numeric type has zero precision

I created a column in SQL CE database with "numeric" type, precision 10 and scale 5 using WebMatrix. Then, I saved the table, and precision/scale suddenly changed to 0.

When I try to edit them, I receive the following error:

Error
---------------------------
The maximum precision for this type is 0.
---------------------------
OK

Am I doing something wrong, or is it a bug in either WebMatrix or SQL CE?

Update: The bug seems to be fixed with latest WebMatrix version

Solution

  • It's a bug in the database management tools provided by WebMatrix: http://forums.asp.net/t/1690824.aspx/1?WebMatrix+numeric+type+has+0+precision