> There is not much one can do with db.execute these days. The failed > line are commented: > > echo ALTER TABLE $c5 ADD COLUMN contour integer|db.execute > #echo UPDATE $c5 SET contour = 3 + 2 WHERE contour \> 0|db.execute > #echo UPDATE $c5 SET contour = 3 + 2 |db.execute > #echo UPDATE $c5 SET contour = cat + 2 |db.execute > echo UPDATE $c5 SET contour = 2|db.execute
from the GRASS SQL help page: http://grass.ibiblio.org/grass60/manuals/html60_user/sql.html "DESCRIPTION SQL support for GRASS. Supported is a limited set of SQL functions and operators." The supported command set is in fact limited. Severity for this bug should be set to wishlist. Hamish -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]