[GRASS-user] DBMI-DBF driver error with v.in.ogr grass 6.2.2 (worked with older grass)

[Markus Neteler]

On Mon, Apr 27, 2009 at 4:57 PM, Lev Tarasov <lev at mun.ca> wrote:
> Hi;
>   I'm trying to re-import some shape files that I had originally imported in
> fall 2007 with an older version of grass (not sure which one) but I now get
> a DBMI-DBF driver error with grass 6.2.2. How can I fix this? (Hopefully
> grass will at some point maintain backward compatibility)

(it does)

> Specifically:
>
> GRASS 6.2.2 > v.in.ogr dsn=/u1/wrk/GIS/EAdatoct07.dir/ layer=Time19_NEW2
> out=EA7o19kbb
> Projection of input dataset and current location appear to match.
> Proceeding with import...
> Layer: Time19_NEW2
> DBMI-DBF driver error:
> SQL parser error in statement:
> create table EA7o19kbb (cat integer, ID1 integer, Time integer)
> Error in db_execute_immediate()
> ERROR: Cannot create table: create table EA7o19kbb (cat integer, ID1
>       integer, Time integer)

The problem is that you use a reserved SQL keyword as
column name ("time"). This won't work...
You need to rename the column, with the "cnames" option of
v.in.ogr you can do that on the fly while importing.

Markus