Bug report #6994
Can't update NULL numerical MS SQL
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| 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 |
Description
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)
- Open the layer in QGIS. It doesn't need a geometry column
- Open the attribute table
- Make the table editable
- Click the add button
- 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.
History
#1
Updated by Tamas Szekeres almost 12 years ago
This appears to be working for me. Could you check with the latest version?
#2
Updated by Tamas Szekeres almost 12 years ago
- Status changed from Open to Feedback
#3
Updated by Jürgen Fischer over 10 years ago
- Status changed from Feedback to Closed
closing for the lack of feedback
#4
Updated by Jürgen Fischer over 10 years ago
- Category set to Data Provider/MSSQL