<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bidimailui-charset-is-forced="true"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#ffffff"
text="#000000">
On 19/12/2010 14:44, <a class="moz-txt-link-abbreviated" href="mailto:rvanderweide@worldbank.org">rvanderweide@worldbank.org</a> wrote:
<blockquote
cite="mid:OFCC86D57E.B701CA3A-ON852577FE.00460987-852577FE.0046098D@worldbank.org"
type="cite"><font
face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">
<p style="margin: 0px;">Dear GRASS,</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;">I am using the December 19 (2010) build of
GRASS 6.4 for Windows. I have loaded a vector map (for a country with
approx 20 province boundaries) with an attribute table that contains a
continuous variable at the province level (name of column is
`y2009'). Trying to put the `y2009' variable on the map, i begin with
defining the color grading to be used by means of the following command:</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;">"GRASS 6.4> v.colors map=pse column=y2009
rgb_column=hc2 color=bcyr"</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;">Doing so I get the following error:</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;">"GRASS 6.4> v.colors map=pse column=y2009
rgb_column=hc2 color=bcyr<br>
Creating column <hc2> ...<br>
Scanning values ...<br>
Looking up colors ...<br>
Writing 16 colors ...<br>
DBMI-SQLite driver error:<br>
Error in sqlite3_prepare():<br>
near "SET": syntax error</p>
<p style="margin: 0px;">ERROR: Error while executing: 'UPDATE SET hc2
= '0:0:255' WHERE y2009 =<br>
0.094713'<br>
ERROR: Processing SQL transaction<br>
rm: cannot remove `C://test/poverty/.tmp/636.0_vcol.sql': Permission
denied"</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;">Any idea what is creating the error -- or
what i am doing wrong? Is there a way to get around this/fix it?</p>
<p style="margin: 0px;"> </p>
</font></blockquote>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><br>
</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;">I have a suggestion
that might fix this problem. The v.colors script on line 209 uses the
expression:</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;">grep "^$GIS_OPT_LAYER;"
</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;">to isolate the TABLE
name, and I think that the windows version of grep is confused by the
semicolon ';'.</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;"><br>
</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;">Please locate the
script (should be under %GISBASE\scripts) and open it in an editor.
Then replace line 209 as follows:</p>
<p style="margin-bottom: 0cm; margin-top: 0pt;">(original)</p>
TABLE=`v.db.connect -g map="$GIS_OPT_MAP" layer="$GIS_OPT_LAYER" fs=";"
| grep "^$GIS_OPT_LAYER;" | cut -f2 -d';'`<br>
(change to:)<br>
TABLE=`v.db.connect -g map="$GIS_OPT_MAP" layer="$GIS_OPT_LAYER" fs=";"
| grep "^$GIS_OPT_LAYER" | cut -f2 -d';'`<br>
(just remove the ; from "^$GIS_OPT_LAYER" after grep)<br>
<br>
Let us know if this works.<br>
<br>
Regards,<br>
Micha<br>
<br>
<blockquote
cite="mid:OFCC86D57E.B701CA3A-ON852577FE.00460987-852577FE.0046098D@worldbank.org"
type="cite"><font
face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2">
<p style="margin: 0px;">Many thanks in advance!</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;">Roy</p>
<p style="margin: 0px;"> </p>
<p style="margin: 0px;"> </p>
</font><br>
This mail was received via Mail-SeCure System.<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
grass-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
</body>
</html>