Hi xof, Maybe this is the same issue like this: https://hub.qgis.org/issues/8923?
Basically, check if this SQL statements helps to "refresh" your view's fields: https://hub.qgis.org/issues/8923#note-5 Cheers, Matthias On 08/10/2015 03:17 PM, X Of wrote: > Hi Andrea > > The problem described is independent of projects or restarting QGIS. > The problem is always present already in the window for adding a new > spatialite-layer (ctrl-shift-L). There you can get a list of available > fields, when pushing the button for filtering a table ("Set Filter" > Button)... And this list of available fields is sort of a preview of > what you're going to get when adding the table as a layer to your > qgis-project. > > So is it possible that this "add-layer-manager" might be the source of > the problem, maybe? > Do you think it's worth filing a bug? > > Thank you for your help > xof > > > > > 2015-08-09 17:51 GMT+02:00 Andrea Peri <[email protected] > <mailto:[email protected]>>: > > Hi xof, > > you are using a gis project ? > I guess more probably the explanation could be the qgis that save the > fields name and alias in the project. > If you try to start a new project this happened however ? > > A. > > > 2015-08-09 17:41 GMT+02:00 X Of <[email protected] > <mailto:[email protected]>>: > > 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 > fields that have > > been present in the previous version of the view, that got dropped). > > > > In the db-manager everything is looking good - I can "manually" > query the > > renewed view just fine. > > > > I've tried to also delete the view from the > views_geometry_columns-table and > > re-insert it there - QGIS still doesn't recognize the new view. > > > > My only workaround so far ist to create the new view under a > slightly > > different name each time (testview2, testview3, testview4...). > > > > Any help on this topic is highly appreciated.. > > Thank you! > > _______________________________________________ > > Qgis-user mailing list > > [email protected] <mailto:[email protected]> > > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > -- > ----------------- > Andrea Peri > . . . . . . . . . > qwerty àèìòù > ----------------- > > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
