I have a SpatiaLite Database with OSM-Data from planet OSM (imported with the OSM import tool from QGIS 2.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 0
It will appear in the "DB Manager" and in "QspatiaLite" but NOT in QGIS! So I tried 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_points Errors: 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