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

Moritz Lennert mlennert at club.worldonline.be
Wed Sep 20 03:43:26 EDT 2006

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."


More information about the grass-user mailing list