Geez!!! 2 days of banging my head I just did with sqlite databrowser in 15 minutes (including create new mapset, download install sqlite, and run concat to the database) Thanks again! And sqlite will be my default db driver for now.
cheers, maning On Wed, Nov 26, 2008 at 6:12 PM, Markus Neteler <[EMAIL PROTECTED]> wrote: > On Wed, Nov 26, 2008 at 10:45 AM, maning sambale > <[EMAIL PROTECTED]> wrote: >> Thanks for bringing some light into this dark FOSS GIS moments. > > :) > Note that SQLite is the default driver in GRASS 7, so those dark moments > shouldn't happen any more in future (mhh, maybe there will be others...). > > Markus > >> On Wed, Nov 26, 2008 at 5:42 PM, Markus Neteler <[EMAIL PROTECTED]> wrote: >>> On Wed, Nov 26, 2008 at 10:40 AM, maning sambale >>> <[EMAIL PROTECTED]> wrote: >>>> So, it's really a limitation inherent to the dbf driver? >>> >>> Yes. DBF != SQL... we hacked in a couple of SQL statements but not entire >>> SQL92. >>> >>>> I guess sqlite it is. Is it possible to g.copy again the vector from the >>>> sqlite Mapset to the dbf Mapset? >>> >>> Sure! >>> >>> Best >>> Markus >>> >>>> cheers, >>>> maning >>>> >>>> >>>> On Wed, Nov 26, 2008 at 5:36 PM, Markus Neteler <[EMAIL PROTECTED]> wrote: >>>>> On Tue, Nov 25, 2008 at 9:07 AM, maning sambale >>>>> <[EMAIL PROTECTED]> wrote: >>>>>> Nearly there but not quite: >>>>>> >>>>>> The final column should combine the values from the 2 columns, am I >>>>>> right that concat doesn't work with dbf? >>>>>> >>>>>> So this doesn't work >>>>>> echo "UPDATE vectormap SET c_COVER = a_COVER || a_value" | db.execute >>>>> >>>>> Did you try the SQLite driver? >>>>> >>>>> Just create a new mapset, define the connection with "db.connect" (see >>>>> manual >>>>> for copy-paste command) and "g.copy" the map from the DBF mapset >>>>> into the sqlite mapset. >>>>> Then the joys of SQL are available. >>>>> >>>>> Markus >>>>> >>>> >>>> >>>> >>>> -- >>>> |---------|----------------------------------------------------------| >>>> | __.-._ |"Ohhh. Great warrior. Wars not make one great." -Yoda | >>>> | '-._"7' |"Freedom is still the most radical idea of all" -N.Branden| >>>> | /'.-c |Linux registered user #402901, http://counter.li.org/ | >>>> | | /T |http://esambale.wikispaces.com/ | >>>> | _)_/L I http://epsg4253.wordpress.com/ | >>>> |---------|----------------------------------------------------------| >>>> >>> >>> >>> >>> -- >>> Open Source Geospatial Foundation >>> http://www.osgeo.org/ >>> http://www.grassbook.org/ >>> >> >> >> >> -- >> |---------|----------------------------------------------------------| >> | __.-._ |"Ohhh. Great warrior. Wars not make one great." -Yoda | >> | '-._"7' |"Freedom is still the most radical idea of all" -N.Branden| >> | /'.-c |Linux registered user #402901, http://counter.li.org/ | >> | | /T |http://esambale.wikispaces.com/ | >> | _)_/L I http://epsg4253.wordpress.com/ | >> |---------|----------------------------------------------------------| >> > > > > -- > Open Source Geospatial Foundation > http://www.osgeo.org/ > http://www.grassbook.org/ > -- |---------|----------------------------------------------------------| | __.-._ |"Ohhh. Great warrior. Wars not make one great." -Yoda | | '-._"7' |"Freedom is still the most radical idea of all" -N.Branden| | /'.-c |Linux registered user #402901, http://counter.li.org/ | | | /T |http://esambale.wikispaces.com/ | | _)_/L I http://epsg4253.wordpress.com/ | |---------|----------------------------------------------------------| _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
