The SQL can not work

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

The SQL can not work

JINHUI
Bonjour,
problems.bmp

Running instruction 1/1 :
CREATE TABLE A AS SELECT * FROM result_L93 WHERE 'Area'>9;
ERROR [Thread-58] (RunnableBackgroundJob.java:73) - Fatal error on the job named Executing script
org.gdms.data.types.IncompatibleTypesException
        at org.gdms.sql.evaluator.NumericEvaluator.doValidate(NumericEvaluators.scala:52)


when I try to use SQL,it not works!

Thanks in advance!!!


Reply | Threaded
Open this post in threaded view
|

Re: The SQL can not work

agouge
I think you need to remove the quotes from 'Area'.

CREATE TABLE A AS SELECT * FROM result_L93 WHERE Area>9;

Best,
Adam


On Wed, Jun 12, 2013 at 5:41 PM, JINHUI [via OrbisGIS] <[hidden email]> wrote:
Bonjour,




Running instruction 1/1 :
CREATE TABLE A AS SELECT * FROM result_L93 WHERE 'Area'>9;
ERROR [Thread-58] (RunnableBackgroundJob.java:73) - Fatal error on the job named Executing script
org.gdms.data.types.IncompatibleTypesException
        at org.gdms.sql.evaluator.NumericEvaluator.doValidate(NumericEvaluators.scala:52)


when I try to use SQL,it not works!

Thanks in advance!!!





If you reply to this email, your message will be added to the discussion below:
http://orbisgis.3871844.n2.nabble.com/The-SQL-can-not-work-tp7574937.html
To start a new topic under OrbisGIS Users, email [hidden email]
To unsubscribe from OrbisGIS, click here.
NAML

Reply | Threaded
Open this post in threaded view
|

Re: The SQL can not work

JINHUI
bingo!I make a crazy error!!!thanks for your guide,good job!!!!

Have a good day!!cool man