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
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to