[GRASS5] [bug #4136] (grass) sqlite fails for ADD COLUMN

this bug's URL: http://intevation.de/rt/webrt?serial_num=4136
-------------------------------------------------------------------------

Subject: sqlite fails for ADD COLUMN

Platform: GNU/Linux/x86
grass obtained from: Trento Italy site
grass binary for platform: Compiled from Sources
GRASS Version: G61 CVS from 20060103

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

-------------------------------------------- Managed by Request Tracker