[Qgis-user] R: Re: QGIS 2.16 DB Manager and spatialite view

[Enrico Fiore]

Hi,

thanks for the answer, now all work fine

Enrico





----Messaggio originale----

Da: "Carlo A. Bertelli (Charta s.r.l.)" <carlo.bertelli at gmail.com>

Data: 29/09/2016 23.30

A: <qgis-user at lists.osgeo.org>

Ogg: Re: [Qgis-user] QGIS 2.16 DB Manager and spatialite view



Hello Enrico,QGIS implements an older arrangement from the first version of Spatialite. The views share metadata with tables in geometry_columns.I think that QGIS should use the proper metadata table as well. It's time to do it as Spatialite is at version 4 and the views_geometry_columns comes from version 2.4 or so. Probably it could handle both metadata for compatibility, after enforcing the wrong arrangement for years.Anyhow, to solve your problem, just add an entry in geometry_columns.c

On Thu, Sep 29, 2016 at 9:00 PM, Enrico Fiore wrote:
Date: Thu, 29 Sep 2016 16:07:25 +0200 (CEST)

From: Enrico Fiore <enricofiore at libero.it>

To: QGIS User List <qgis-user at lists.osgeo.org>

Subject: [Qgis-user] QGIS 2.16 DB Manager and spatialite view

Message-ID:

        <360816939.108261475158045364.JavaMail.defaultUser at defaultHost>

Content-Type: text/plain; charset="utf-8"



Hi,



I have created a database with spatialite_gui tool, the database has some spatial views created with a code like this



CREATE VIEW comunitorino AS

SELECT c.ROWID as rowid, c.cod_com, c.geometry

from comuni c;



INSERT INTO views_geometry_columns

    (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column,read_only)

  VALUES ('comunitorino', 'geometry', 'rowid', 'comuni', 'geometry',1)



The view can be load in QGIS by 'add spatialite layer' button



The problem is that if I use DB Manager and open the DB the view will not be seen as spatial view.



If I create the view in DB Manger with the "Create a view" button the view will be seen as spatial view.



Where is the mistake?



Thanks



Enrico

-- 
--------------------------------------------------------------------------
Carlo A. Bertelli
   Charta servizi e sistemi per il territorio e la storia ambientale srl 
          Dipendenze del palazzo Doria, 
          vc. alla Chiesa della Maddalena 9/2 16124      Genova (Italy)
          tel./fax +39(0)10 2475439  +39 0108566195  gsm:+39 393 1590711
   e-mail: bertelli at chartasrl.eu      http://www.chartasrl.eu
--------------------------------------------------------------------------








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160930/0f1baa3e/attachment.html>