[GRASS-user] help with v.db.update

[Sharon M]

This is the example provided in the v.db.update man page

g.copy vect=fields,myfields
v.db.addcol myfields col="polynum integer"
v.db.update myfields col=polynum val=42 where="label='V. White#1'"

which returns the error

White#1": -c: line 0: unexpected EOF while looking for
matching `"'
White#1": -c: line 1: syntax error: unexpected end of file


On Wed, Apr 6, 2011 at 4:46 PM, Sharon M <morrisxs09 at gmail.com> wrote:
> No, error message is now...
>
> DBMI-DBF driver error:
> Column 'V' not found
> Incompatible types in WHERE condition.
> Error in selecting rows
> Error in db_execute_immediate()
> ERROR: Error while executing: 'UPDATE myfields SET polynum=42 WHERE label ~ V
> '
>
> On Wed, Apr 6, 2011 at 4:36 PM, Hamish <hamish_b at yahoo.com> wrote:
>> Richard wrote:
>>> The dbf driver doesn't handle "like".
>> ...
>>> If you need more advanced query parameters such as "like",
>>> use a different database driver - pg or mysql.
>>
>> would "~" work?
>>
>>  v.db.update myfields col=polynum val=42 where="label ~ 'V'"
>>
>> ?
>>
>> Hamish
>>
>>
>