<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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 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 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></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Help to improve QGIS rendering possibilities before Nov 30, 2015
<a 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>
</body>
</html>