[GRASSLIST:8566] db.execute

[Aldo Clerici]

Dear GRASSusers and developers,
I have some questions about db.execute (used with dbf driver).

1) In adding a column to a table with the command:
   echo "ALTER TABLE tablename ADD COLUMN columnname
variabletype"|db.execute
   how can I define the variable of "real" type? "real" is not accepted.
2) In one of the examples of the  manual page, the variabletype "text" is
reported, but actually it is not accepted (varchar(n)is accepted instead).
3) I find the way to add a column but not to delete it. Is the DROP COLUMN
function not implemented?

Finally, a wish. I suppose that many GRASS users will use the dbf database
and I'm sure they would appreciate to have db.execute a bit more powerful
(and the manual page more detailed). For example, a very useful improvement
would be the possibility to do operations in SET of the UPDATE function and
not only assignments.

Many thanks to everybody.

Aldo Clerici