[Qgis-user] spatialite layer does not show

[Claas Leiner]

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.leiner at gkg-kassel.de
http://www.gkg-kassel.de
----------------------------------------
Unterstützen Sie QGIS
QGIS-DE e.V. | http://qgis.de