[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