[GRASSLIST:5175] db.select problem

grit grit.schuster at geographie.uni-freiburg.de
Thu Dec 16 08:10:58 EST 2004


Hello,

could anybody please give me an idea about what I'm doing wrong?
I'm running db.select on the grass prompt with

db.select table=corinelandcover sql='select * from corinelandcover where 
BEREICH_NR=3 and GRUPPE_NR=31 and ART_NR=311'


Running the same sql query on db.select interative the following lines 
are printed:

db.select driver=dbf table=corinelandcover sql='select * from 
corinelandcover where BEREICH_NR=3 and GRUPPE_NR=31 and ART_NR=311' 
fs=|| vs=-- nv=NULL input=/home/grit/sqlstatement
Sorry <*> is not a valid option
Sorry <from> is not a valid option
Sorry <corinelandcover> is not a valid option
Sorry <where> is not a valid option
Sorry, <BEREICH_NR> is not a valid parameter
Sorry <and> is not a valid option
Sorry, <GRUPPE_NR> is not a valid parameter
Sorry <and> is not a valid option
Sorry, <ART_NR> is not a valid parameter

If I try to run this query from an extra file it does'nt work either.

So, what's wrong with this?????


Thanks,
Grit




More information about the grass-user mailing list