[Qgis-user] SpatiaLite views

[Goyo]

2013/6/10 Andreas Neumann <a.neumann at carto.net>:
> 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.

Try qspatialite plugin. AFAIK it it is the only straightforward way to
add spatial views. Using other plugins (DB manager, spatialite
manager, Fast SQL query) you have to use a query and specify the
primary key and the geometry column again.

Goyo