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
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_va
After struggling with this without any solution for the past 2 dyas.
I will try r.cross
On Tue, Nov 25, 2008 at 4:07 PM, 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 wor
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
cheers,
maning
On Tue, Nov 25, 2008 at 2:34 PM, maning sambale
<[EMA
Hi,
Answering partially to my problem.
I found a way to update columns by from a criteria of another column
like this:
v.info -c overlay_trainingANDforest2002_sq
lDisplaying column types/names for database connection of layer 1:
INTEGER|cat
INTEGER|a_cat
INTEGER|a_value
CHARACTER|a_label
INTEGER