[Qgis-user] SpatiaLite views

[Antonio Vico]

Hi,

I get problems in spatialite views too. I created views in spatialitegui 
follow the same instructions and I can open the view in qgis but if I 
try to open Attribute table, in all values get "ERROR" (in qgis ubuntu 
12.04 from http://qgis.org/debian-nightly and in osgeo4w (1.8 and 
1.9-dev versions).

I posted this question in a previous post but only Goyo commented, and I 
can't get a solution.

Sorry if this not solve your problem.

On 10/06/13 14:01, Andreas Neumann wrote:
> Hi,
>
> I wanted to create a view with spatial data in SpatiaLite. I can create
> the view by hand in DB-Manager and I created entries in the
> "views_geometry_columns" table.
>
> But when I add the view it is always added as a non-geometry table
> containing only attributes but no geometry.
>
> Am I missing additional entries in some metadata table?
>
> I tried to follow the instructions here:
> http://www.gaia-gis.it/gaia-sins/spatialite-cookbook/html/sp-view.html -
> but it does not work as described here.
>
> I can add the table from the view but all I get is no geometry and
> "Error" content in every cell.
>
> I am using the current QGIS master.
>
> Thank you if you have any idea how to correctly manage views in SpatiaLite.
>
> Andreas
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user