[Qgis-user] Spatialite : problems with spatial views

[Samy Mezani]

le 22/02/2013 11:57, Alexandre Neto a écrit:
> There, I found out that, for correctly open a spatialite spatial view in
> QGIS, I would need to have a column named ROWID.

Thanks Alexandre,

My problems are partially resolved with your workaround :

1. The spatial index still blocks the load of geometry in QGis. I had to 
remove it before.

2. After adding a rowid, the attributes window show all the values of 
features but I have to wait 70s for 44 features and CPU used at 100%.

3. After adding a rowid, all labels are created.

So Qspatialite should integrate a creation of a rowid to load correctly 
a spatial view in Qgis.
DB Manager continue to not load the geometry even if a rowid is created.

Thanks a lot.

Samy