[GRASS-user] db.execute where condition

[Frans-Joost Boogert]

Hello Markus
The database is not linked to a vector map so I used
db.describe -c landuse_table

ncols: 6
nrows: 5
Column 1: OBJECTID:INTEGER:11
Column 2: FEATURE:CHARACTER:16
Column 3: A:DOUBLE PRECISION:20
Column 4: CC:DOUBLE PRECISION:20
Column 5: PH:DOUBLE PRECISION:20
Column 6: FEATURE_ID:INTEGER:11

I removed the 'within' quotes and the command line now looks like this:
echo 'UPDATE landuse_table SET FEATURE_ID=1 WHERE
FEATURE=Grazing_land'|db.execute driver=dbf database=$database

Unfortunately this doesn't change the output.
The error still refers to the value Grazing_land not found as a column:
DBMI-DBF driver error:

Column 'Grazing_land' not found
Incompatible types in WHERE condition.
Error in selecting rows
Error in db_execute_immediate()

Thanks in advance,
Frans-Joost