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.
On Thu, 16 Dec 2004 14:10:58 +0100 grit
<grit.schuster@geographie.uni-freiburg.de> wrote:
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
Have you tried another syntax?
This should do:
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
Make sure, that the table is existent in your location/mapset/dbf-folder
db.select table=corinelandcover sql='select * from corinelandcover
where BEREICH_NR=3 and GRUPPE_NR=31 and ART_NR=311'
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
But, trying to run the same sql statement through the interactive db.select user interface does end with an error:
db.select driver=dbf table=corinelandcover sql=echo"SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31 AND ART_NR=311" fs=|| vs=-- nv=NULL
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
I tried to use the "input=filename" option with the same statement. But in this case all records
of the table are selected.
I just don't understand it
Grit
Stephan Holl wrote:
Hello grit,
On Thu, 16 Dec 2004 14:10:58 +0100 grit
<grit.schuster@geographie.uni-freiburg.de> wrote:
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
Have you tried another syntax?
This should do:
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
Make sure, that the table is existent in your location/mapset/dbf-folder
On Thu, 16 Dec 2004 16:03:21 +0100
grit <grit.schuster@geographie.uni-freiburg.de> wrote:
Thanks Stephan!
this works fine using the grass prompt:
db.select table=corinelandcover sql='select * from corinelandcover
where BEREICH_NR=3 and GRUPPE_NR=31 and ART_NR=311'
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
But, trying to run the same sql statement through the interactive db.select
user interface does end with an error:
db.select driver=dbf table=corinelandcover sql=echo"SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31 AND ART_NR=311" fs=|| vs=-- nv=NULL
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
In the tcltk GUI you should:
- leave off the quoting around the whole statement
- don't use "echo"
I think fs= and vs= might have to be single chars?
I reported a similar problem from the GUI last week. I understand it was
subsequently fixed in the CVS.
Michael
On 12/16/04 8:03 AM, "grit" <grit.schuster@geographie.uni-freiburg.de>
wrote:
Thanks Stephan!
this works fine using the grass prompt:
db.select table=corinelandcover sql='select * from corinelandcover
where BEREICH_NR=3 and GRUPPE_NR=31 and ART_NR=311'
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
But, trying to run the same sql statement through the interactive db.select
user interface does end with an error:
db.select driver=dbf table=corinelandcover sql=echo"SELECT * FROM
corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31 AND ART_NR=311" fs=||
vs=-- nv=NULL
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
I tried to use the "input=filename" option with the same statement. But in
this case all records
of the table are selected.
I just don't understand it
Grit
Stephan Holl wrote:
Hello grit,
On Thu, 16 Dec 2004 14:10:58 +0100 grit
<grit.schuster@geographie.uni-freiburg.de> wrote:
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
Have you tried another syntax?
This should do:
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
Make sure, that the table is existent in your location/mapset/dbf-folder
Cheers
Stephan
____________________
C. Michael Barton, Professor of Anthropology
School of Human Evolution and Social Change
PO Box 872402
Arizona State University
Tempe, AZ 85287-2402
USA
thanks very much for your hints.
Installing the CVS solved my problem!
So the queries are working fine now!
Cheers,
Grit
Michael Barton wrote:
I reported a similar problem from the GUI last week. I understand it was
subsequently fixed in the CVS.
Michael
On 12/16/04 8:03 AM, "grit" <grit.schuster@geographie.uni-freiburg.de>
wrote:
Thanks Stephan!
this works fine using the grass prompt:
db.select table=corinelandcover sql='select * from corinelandcover
where BEREICH_NR=3 and GRUPPE_NR=31 and ART_NR=311'
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
But, trying to run the same sql statement through the interactive db.select
user interface does end with an error:
db.select driver=dbf table=corinelandcover sql=echo"SELECT * FROM
corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31 AND ART_NR=311" fs=||
vs=-- nv=NULL
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
I tried to use the "input=filename" option with the same statement. But in
this case all records
of the table are selected.
I just don't understand it
Grit
Stephan Holl wrote:
Hello grit,
On Thu, 16 Dec 2004 14:10:58 +0100 grit
<grit.schuster@geographie.uni-freiburg.de> wrote:
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
Have you tried another syntax?
This should do:
echo "SELECT * FROM corinelandcover WHERE BEREICH_NR=3 AND GRUPPE_NR=31
AND ART_NR=311"|db.select
Make sure, that the table is existent in your location/mapset/dbf-folder
Cheers
Stephan
____________________
C. Michael Barton, Professor of Anthropology
School of Human Evolution and Social Change
PO Box 872402
Arizona State University
Tempe, AZ 85287-2402
USA