<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">
The need for improved spatialite plugins aside, I still think that
the QGIS provider for SL should pick up *all* attribute columns,
even those after the geometry column.<br>
<br>
<br>
<div class="moz-cite-prefix">On 11/10/2015 04:42 PM, Bernd
Vogelgesang wrote:<br>
</div>
<blockquote cite="mid:op.x7v24xlsl2i25i@bernd-terra-pc" 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>
<style type="text/css">body { font-family:'DejaVu Sans Mono'; font-size:12px}</style>
<div>Hi Micha,</div>
<div><br>
</div>
<div>yeah, working with spatialite dbs "seriously" is still quite
uncomfortable.</div>
<div>When I try, I mostly have to use all available means to get
the work done: DBManager, QSpatialite, SpatialiteGUI.
Unfortunately I easily forget how sql works, so doing "easy"
stuff becomes very time consuming and frustrating.</div>
<div><br>
</div>
<div>Do you think it would be technically possible to create a
plugin like Table Manager plugin, that records the changes you
want to do to the table and then creates the necessary sql
commands and performs all that stuff in one go?</div>
<div><br>
</div>
<div>Cause this would be sth I really would be interested donating
money on!</div>
<div><br>
</div>
<div>Cheers</div>
<div>Bernd</div>
<div><br>
</div>
<div>Am 10.11.2015, 15:26 Uhr, schrieb Micha Silver
<a class="moz-txt-link-rfc2396E" href="mailto:micha@arava.co.il"><micha@arava.co.il></a>:<br>
</div>
<br>
<blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px
solid; padding-left: 1ex"> 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>
</blockquote>
<br>
<br>
<br>
<div id="M2Signature">
<div>-- </div>
<div>Bernd Vogelgesang<br>
Siedlerstraße 2<br>
91083 Baiersdorf/Igelsdorf<br>
Tel: 09133-825374</div>
</div>
<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>