On 14/04/09 17:29, Peter Löwe wrote:
Hi,
I am using Grass6.3 and the tcltk-GUI:
When displaying a vector layer, the 'query vectors for display' allows to
provide a SQL query.
How can a SQL query of the following kind be entered ?
'my_integer_attribute IN (4,7,19,345,678,111)'
Using "IN" as described above results in an error:
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected NAME processing 'IN'
in statement:
SELECT cat FROM country_FOO WHERE FOO_ID IN (2238509,3358510,445812)
Error in db_open_select_cursor()
-------------------
Using an OR-construction as in
attribute=4 OR attribute=7 OR attribute=19 OR ...
gets pretty soon tedious.
Then don't use the dbf backend. This should work with any of the other
backends:
http://grass.osgeo.org/grass64/manuals/html64_user/sql.html
Moritz
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
