Bug report #15124
MSSQL Float Fields Don't Allow Decimal Entry on Forms
|Affected QGIS version:||2.14.3||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||23065|
When editing data in an MSSQL table, the form (and browser) does not allow the user to enter a decimal point when editing "float" fields.
Numeric (decimal) fields are fine.
#2 Updated by Damien Smith over 4 years ago
This only occurs with the text edit widget. Tested with Lyon and Master and the problem also exists. The only workaround is to use a "range" widget but then you have to know in advance the number of decimal places required.
Tried changing Locale.
Tested with Windows 7 SP1 x64, SQL 2012, SQL 2014.
#3 Updated by Andre Jesus about 4 years ago
Damien Smith wrote:
This only occurs with the text edit widget.
This behavior happens since 2.8.x. I'm not sure why they made It like that but I think It's to force the user to use the correct decimal separator.
My workaround was:
You have to set It to "Range" / Editable / Min: 0,00 / Max: 9999,0 / Step 0,00
That way you can slide or type directly the value.
And remember to save the style as default so you don't need to do It every time you load the layer