[GRASS-user] v.rast.stats

Hi

When I’m running the command below I’m getting some errors, I pasted them
below
v.rast.stats -ec vector=catchments raster=rainfall colprefix=rain_cols percentile=90

DBMI-DBF driver error: SQL parser error: syntax error, unexpected NULL_VALUE
processing ‘NULL’
in statement: UPDATE catchments SET rain_cols_=-NULL WHERE cat=1
Error in db_execute_immediate
ERROR: Error while executing: ‘UPDATE catchments SET rain_cols_=-NULL WHERE
cat=1’


Kind Regards
TS Gumede
Student Researcher
Meraka Institute, CSIR
office : 012 841 2606
mobile : 072 258 1650

On Fri, 4 Jun 2010, Sandile Gumede wrote:

  in statement: UPDATE catchments SET rain_cols_=-NULL WHERE cat=1

   Do you really mean '-NULL'? I've never seen NULL negated before.

Rich

Hi

When I’m running the command below I’m getting some errors, I pasted them
below
v.rast.stats -ec vector=catchments raster=rainfall colprefix=rain_cols percentile=90

DBMI-DBF driver error: SQL parser error: syntax error, unexpected NULL_VALUE
processing ‘NULL’
in statement: UPDATE catchments SET rain_cols_=-NULL WHERE cat=1
Error in db_execute_immediate
ERROR: Error while executing: ‘UPDATE catchments SET rain_cols_=-NULL WHERE
cat=1’

Hi Sandile
Is there raindata for all the catchments? Do they cover the same region?
i.e. maybe you can post the output of each of these:
g.region -p
v.info -g catchments
r.info -g rainfall

···
-- 
Micha Silver
Arava Development Co. +972-52-3665918
[http://www.surfaces.co.il](http://www.surfaces.co.il)