[GRASSLIST:7318] Re: db.execute trouble

[Moritz Lennert]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hamish wrote:
> 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

Would the latest changes to the sql expression parser
(http://grass.itc.it/pipermail/grass5/2005-June/018588.html and
following) change this ?


Moritz

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCv8xZrIrMbm76jD8RAjRaAJ9zRjHH64H+Xd8drobz+44an5/JqwCcCaTU
iiTIzilSB2iyWL/wu3GuMKs=
=TdKv
-----END PGP SIGNATURE-----