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

[Brad Douglas]

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>