[Qgis-user] Spatialite : problems with spatial views

[Alexandre Neto]

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.mezani at 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 at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/qgis-user<http://lists.osgeo.org/mailman/listinfo/qgis-user>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130222/5aae6505/attachment.html>