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@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@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