field calculator results may violate spatialite type contraints

[anitagraser]

It's possible to turn editing on for spatialite layers, use e.g. field calculator or add geometries but it fails saving because spatialite provider is read-only. This is annoying and confuses users because they think it's their mistake.

[jef]

The problem is not reproducable here. Can you post the database?

[jef]

See also ​http://forum.qgis.org/viewtopic.php?f=2&t=6103

[lutra]

A few notes (tested on both linux and xp with qgis trunk and the spatialite sample dataset):

*) add a spatialite vector, open attributes properties and add a column. Save changes. If you open the attribute table the new column do not show (not even in the field calculator). You need to remove the layer and add it again to see the new column (and be able to populate it).

*) as consequence if you add spatialite layer, toggle editing, open the field calculator and try to populate a new column, qgis will fail

Could not commit changes to layer Towns

Errors: SUCCESS: 1 attribute(s) added.
  ERROR: 8101 attribute value change(s) not applied.

[jef]

fixed in r12898.