Hi, before pressing "Verify", You must enter comparison operator. = or LIKE
Maris. 2013/1/21 Margherita Di Leo <[email protected]>: > 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 > [email protected] > > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-dev _______________________________________________ grass-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-dev
