[GRASS-user] problems with db.execute

[Moritz Lennert]

On Wed, April 9, 2008 16:56, Isabel Alfaro Cardozo wrote:
> here i send you the file is a very simple one,  tha error i get is this
> one:
>
>
> db.execute driver=dbf database=$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
> input=/home/cidiat6/RDML/RDM/dbf/sql.sql
> Segmentation fault (core dumped)
> dbmi: Protocol error (invalid table/column name or unsupported column
> type)
>
> GRASS_INFO_ERROR(9925,1): Error while executing: "select * from valvulas
> where elemento = 'valvula 2'
> GRASS_INFO_ERROR(9925,1): "


db.execute is not for select queries. Use db.select for that. Or you can
use v.db.select with the where= option.

Moritz