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

[X Of]

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 <aperi2007 at gmail.com>:

> 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 <xof.biz at gmail.com>:
> > 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
> > Qgis-user at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
> --
> -----------------
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -----------------
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150810/9fb64908/attachment.html>