[GRASS-user] GUI: Use SQL Query - lots of integers from a vector-category ?

[Moritz Lennert]

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