I have a SpatiaLite Database with OSM-Data from planet osm (imported with the OSM import tool from QGIS2.0)
Everything is fine so far. I can create, export, delete tables and draw them in qgis... but when I create a new column in my table with:
ALTER TABLE planet_22_points ADD xlabel integer DEFAULT 0It will appear in the "DB Manager" and in "QspatiaLite" but NOT in QGIS! So I tryed to add a column with QGIS using the attribute table. This actually seems to work, but after saving the table, zack! the columns I was creating before using the SQL command just appears! And that massage comes up:
Could not commit changes to layer planet_22_pointsErrors: SUCCESS: 1 attribute(s) added.ERROR: the count of fields is incorrect after addition/removal of fields!
QGIS 2.0.1, SQLite version: 3.7.9; SpatiaLite Library: 4.1.0
أكثر...
Everything is fine so far. I can create, export, delete tables and draw them in qgis... but when I create a new column in my table with:
ALTER TABLE planet_22_points ADD xlabel integer DEFAULT 0It will appear in the "DB Manager" and in "QspatiaLite" but NOT in QGIS! So I tryed to add a column with QGIS using the attribute table. This actually seems to work, but after saving the table, zack! the columns I was creating before using the SQL command just appears! And that massage comes up:
Could not commit changes to layer planet_22_pointsErrors: SUCCESS: 1 attribute(s) added.ERROR: the count of fields is incorrect after addition/removal of fields!
QGIS 2.0.1, SQLite version: 3.7.9; SpatiaLite Library: 4.1.0
أكثر...