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

[Matthias Kuhn]

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 <aperi2007 at gmail.com
> <mailto: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
>     <mailto: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 <mailto:Qgis-user at lists.osgeo.org>
>     > http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
>     --
>     -----------------
>     Andrea Peri
>     . . . . . . . . .
>     qwerty àèìòù
>     -----------------
>
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150810/7e5494d2/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150810/7e5494d2/attachment.sig>