[GRASS5] sqlite fails for ADD COLUMN

Otto Dassau dassau at gdf-hannover.de
Wed Mar 1 09:06:52 EST 2006


Hi, 

I use GRASS with sqlite driver and cannot add columns to attribute tables: 

echo "ALTER TABLE ammcom ADD COLUMN area double" | db.execute

DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "ADD": syntax error
ERROR: Error while executing: "ALTER TABLE map ADD COLUMN area double
 
it works with dbf and is also supported by sqlite3, as far as I know. Is it 
possible to change/add this?

  thanks
     Otto




More information about the grass-dev mailing list