Hi Reginald,
Sometimes a invalid spatialIndex is a reason, that spatialite layer does
not shown.
Open the DB-manager in QGIS
Klick of your database in the tree and and then open the SQL-Windows
(press F2).
execute this statement in the SQL-Windows of the DB-Manager:
select recoverspatialindex('tablename','geom');
after that execute:
select updatelayerstatistics('tablename');
tablename = name of the spatialite layer
geom = name of the geometry column
Claas
--
-----------------------------------------
GKG-Kassel - Dr.-Ing. Claas Leiner
QGIS-Support und mehr
Geodatenservice, Kartenwerkstatt &
GIS-Schule Kassel
Wilhelmshöher Allee 304 E
34131 Kassel
Tel. 0561/56013445
claas.lei...@gkg-kassel.de
http://www.gkg-kassel.de
----------------------------------------
Unterstützen Sie QGIS
QGIS-DE e.V. | http://qgis.de
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user