Bug report #15886

MSSQL Value Map and NULL value

Added by Andre Jesus almost 3 years ago. Updated about 2 years ago.

Status:Closed
Priority:Normal
Assignee:-
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

Description

"*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

History

#1 Updated by Giovanni Manghi over 2 years ago

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

#2 Updated by Andre Jesus about 2 years ago

  • Status changed from Open to Closed

it's related to #15215

#3 Updated by Jürgen Fischer about 2 years ago

Also available in: Atom PDF