[prev in list] [next in list] [prev in thread] [next in thread] 

List:       qgis-user
Subject:    [Qgis-user] Trouble readings a view from a spatialite db
From:       Andrea Peri <aperi2007 () gmail ! com>
Date:       2015-12-21 14:25:50
Message-ID: CABqTJk_b3W4wyCtFQ9yDBnGvU_R_XM46P5p06uwwga-LdithYw () mail ! gmail ! com
[Download RAW message or body]

Hi,
I'm try to load a spatialite view on a qgis canvas.

QGIS show me the view in the list of available resoures.
When select the view and add to the canvas
I see nothing.
Also I see this error in the log file:

Error executing query: SELECT styleQML FROM layer_styles WHERE
f_table_catalog='D:/progetti/165-progetto-qgis-istat/istat_pop_ind.sqlite'
AND f_table_schema='' AND f_table_name='censpopolazioneindustria1991'
AND f_geometry_column='geom' ORDER BY CASE WHEN useAsDefault THEN 1
ELSE 2 END,update_time DESC LIMIT 1

I dont understand if this is only a warning or a true blocking error.

Infact my db spatialite has no any layer_styles table that is
absolutelly no standard for a spatialite db.
And the phrase in the log "Error executing ..." pehasp is only a wrong phrase.

Is the existence of a layer_style table mandatory for the use of a
spatialit view on tha QGIS desktop ?

Many thx for any help.



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty à èìòù
-----------------
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[prev in list] [next in list] [prev in thread] [next in thread]