[GRASS-dev] can there be spaces in DBF table names?

GRASS GIS GRASS GIS developer
1

Hi,

I just tried importing a DBF file with v.in.db. It failed with:

DBMI-DBF driver error:
SQL parser error:
in statement:
select Sample_id, Longitude, Latitude from ss ll
Error in db_open_select_cursor()

ERROR: Cannot open select cursor: 'select Sample_id, Longitude, Latitude
       from ss ll'

The table is in a file called "ss ll.dbf".
If I rename it to remove the space in the name it works fine.
Is this a quoting problem in GRASS or an illegal DBF table name?

?
thanks
Hamish

2

On Mon, 2007-10-08 at 18:13 +1300, Hamish wrote:

Hi,

I just tried importing a DBF file with v.in.db. It failed with:

DBMI-DBF driver error:
SQL parser error:
in statement:
select Sample_id, Longitude, Latitude from ss ll
Error in db_open_select_cursor()

ERROR: Cannot open select cursor: 'select Sample_id, Longitude, Latitude
       from ss ll'

The table is in a file called "ss ll.dbf".
If I rename it to remove the space in the name it works fine.
Is this a quoting problem in GRASS or an illegal DBF table name?

Yes, it's a quoting problem. SQL statements with spaces need to be
enclosed with double quotes.

--
73, de Brad KB8UYR/6 <rez touchofmadness com>