[GRASSLIST:5175] db.select problem

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

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

--
Stephan Holl

Check headers for GnuPG Key!
http://www.gdf-hannover.de

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 :frowning:

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

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?

Hamish

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 :frowning:

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

Phone: 480-965-6262
Fax: 480-965-7671
www: <www.public.asu.edu/~cmbarton>

Hello everyone,

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 :frowning:

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

Phone: 480-965-6262
Fax: 480-965-7671
www: <www.public.asu.edu/~cmbarton>