[GRASS-user] v.db.addcol error

[Martin Landa]

Hi,

2008/8/22 Wesley Roberts <wroberts at csir.co.za>:
> GRASS 6.2.3 (Paper4):~/paper4-data/work/sampling > v.db.addcol map=Flight_line2_clean layer=1 column="ID,INT"
> DBMI-DBF driver error:
> SQL parser error in statement:
> ALTER TABLE Flight_line2_clean ADD COLUMN ID
>
> Error in db_execute_immediate()
>
> ERROR: Error while executing: "ALTER TABLE Flight_line2_clean ADD COLUMN ID
>       "
> ERROR: Cannot continue (problem adding column).

comma is used as column definition delimiter, to add one column use

v.db.addcol map=Flight_line2_clean layer=1 column="ID int"

to add more columns, e.g.

v.db.addcol map=Flight_line2_clean layer=1 column="ID1 int, label varchar(255)"

Cheers, Martin

-- 
Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa *