[GRASS5] [bug #2976] (grass) db.select in GRASS 6.0.0beta1

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

Subject: db.select in GRASS 6.0.0beta1

the options of the SQL select statement are limitated? I would like to
select of one field of a table and to add these valors with "SUM" but it
doesn't works, I write:

db.select -c sql="select sum(AREA) from parcela"

and I obtain an error in SQL parser statement...

Somebody can help me?

Thanks,

Lourdes

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

On Thu, Feb 10, 2005 at 01:14:46PM +0100, Request Tracker wrote:

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

Subject: db.select in GRASS 6.0.0beta1

the options of the SQL select statement are limitated? I would like to
select of one field of a table and to add these valors with "SUM" but it
doesn't works, I write:

db.select -c sql="select sum(AREA) from parcela"

and I obtain an error in SQL parser statement...

Somebody can help me?

What does

v.db.connect -p parcela

say?

The dbf driver functionality is limited (maybe we should change to
sqlite one day?).

Markus