This thread drifted off into some very interesting discussions of
data exchange formats.
But going back to the original problem - new columns, added in SL do
not appear in QGIS:
Sandro Furieri posted on the spatialite-users forum a pretty full
explanation of what is happening, and a suggested solution:
https://groups.google.com/forum/#!topic/spatialite-users/uGDZr1TCTn8
The above link has been added to the hub.qgis.org issue #8923. It
involves only two SQL statements that need be run whenever a
Spatialite database on an exisiting connection is changed (i.e.
"refresh connection"). Perhaps someone on the qgis-dev list can
report the proposed solution to developers?
Thanks,
Micha
On 11/10/2015 04:32 PM, Matthias Kuhn
wrote:
Hi,
You are probably hitting issue 8923. This is more of a spatialite
issue than a QGIS issue. But there is a workaround for it, see
here:
https://hub.qgis.org/issues/8923#note-5
Best regards
Matthias
On 11/10/2015 03:26 PM, Micha Silver
wrote:
I have found that QGIS cannot "see" any spatialite column that
comes after the "geometry" column. When I alter a table, adding
a column in a Spatialite, the new column which is after the
geometry column in the database table just does not appear in
QGIS. If I recreate the table, reordering the columns so that
the geometry is last, all is good again.
Is this a bug? or am I missing something?
It's quite annoying considering that sqlite does not have any
simple way to shuffle the columns around, other than dropping
and recreating the table. And if I have foreign constraints
defined, it becomes a whole row of dominoes that come down...
Thanks,
Micha
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
--
Help to improve QGIS rendering possibilities before Nov 30, 2015
http://www.opengis.ch/2015/11/02/qgis-crowdfunding-2-5d-rendering
This mail was received via Mail-SeCure System.
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
This mail was received via Mail-SeCure System.
--
Micha Silver
Arava Drainage Authority
+972-523-665918
|
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
