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

[Maris Nartiss]

Hi,
before pressing "Verify", You must enter comparison operator. = or LIKE

Maris.

2013/1/21 Margherita Di Leo <dileomargherita at gmail.com>:
> 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.
>
> _______________________________________________
> grass-dev mailing list
> grass-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-dev