<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html style="direction: ltr;">
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body style="direction: ltr;" bidimailui-charset-is-forced="true"
    bidimailui-detected-decoding-type="UTF-8" bgcolor="#ffffff"
    text="#000000">
    <p style="margin-bottom: 0cm; margin-top: 0pt;">On 12/20/2010 12:07
      AM, <a class="moz-txt-link-abbreviated" href="mailto:rvanderweide@worldbank.org">rvanderweide@worldbank.org</a> wrote:<br>
    </p>
    <blockquote
cite="mid:OF24D3083C.4C7A5B9A-ON852577FE.00798939-852577FE.0079893F@worldbank.org"
      type="cite"><font face="Default Sans
        Serif,Verdana,Arial,Helvetica,sans-serif" size="2">
        <div>Hi Hamish and Micha,</div>
        <div> </div>
        <div>Many thanks for your help.</div>
        <div> </div>
        <br>
        <div> </div>
        <div>To follow up on your earlier comment, submitting:
          v.db.connect -g map=pse layer=1 fs=";"<br>
        </div>
        <div>yields: 1/pse;pse;cat;C://test/poverty/sqlite.db;sqlite</div>
        <div> </div>
      </font></blockquote>
    Here's the problem. That slash and "pse" (layer name) after the
    digit '1'. <br>
    Any grep expression with a character following the $GIS_OPT_LAYER
    will fail...<br>
    <br>
    <blockquote
cite="mid:OF24D3083C.4C7A5B9A-ON852577FE.00798939-852577FE.0079893F@worldbank.org"
      type="cite"><font face="Default Sans
        Serif,Verdana,Arial,Helvetica,sans-serif" size="2">
        <div>Does this help?</div>
        <div> </div>
        <div>Thanks again,</div>
        <div> </div>
        <div>Roy</div>
        <div> </div>
        <div><br>
           </div>
        <font color="#990099">-----Hamish <a class="moz-txt-link-rfc2396E" href="mailto:hamish_b@yahoo.com">&lt;hamish_b@yahoo.com&gt;</a>
          wrote: -----<br>
          <br>
        </font>
        <blockquote style="border-left: 2px solid rgb(0, 0, 0);
          padding-left: 5px; padding-right: 0px; margin-left: 5px;
          margin-right: 0px;">To: Micha Silver
          <a class="moz-txt-link-rfc2396E" href="mailto:micha@arava.co.il">&lt;micha@arava.co.il&gt;</a>, <a class="moz-txt-link-abbreviated" href="mailto:rvanderweide@worldbank.org">rvanderweide@worldbank.org</a><br>
          From: Hamish <a class="moz-txt-link-rfc2396E" href="mailto:hamish_b@yahoo.com">&lt;hamish_b@yahoo.com&gt;</a><br>
          Date: 12/19/2010 04:43PM<br>
          Cc: <a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a><br>
          Subject: Re: [GRASS-user] SQL Error using "v.color"<br>
          <br>
          <font face="Default Monospace,Courier New,Courier,monospace"
            size="2">Roy:<br>
            &gt; Hi Micha, To follow up on my problem and your fix, I am
            no longer<br>
            &gt; getting the error message i used to get. When i look at
            the attribute<br>
            &gt; table, however, the RGB_column variable (which i named
            `hc2' in my<br>
            &gt; example) -- created by v.colors -- has a lot of missing
            values. Do<br>
            &gt; you have an idea why this is the case?<br>
            <br>
            one thing to try is to remove the hc2 column (v.db.dropcol)
            and try again.<br>
            what does v.univar say about the numerical column?<br>
            <br>
            <br>
            Hamish<br>
            <br>
            <br>
            <br>
                  <br>
          </font></blockquote>
        <br>
      </font><br>
      This mail was received via Mail-SeCure System.<br>
    </blockquote>
    <br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Micha Silver
Arava Development Co. +972-52-3665918
<a class="moz-txt-link-freetext" href="http://surfaces.co.il">http://surfaces.co.il</a>

</pre>
  </body>
</html>