[GRASS-dev] syntax for v.db.update???

[Michael Barton]

On Aug 15, 2008, at 10:56 AM, Martin Landa wrote:

> Hi,
>
> 2008/8/15 Michael Barton <michael.barton at asu.edu>:
>> 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):~ >