[GRASSLIST:5180] Re: db.select problem

[Michael Barton]

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 at 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 at 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>