Bug report #15886

MSSQL Value Map and NULL value

Added by Andre Jesus over 7 years ago. Updated over 6 years ago.

Category:Edit widget
Affected QGIS version:2.18.0 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:23804


"*Insert NULL value on top*" provide a invalid value for SQL Server, not allowing It to any edit.

Workaround 1:

USe Value Relation and tick "*Allow NULL value*"

Workaround 2:

Use Value Map and set Default Value to "NULL"

Same problem happens in QGIS 2.8.6 also

Related issues

Related to QGIS Application - Bug report #15215: Cannot set value to NULL in value map Closed 2016-07-04


#1 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Andre Jesus over 6 years ago

  • Status changed from Open to Closed

it's related to #15215

#3 Updated by Jürgen Fischer over 6 years ago

Also available in: Atom PDF