[GRASS-user] v.in.db and dbf-tables SQL parser error

[Wolfgang Qual]

Hello Moritz,
aah! Thank you very much - it worked without problems now. I did not know this before (*other* programs do not care about this ;) - maybe it would be reasonable to add a paragraph "requirements for the input table" to the manual page of v.in.db (tablename has to start with a character...)

Best regards,
Wolfgang



-------- Original-Nachricht --------
Datum: Wed, 20 Sep 2006 09:43:26 +0200
Von: Moritz Lennert <mlennert at club.worldonline.be>
An: Wolfgang Qual <Wolfgang.Qual at gmx.net>
Betreff: Re: [GRASS-user] v.in.db and dbf-tables SQL parser error

> Wolfgang Qual wrote:
> > Good morning, GRASS-users, I encountered a problem when using v.in.db
> > with dbf-tables.
> > 
> > GRASS 6.1.cvs (muc_intra):~ > v.in.db driver=dbf database=./
> > table=2006_07_linux x=Quer y=Hoch key=Idcol out=sender47 DBMI-DBF
> > driver error: SQL parser error in statement: select Idcol, Quer, Hoch
> > from 2006_07_linux Error in db_open_select_cursor()
> > 
> > ERROR: Cannot open select cursor: 'select Idcol, Quer, Hoch from 
> > 2006_07_linux'
> > 
> > 
> > I checked the columns in OpenOffice - all named columns in the
> > grass-command where of type numeric with no decimal places. The funny
> > thing is that the same command worked perfectly with another table
> > (this table contained only few records). At the moment, I do not
> > know, what could cause this error - maybe someone else encountered
> > the same problem? Ideas are more than welcome!
> 
>  From http://grass.itc.it/grass62/manuals/html62_user/sql.html
> 
> "A table name must start with a character, not a number."
> 
> Moritz

-- 
NEU: GMX DSL Sofort-Start-Set - blitzschnell ins Internet!
Echte DSL-Flatrate ab 0,- Euro* http://www.gmx.net/de/go/dsl