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
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.
Hi,
before pressing "Verify", You must enter comparison operator. = or LIKE
Maris.
2013/1/21 Margherita Di Leo <dileomargherita@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
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.
thank you Maris.
Would it be possible to grey out the “verify” and “apply” buttons before the comparison operator has been selected? This would be more intuitive.
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
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.
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.
And … I’d have another wish (pls don’t kill me)
It would be nice if the features selected from the attribute table were highlighted (for example using a different color, i.e. yellow) in the Map Display.
thank you Maris.
Would it be possible to grey out the “verify” and “apply” buttons before the comparison operator has been selected? This would be more intuitive.
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
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.
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.
–
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
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.
2013/1/22 Margherita Di Leo <dileomargherita@gmail.com>:
And .. I'd have another wish (pls don't kill me)
It would be nice if the features selected from the attribute table were
highlighted (for example using a different color, i.e. yellow) in the Map
Display.
possible, but so straightforward
* right click -> Select all
* right click -> Highlight selected features
Thanks! Yes, not so intuitive I would say. Perhaps the highlight could be automatic when features are selected… at least, as a user I would expect so… but maybe other users can have different opinions…
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.
Thanks! Yes, not so intuitive I would say. Perhaps the highlight could
be automatic when features are selected.. at least, as a user I would
expect so.. but maybe other users can have different opinions..
I actually like the fact that I can query the table without automatic highlighting, but I agree that it would be nice to be able to highlight the selected features with one click instead of two. Maybe a solution à la QGIS could be an option: in the table, instead of showing only the tuples that result from the query, show all tuples, but with the query result tuples selected. Then "right click -> Highlight selected features" would be enough to see them in the map.
