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 fo开发者_开发百科r 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
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
精彩评论