[GRASSLIST:9509] Re: dbf - v.in.ascii import

[Francesco Mirabella]

> > .dbf database. Following the manpage, it seems that the v.in.ascii
> > command is the same whatever is the database I want to connect to, so I
> > type:
> > 
> > #############################################
> > v.in.ascii input=ascii_file.txt output=prova_dbf fs=tab columns='cat integer, x double precision, y double precision, cdp_number varchar(20), line_name varchar(20), acquisition_year varchar(20)' x=2 y=3  cat=1
> > #############################################
> > 
> > but I get:
> > #############################################
> > DBMI-DBF driver error:
> > Incompatible value type.
> > Error in db_execute_immediate()
> > 
> > ERROR: Cannot insert values: insert into prova_ar_dbf values ( 1,
> >        11.919589, 43.679116, 101, 'ar315', 1981)
> 
> I think that cdp_number and acquisition_year are of integer type, not varchar.
> At least they are not quoted.
> 
> Markus



I tried with integer, but I get the same error....

Francesco




> > GRASS 6.0.1 (fogli_geo):~ >
> > #############################################
> > 
> > I think it is related to the names that I want for the columns of the
> > table, but I can't see what to do.
> > 
> > can someone help??
> > 
> > cheers,
> > Francesco
> > 
>