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

["Peter Löwe"]

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.

Peter


-- 
Dr. Peter Löwe
<peter.loewe at gmx.de>





Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!* http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a