[GRASS-dev] attribute table manager; SQL Builder; SQL statement is not valid.

[Margherita Di Leo]

Hi,

I'm using GRASS 6.4.3svn on Red Hat. Trying to use the SQL Builder, I
always obtain Syntax Error on queries which are self built by the builder...
Example on NC dataset:
map: census_wake2000
I open the attribute table manager from the GUI
I select: SQL Query: Advanced
Columns: TRT2000 -> Get sample -> Value: 050100 (the first on the top) ->
Verify
I get:

SQL statement is not valid.

DBMI-DBF driver error:
SQL parser error: syntax error, unexpected STRING processing ''050100' '
in statement:
SELECT * FROM census_wake2000 WHERE TRT2000 '050100'
Error in db_open_select_cursor()

?

Thanks,
madi

-- 
Margherita DI LEO
Postdoctoral Researcher

European Commission - DG JRC
Institute for Environment and Sustainability (IES). Unit H03 – FRC
Via Fermi, 2749
I-21027 Ispra (VA) - Italy - TP 261

Tel. +39 0332 78 3600
margherita.di-leo at jrc.ec.europa.eu

Disclaimer: The views expressed are purely those of the writer and may not
in any circumstance be regarded as stating an official position of the
European Commission.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20130121/a3e846b2/attachment.html>