I had the same problem as you, all attributes showed ERROR in the attribute table. I asked here:
http://gis.stackexchange.com/questions/32592/how-to-open-a-spatialite-non-spatial-view-in-qgis And was directed to the following page on Spatialite Cookbook<http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html>. There, I found out that, for correctly open a spatialite spatial view in QGIS, I would need to have a column named ROWID. See if it helps. Alexandre Neto On Fri, Feb 22, 2013 at 10:45 AM, Samy Mezani <samy.mez...@wanadoo.fr>wrote: > le 22/02/2013 11:32, Paolo Cavallini a écrit: > > -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Il 22/02/2013 10:55, Samy Mezani ha scritto: >> >>> Hello all, >>> >>> When I load a valid spatial view from Qspatialite in QGis, I have some >>> problems : >>> >> >> have you tried with DB Manager? >> > > > Yes, but the geometry is not loaded in QGis with DB Manager. There is > "just" a data table, and the attributes window show "ERROR" too (but it's > very slow and qgis use 99% of CPU). > > Thanks. > > Samy > > ______________________________**_________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/**mailman/listinfo/qgis-user<http://lists.osgeo.org/mailman/listinfo/qgis-user> >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user