[Qgis-user] MS/SQL layer in 2D suddenly becomes 3D in QGIS preventing updates ?

[Lars I. Nielsen, LIFA A/S]

Hi list.

I'm stuck in an odd situation.

I just opened a polygon table from my MS/SQL (2016) for editing. It loads without problems.

I then did some node editing, only moving existing nodes. This was saved without problems.

I then tried to add a couple of new nodes, and then QGIS failed in committing the change !?!


I investigated the error, and it seems that (1) QGIS adds a random Z value (17) to my polygon nodes, and (2) inserts a Z value of "nan" on new nodes. Why???


Question 1: How do I force QGIS to not adding a dummy Z to my loaded polygon layer, i.e. work with it as a 2D geometry ?

alternatively:

Question 2: How do I force QGIS to insert a valid value e.g. a "0" for dummy Z values in all new nodes ?


Yes, I have created tables (or actually views) named "geometry_column" in the relevant schemas _and_ dbo, with a value of 2 for "coord_dimension". QGIS seems to disregard this setting.

The updated polygon in MS/SQL (from the first editing) is 2D, as expected.



Med venlig hilsen

Lars I. Nielsen, LIFA A/S
GIS-kons., FME+Python Certified Professional
Geoinformatik
[Beskrivelse: C:\Users\lin\AppData\Roaming\Microsoft\signatures\284x82-3741133837051347070]
T

6313 6800

@

lin at lifa.dk

D

6313 6849

W

www.lifa.dk<http://www.lifa.dk>

M

CVR

20937289


[Beskrivelse: C:\Users\lin\AppData\Roaming\Microsoft\signatures\21x21-3019966288736195652]<https://www.linkedin.com/company/lifa-a-s/>
Følg os på LinkedIn og læs de seneste nyheder fra LIFA A/S
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191107/931fcf0c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 6269 bytes
Desc: image001.gif
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191107/931fcf0c/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 1204 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191107/931fcf0c/attachment.png>