[GRASS-dev] can there be spaces in DBF table names?
rez at touchofmadness.com
Mon Oct 8 02:00:57 EDT 2007
On Mon, 2007-10-08 at 18:13 +1300, Hamish wrote:
> 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