Sandro's reply to this problem: http://groups.google.com/group/spatialite-users/browse_thread/thread/54adc2057adb59b9#
Noli On 3/16/12, Carlo A. Bertelli (Charta s.r.l.) <[email protected]> wrote: > Tyler is right, if you look at the create statement of your table > (".schema TABLENAME" in sqlite3 cli) you will understand the error: > any operation on spatialite tables besides select need the spatialite > library. Just look at loadable extensions in SQLite wiki > (http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions). > But I think this problem is tied to another one: are you sure you > really need to touch your geometric tables to manage things? I suggest > to analyse your database (yes, despite the fact that SQLite is a > database on a file, it does need some ER analysis) and separate > business data from geometry. You could do anything you want on tables > which are not tied to spatialite user functions and create geometric > views to show your data in QGis. > c > >>> >>> "Error while updating cell value; no such function: RTreeAlign". >>> >> >>Sounds like the other SQLite apps you are using can't find the spatial >> (rtree) libraries. So, effectively, you are trying to open a db with a >> different version of SQLite. >>I'll be curious to know your solution to the problem :) >> >>Tyler > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
