Hi list,
trying to manage a vector attribute table, I explored the sqlbuilder
menu (py gui, grass64, quite a bit old svn version -- say 2 months).
My query contains a modulus condition, so I guess I can use the "%"
button, but the query is qualified unvalid.
e.g I need to extract "z" value every 100 m from a contour line "topo"
vector map.
This statement :
SELECT z FROM topo WHERE z % 100 = 0
returns this error message :
SQL statement is not valid.
dbmi: Protocol error
Any idea of what I am doing wrong ?
Thank you,
Vincent.
Whoops, sorry for the noise. I give an auto-reply (may it help ) :
working on a new Location/mapset, I forgot to switch db driver to sth
else than dbf. Modulo seems not to be supported by the dbf driver (it is
a matching operator, dedicated to character fields).
Back to pg driver, the statement is valid.
Bye,
Vincent.
Le mercredi 23 mars 2011 à 08:26 +0100, Vincent Bain a écrit :
Hi list,
trying to manage a vector attribute table, I explored the sqlbuilder
menu (py gui, grass64, quite a bit old svn version -- say 2 months).
My query contains a modulus condition, so I guess I can use the "%"
button, but the query is qualified unvalid.
e.g I need to extract "z" value every 100 m from a contour line "topo"
vector map.
This statement :
SELECT z FROM topo WHERE z % 100 = 0
returns this error message :
SQL statement is not valid.
dbmi: Protocol error
Any idea of what I am doing wrong ?
Thank you,
Vincent.
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user