[Qgis-user] Spatialite data portability

[Andreas Neumann]

 Hi Walter,

 Unfortunately I can't help. But I suggest that you ask the SpatiaLite 
 cracks at their mailinglist:
 http://groups.google.com/group/spatialite-users

 I am pretty sure they can help you better than we here.

 Good luck!

 Andreas

 On Thu, 15 Mar 2012 12:09:57 +0000, Walter Ludwick wrote:
> Following the consensus opinion of all those who kindly answered my
> inquiry (Re: QGIS Farm Application), i have installed Spatialite and
> managed to export all the data from a layer to a .SQLITE file, and
> then view it from several different SQLite browsers, which confirms
> integrity of data & database structure. This already is a 
> constructive
> step forward (thanks to all those who helped, too numerous already to
> mention :).
>
> Moreover, i have managed to create a database in LibreOffice based
> upon that .sqlite file (after (re)learning more than i really wanted
> to know about ODBC drivers!), which displays all the data as it
> should. This is another good step forward, because -tho the business
> of my farm is predicated on geo-located resources (e.g. a paddock on
> the ground) having certain attributes that are best defined in QGIS
> (e.g. perimeter, area, etc.)- i will still be working with that data
> in spreadsheets on a much more dynamic basis.
>
> However: When i try to edit those .sqlite files from QGIS in another
> tool, i'm running into an error message that varies slightly,
> depending on the editor i use (anything but OO at this point: ODBC is
> too much pain, until i get these other mechanics worked out), but the
> message is essentially this (from SQLiteStudio):
>       "Error while updating cell value; no such function: 
> RTreeAlign".
>
> Presuming that what i am trying to do is in fact possible*;  then i
> am left scratching my head as to why all these SQL tools are having
> this trouble, and where that problematic function is coming from. 
> Does
> that error message suggest anything to you?
>
> * (Of course, if what i am trying to do with such round-trip editing
> is in fact not possible, i would sure appreciate if someone could let
> me know :)
>
> /wl
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland