[GRASS-user] Re: combining and evaluating vector dbf values

[Markus Neteler]

On Tue, Nov 25, 2008 at 9:07 AM, maning sambale
<emmanuel.sambale at gmail.com> 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