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

[Request Tracker]

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