I second Andreas. The Spatialite list is great. You could also use the spatialite-gui: https://www.gaia-gis.it/fossil/spatialite_gui/index
David. On Thu, Mar 15, 2012 at 7:16 AM, Andreas Neumann <[email protected]> wrote: > 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 >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/qgis-user > > > -- > -- > Andreas Neumann > Böschacherstrasse 10A > 8624 Grüt (Gossau ZH) > Switzerland > > _______________________________________________ > 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
