Hi Micha,
yeah, working with spatialite dbs "seriously" is still quite uncomfortable.
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.
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?
Cause this would be sth I really would be interested donating money on!
Cheers
Bernd
Am 10.11.2015, 15:26 Uhr, schrieb Micha Silver <[email protected]>:
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
--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
_______________________________________________
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
