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

Brad Douglas rez at touchofmadness.com
Mon Oct 8 02:00:57 EDT 2007

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>

More information about the grass-dev mailing list