I spent all afternoon trying to figure out why my complex triggers are working fine in Spatialite-GUI but QGIS refuses to write to the layer. Finally remembered I ran into a similar issue a few months back. Problem is, there's no workaround this time.
I'm using triggers to force a point to snap to the nearest line on another layer, using the midpoint if no geometry is supplied, or the nearest point if it is. Works great in 3.0, but sadly, almost all of the geo functions I'm using (Interpolate Line, Shortest Distance, etc) are not on the list of functions in 2.4.
So... I know there's been discussion about removing the built-in Spatialite from QGIS. That seems to imply there'd be a way to point QGIS at Spatialite installed somewhere else. Does anyone know how to make that happen? Running Windows 7, QGIS 1.7.4. Sorry if it sounds stupid, but I've never compiled anything so I have pretty much no idea what I'm talking about.