On Aug 15, 2008, at 10:56 AM, Martin Landa wrote:
Hi,
2008/8/15 Michael Barton <[EMAIL PROTECTED]>:
I've tried this all combinations that I can think of and still get
an error.
So I'm asking the larger community if anyone knows the secret
handshake is
to get v.db.update to put RGB values into a column for coloring
vectors.
I would like to get the following to work.
v.db.update map=fields layer=1 column=area value=0:128:128
where=area>=101
and area<=10000
[...]
this should work
v.db.update map=fields layer=1 column=value value='0:128:128'
where="area>=101 and area<=10000"
Martin
Unfortunately not.
GRASS 6.4.svn (Spearfish60_test):~ > v.db.update map=fields layer=1
column=area value='0:128:128' where="area>=101 and area<=10000"
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected $undefined, expecting $end
or ';' processing ':'
in statement:
UPDATE fields SET area=0:128:128 WHERE area>=101 and area<=10000
Error in db_execute_immediate()
ERROR: Error while executing: 'UPDATE fields SET area=0:128:128 WHERE
area>=101 and area<=10000
'
GRASS 6.4.svn (Spearfish60_test):~ >
_______________________________________________
grass-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-dev
