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

GRASS GRASS user
1

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!

Best regards,
Wolfgang

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

2

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

3

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 :wink: - 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@club.worldonline.be>
An: Wolfgang Qual <Wolfgang.Qual@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

4

Wolfgang Qual wrote:

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 :wink: - 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...)

Other programs do not care about this when you are limiting yourself to dbf files, but as far as I know the SQL standard forbids numbers for table names and the database drivers in GRASS try to implement that.

We could add such a note to the man page, but would have to do so in the man page of every module that manipulates tables. Thus the idea of having a general grass sql support man page. The v.in.db page should at least link to that man page.

Moritz

Best regards, Wolfgang

-------- Original-Nachricht -------- Datum: Wed, 20 Sep 2006 09:43:26
+0200 Von: Moritz Lennert <mlennert@club.worldonline.be> An: Wolfgang
Qual <Wolfgang.Qual@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

5

Moritz Lennert wrote:

Thus the idea of having a general grass sql support man page. The v.in.db page should at least link to that man page.

Done in CVS.

Moritz