|
I am using qgis 2.14.1 on fedora 21 Linux I've done this successfully in older versions of qgis but it's not working now and I don't kjnow why. So I open a spatialite database in DB manager. I can add tables with and without geometry just fine. The problem is when I try to load a query nothing happens. I input the query execute it to make sure it works. Then select Load as new layer. Select a unique key and a geometry column (the geometry is a simple linestring). Then press Load now! Nothing happens! So I added messages to db manager code and everything looks OK but a valid QgsVectorLayer isn't created? So I tried in the python console and QgsVectorLayer("dbname=test.sqlite table=test (geometry)", "test0", "spatialite") works but QgsVectorLayer("dbname=test.sqlite table='select * from test' (geometry)", "test0", "spatialite") Does NOT. Doing QgsVectorLayer("dbname=test.sqlite table='select * from test'", "test0", "spatialite")creates a non geometry table correctly??? Like I said this used to work in older versions of qgis. Anyone know what to check next? |
_______________________________________________ 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
