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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
