[GRASSLIST:7316] Re: db.execute trouble

[Hamish]

On Mon, 27 Jun 2005 10:43:02 +0200
"Aldo Clerici" <alcl01 at ipruniv.cce.unipr.it> wrote:

> Dear GRASS community,
> can somebody tell me why the UPDATE operation works with a simple
> assignement like in:
> echo "UPDATE soils SET area=1000 WHERE area > 200"| db.execute
> but return an error with any kind of operation like for example:
> echo "UPDATE soils SET area=area+1 WHERE area > 200"| db.execute
> or even simply:
> echo "UPDATE soils SET area=1+1 WHERE area > 200"| db.execute
> 
> The output error is:
> DBMI-DBF driver error:
> SQL parser error in statement:
> UPDATE suoli SET area=area+1 WHERE area > 200"
> Error in db_execute_immediate ()
> ERROR: Error while executing: "UPDATE suoli SET area=area+1 WHERE area > 200
> "


Only a limited set of SQL functions and operators are currently supported.

Addition is not among them.

see the GRASS SQL help page:
  http://grass.ibiblio.org/grass61/manuals/html61_user/sql.html



Hamish