Bug report #6994

Can't update NULL numerical MS SQL

Added by Nathan Woodrow about 11 years ago. Updated over 9 years ago.

Assignee:Tamas Szekeres
Category:Data Provider/MSSQL
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:16098


Seems that you can't add or update a numerical field that allows nulls using the attribute table or form. If you try the attribute form doesn't allow you to enter a value into the null field.

Create the following table:

CREATE TABLE [dbo].[test](
[id] [int] IDENTITY(1,1) NOT NULL,
[value] [decimal](10, 3) NULL,
[valuef] [float] NULL,
[valuer] [real] NULL)

  1. Open the layer in QGIS. It doesn't need a geometry column
  2. Open the attribute table
  3. Make the table editable
  4. Click the add button
  5. Try entering a value into any of the fields. The form will stop you.

I'm not 100% sure where the issue is here. I have tried to reproduce it on PostGIS and Spatialite but at the moment it seems to only happen with MS SQL layers.


#1 Updated by Tamas Szekeres almost 11 years ago

This appears to be working for me. Could you check with the latest version?

#2 Updated by Tamas Szekeres almost 11 years ago

  • Status changed from Open to Feedback

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

  • Status changed from Feedback to Closed

closing for the lack of feedback

#4 Updated by Jürgen Fischer over 9 years ago

  • Category set to Data Provider/MSSQL

Also available in: Atom PDF