Bug report #9145
Range Edit Widget not Selectable for Spatialite Layers.
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Browser | ||
| Affected QGIS version: | 2.0.1 | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 17780 |
Description
Unable to select the Range edit widget for spatialite layers. I've tried with int, small int, and real datatypes and in all cases the dialog is unselectable and states "Attribute has not integer or real attribute type". The range edit widget is selectable for an int field when using a shapefile.
I tested this on:
OS X 10.7.5
This is repeatable by creating a spatialite layer with an integer or float datatype and setting the edit widget to Range in the layer properties for the field.
QGIS version 2.0.1-Dufour QGIS code revision f738351
Compiled against Qt 4.8.5 Running against Qt 4.8.5
Compiled against GDAL/OGR 1.10.1 Running against GDAL/OGR 1.10.1
Compiled against GEOS 3.4.2-CAPI-1.8.2 Running against GEOS 3.4.2-CAPI-1.8.2 r3921
PostgreSQL Client Version 9.2.4 SpatiaLite Version 4.1.1
QWT Version 6.0.2 PROJ.4 Version 480
QScintilla2 Version 2.7.2
Associated revisions
Attribute edit widgets LongLong support
Fix #9145
History
#1
Updated by Torsten Ernst over 10 years ago
There is some other odd behavior I found when exploring this a bit more:
1. DB Manager recognizes the integer field as int, but the field properties at times only recognizes the primary key field as int, while all others are interpreted as text. Sometimes the field properties do interpret the datatypes correctly, but this does not affect whether or not the Range widget can be selected.
2. In one case, by removing the layer and re-adding it I was able to select the Range widget but the spinner was greyed out in the feature edit dialog (during an edit session).
3. When using a QT UI file, the spinner displays and operates correctly, but the data is not saved to layer after edits are saved.
#2
Updated by Matthias Kuhn over 10 years ago
- Status changed from Open to Closed
Fixed in changeset b92e1243399ec5df9ea173d65e7a6509085a1111.
#3
Updated by Matthias Kuhn over 10 years ago
Fixed for the integer case. It seems to work here with real, so if there is also a problem, please reopen this and attach an affected spatialite file if possible.
For the DB manager, please open another bug.