[Qgis-user] Re: Spatialite data portability

[Noli Sicad]

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.) <bertelli at charta.acme.com> 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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>