<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi xof,<br>
<br>
Maybe this is the same issue like this:
<a class="moz-txt-link-freetext" href="https://hub.qgis.org/issues/8923">https://hub.qgis.org/issues/8923</a>?<br>
<br>
Basically, check if this SQL statements helps to "refresh" your
view's fields:<br>
<a class="moz-txt-link-freetext" href="https://hub.qgis.org/issues/8923#note-5">https://hub.qgis.org/issues/8923#note-5</a><br>
<br>
Cheers,<br>
Matthias<br>
<br>
<div class="moz-cite-prefix">On 08/10/2015 03:17 PM, X Of wrote:<br>
</div>
<blockquote
cite="mid:CACzYBrLqKLb8roNdiHpCa-E4ycqprt26Hy=d8AeddC_+hsg8HQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>Hi Andrea<br>
<br>
</div>
</div>
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.<br>
<br>
</div>
So is it possible that this "add-layer-manager" might be
the source of the problem, maybe?<br>
</div>
Do you think it's worth filing a bug?<br>
<br>
</div>
Thank you for your help<br>
</div>
xof<br>
<div>
<div>
<div>
<div><br>
<br>
<br>
<div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2015-08-09 17:51
GMT+02:00 Andrea Peri <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:aperi2007@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:aperi2007@gmail.com">aperi2007@gmail.com</a></a>></span>:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">Hi xof,<br>
<br>
you are using a gis project ?<br>
I guess more probably the explanation could
be the qgis that save the<br>
fields name and alias in the project.<br>
If you try to start a new project this
happened however ?<br>
<br>
A.<br>
<br>
<br>
2015-08-09 17:41 GMT+02:00 X Of <<a
moz-do-not-send="true"
href="mailto:xof.biz@gmail.com"><a class="moz-txt-link-abbreviated" href="mailto:xof.biz@gmail.com">xof.biz@gmail.com</a></a>>:<br>
> Dear List<br>
><br>
> In spatialite, if I renew a view (drop
a view and recreate it under the same<br>
> name but with different
content/fields), QGIS somehow is not
adapting to<br>
> this new situation. I am not able to
re-import the new view as a layer to<br>
> QGIS (well, I'm able to re-import, but
QGIS only shows the fields that have<br>
> been present in the previous version of
the view, that got dropped).<br>
><br>
> In the db-manager everything is looking
good - I can "manually" query the<br>
> renewed view just fine.<br>
><br>
> I've tried to also delete the view from
the views_geometry_columns-table and<br>
> re-insert it there - QGIS still doesn't
recognize the new view.<br>
><br>
> My only workaround so far ist to create
the new view under a slightly<br>
> different name each time (testview2,
testview3, testview4...).<br>
><br>
> Any help on this topic is highly
appreciated..<br>
> Thank you!<br>
>
_______________________________________________<br>
> Qgis-user mailing list<br>
> <a moz-do-not-send="true"
href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
> <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
--<br>
-----------------<br>
Andrea Peri<br>
. . . . . . . . .<br>
qwerty אטלעש<br>
-----------------<br>
</font></span></blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>