[Qgis-user] columns in spatialite

[Matthias Kuhn]

Hi,

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:
https://hub.qgis.org/issues/8923#note-5

Best regards
Matthias

On 11/10/2015 03:26 PM, Micha Silver wrote:
> 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.
>
> Is this a bug? or am I missing something?
>
> 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...
>
> Thanks,
> Micha
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Help to improve QGIS rendering possibilities before Nov 30, 2015
http://www.opengis.ch/2015/11/02/qgis-crowdfunding-2-5d-rendering

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151110/1db0c0de/attachment.html>