Hi Sandile, update for the list. From your prompt GRASS 6.4.0RC5+39438 (SRTMDEM):~ >
I see that you installation is older than my version (6.4 from SVN) where the problem has already been solved. I tried with Spearfish: # go into no-data area of raster: g.region n=4919210 s=4919070 w=589620 e=589830 nsres=10 ewres=10 -p g.copy vect=fields,myfields v.db.addcol myfields col="precip double precision" v.rast.stats vector=myfields raster=elevation.10m colprefix=precip ... works ok in SVN. Cheers Markus On Mon, Jul 19, 2010 at 8:53 AM, Sandile Gumede <[email protected]> wrote: > Hi Markus > > Here is the output: > ... > + g.message -v message=Processing category 262 (1/4) > + g.remove MASK --quiet > + GRASS_VERBOSE=0 r.mapcalc MASK=if(catchments_23218.0 == 262, 1, null()) > + unset n min max range mean stddev variance cf_var sum > + r.univar -g map=trmm percentile=90 > + sed s+nan+NULL+g > + eval n=0 null_cells=12 min=-NULL max=-NULL range=-NULL mean=-NULL > mean_of_abs=-NULL stddev=-NULL variance=-NULL coeff_var=-NULL sum=0 > + n=0 null_cells=12 min=-NULL max=-NULL range=-NULL mean=-NULL > mean_of_abs=-NULL stddev=-NULL variance=-NULL coeff_var=-NULL sum=0 > + cf_var=-NULL > + [ 0 -eq 1 ] > + eval value=${n} > + value=0 > + [ 1 -eq 1 ] > + echo prec_n ... > + echo UPDATE catchments SET prec_sum=0 WHERE cat=733; > + expr 4 + 1 > + CURRNUM=5 > + g.message -v Updating the database ... > + db.execute > input=/home/tgumede1/grassdata/Cape_Town/Original/SRTMDEM/PERMANENT/.tmp/tgumede1-desktop/23218.0.sql > database=/home/tgumede1/grassdata/Cape_Town/Original/SRTMDEM/PERMANENT/dbf/ > driver=dbf > DBMI-DBF driver error: > SQL parser error: syntax error, unexpected NULL_VALUE processing 'NULL' > in statement: > UPDATE catchments SET prec_min=-NULL WHERE cat=262 > Error in db_execute_immediate() > > ERROR: Error while executing: 'UPDATE catchments SET prec_min=-NULL WHERE > cat=262' ... _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
