<html style="direction: ltr;">
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;" bidimailui-charset-is-forced="true"
text="#000000" bgcolor="#FFFFFF">
This thread drifted off into some very interesting discussions of
data exchange formats.<br>
<br>
But going back to the original problem - new columns, added in SL do
not appear in QGIS:<br>
Sandro Furieri posted on the spatialite-users forum a pretty full
explanation of what is happening, and a suggested solution:<br>
<br>
<a class="moz-txt-link-freetext" href="https://groups.google.com/forum/#!topic/spatialite-users/uGDZr1TCTn8">https://groups.google.com/forum/#!topic/spatialite-users/uGDZr1TCTn8</a><br>
<br>
The above link has been added to the hub.qgis.org issue #8923. It
involves only two SQL statements that need be run whenever a
Spatialite database on an exisiting connection is changed (i.e.
"refresh connection"). Perhaps someone on the qgis-dev list can
report the proposed solution to developers?<br>
<br>
Thanks,<br>
Micha<br>
<br>
<div class="moz-cite-prefix">On 11/10/2015 04:32 PM, Matthias Kuhn
wrote:<br>
</div>
<blockquote cite="mid:56420005.9090606@opengis.ch" type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
Hi,<br>
<br>
You are probably hitting issue 8923. This is more of a spatialite
issue than a QGIS issue. But there is a workaround for it, see
here:<br>
<a moz-do-not-send="true" 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>
Best regards<br>
Matthias<br>
<br>
<div class="moz-cite-prefix">On 11/10/2015 03:26 PM, Micha Silver
wrote:<br>
</div>
<blockquote cite="mid:5641FE92.8020608@arava.co.il" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=utf-8">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
I have found that QGIS cannot "see" any spatialite column that
comes after the "geometry" column. When I alter a table, adding
a column in a Spatialite, the new column which is after the
geometry column in the database table just does not appear in
QGIS. If I recreate the table, reordering the columns so that
the geometry is last, all is good again.<br>
<br>
Is this a bug? or am I missing something?<br>
<br>
It's quite annoying considering that sqlite does not have any
simple way to shuffle the columns around, other than dropping
and recreating the table. And if I have foreign constraints
defined, it becomes a whole row of dominoes that come down...<br>
<br>
Thanks,<br>
Micha<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" 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>
<pre class="moz-signature" cols="72">--
Help to improve QGIS rendering possibilities before Nov 30, 2015
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opengis.ch/2015/11/02/qgis-crowdfunding-2-5d-rendering">http://www.opengis.ch/2015/11/02/qgis-crowdfunding-2-5d-rendering</a></pre>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<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>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<div dir="LTR">
Micha Silver<br>
Arava Drainage Authority<br>
+972-523-665918
</div>
</div>
</body>
</html>