Re: [Qgis-user] columns in spatialite

2015-11-11 Thread X Of
Am 11.11.2015 um 07:59 schrieb Micha Silver: Unfortunately I easily forget how sql works, so doing "easy" stuff becomes very time consuming and frustrating. I think this is a usual problem for us non-regular SQL-users (for any database-system). To avoid figuring out complex or even simple q

Re: [Qgis-user] QGIS & Spatialite: problem with renewed views

2015-08-10 Thread X Of
Thank you, Matthias, running the SQL-Code from your references UPDATE geometry_columns_statistics set last_verified = 0; SELECT UpdateLayerStatistics('geometry_table_name'); solves my problems and saves me from creating a new name for views, each time I'd like to update one (which is especially c

Re: [Qgis-user] QGIS & Spatialite: problem with renewed views

2015-08-10 Thread X Of
owever ? > > A. > > > 2015-08-09 17:41 GMT+02:00 X Of : > > Dear List > > > > In spatialite, if I renew a view (drop a view and recreate it under the > same > > name but with different content/fields), QGIS somehow is not adapting to > > this new situat

[Qgis-user] QGIS & Spatialite: problem with renewed views

2015-08-09 Thread X Of
Dear List In spatialite, if I renew a view (drop a view and recreate it under the same name but with different content/fields), QGIS somehow is not adapting to this new situation. I am not able to re-import the new view as a layer to QGIS (well, I'm able to re-import, but QGIS only shows the