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 <[email protected]> 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 <[email protected]> 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 >> >> > _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
