[GRASS-user] query of character field of vector map in GIS manager

GRASS GRASS user
1

Hi All

is there any way to query by a character field in the vector maps display
area. I'm trying to display only one or a few animals within a population,
but my SQL query gives the error:

DBMI-DBF driver error:
Column 'AM06' not found
Incompatible types in WHERE condition.
Error in selecting rows
Error in db_open_select_cursor()

This works fine for Integer columns. Tried it with and without quotes on the
character field

any ideas?

Thanks

http://www.nabble.com/file/p17329326/Picture%2B4.png
--
View this message in context: http://www.nabble.com/query-of-character-field-of-vector-map-in-GIS-manager-tp17329326p17329326.html
Sent from the Grass - Users mailing list archive at Nabble.com.

2

On Tue, May 20, 2008 at 12:15 AM, knussear <knussear@mac.com> wrote:

is there any way to query by a character field in the vector maps display
area. I'm trying to display only one or a few animals within a population,
but my SQL query gives the error:

DBMI-DBF driver error:
Column 'AM06' not found

I suspect that the caps column name is the problem. This AFAIK
requires extra quoting (or rename with v.db.renamecol to "am06").

Incompatible types in WHERE condition.
Error in selecting rows
Error in db_open_select_cursor()

This works fine for Integer columns. Tried it with and without quotes on the
character field

You used the GUI, right? It's possible that the GUI is "eating" your
quotes, I darkly remember some related discussion in grass-user or
grass-dev. Not sure though.

Personally, I always use non-capital column names to avoid related
problems.

Markus