<div dir="ltr">Yes Nicolas, that works fine. The error appears to lie within the <i>Identify Features</i> tool.  If I knew how I'd write a ticket for it.<br><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div>Thank you for your consideration.  If I knew how I'd write a ticket for it.</div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On 7 June 2016 at 14:34, Nicolas Cadieux <span dir="ltr"><<a href="mailto:nicolas.cadieux@archeotec.ca" target="_blank">nicolas.cadieux@archeotec.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><p dir="ltr">Hi,<br>
You could trouble shoot by changing the E to another letter to see if that changes anything...<br>
Nicolas</p>
<div class="gmail_quote"><span class="">On Jun 7, 2016 5:46 AM, "Chris Berens [via OSGeo.org]" <<a href="http:///user/SendEmail.jtp?type=node&node=5270380&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>> wrote:<br type="attribution"></span><blockquote style="border-left:2px solid rgb(204,204,204);padding:0px 1em"><span class="">

        <div dir="ltr"><div><div><div>Hi Nicolas,<br><br></div>The fields are both TEXT.<br><br></div>Regards,<br></div>Chris<br></div></span><div><span class=""><br clear="all"><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Chris Berens, GISc<br></div><div><a href="http://www.mapland.co.za" rel="nofollow" link="external" target="_blank">www.mapland.co.za</a><br></div><div><a href="tel:%2B27%20%280%2982%20567%209322" value="+27825679322" target="_blank">+27 (0)82 567 9322</a><br></div></div></div></div></div></div></div></div></div></div>
<br></span><div><span class="">On 6 June 2016 at 16:17, Nicolas Cadieux <span dir="ltr"><<a href="/user/SendEmail.jtp?type&#61;node&amp;node&#61;5270344&amp;i&#61;0">[hidden email]></span> wrote:<br></span><blockquote style="border-left:2px solid rgb(204,204,204);padding:0px 1em"><span class="">
  
    
  
  
    Hi,<br>
    My guess is that the value where imported from a csv with no field
    type value.  Therefore, text values could have been imported as
    float values in the shape file.  What is the field type for both
    your files?<br>
    Nicolas<br>
    <br>
<a href="https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/" rel="nofollow" link="external" target="_blank">https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</a><div><div><br>
    <br>
    <div>Le 2016-06-06 06:13, Chris Berens [via
      OSGeo.org] a écrit :<br>
    </div>
    </div></div></span><blockquote style="border-left:2px solid rgb(204,204,204);padding:0px 1em"><div><div>
      <div dir="ltr"><span class="">
        <div>Hi there,</div>
        <div><br>
        </div>
        <div>I have a layer of homes (roofs) and a list of residents who
          are linked to a home by the roof number.  The homes are
          attributed via a re-blocking exercise running 1-31 and A-J,
          eg. 18G is a block. Within each block there may be up to 100
          homes, eg. 18G-47.</div>
        <div><br>
        </div>
        <div>So under Project Properties I set up a relation called
          'households' and using the Identify Features tool I can view
          the members of a household by clicking on the roof. Works
          great, most of the time.</div>
        <div><br>
        </div>
        <div>When I click on an E block roof (eg 18E-23) it returns all
          291 XXE-XX residents on the list.  It appears to me as if the
          relation is reading the values as scientific notation numeric
          values instead of the declared text status in both files.</div>
        <div><br>
        </div>
        <div>I have an <i>Attribute table</i> in the a <i>Composer</i>
          window in the same <i>project</i> that references the same
          relation perfectly, ie it only returns the residents
          particular to eg 18E23.  So is the <i>Identify Features</i>
          tool using a different select rule set or parameters?</div>
        <div><br>
        </div>
        <div>I have tried to search for a previous thread on this topic
          without success. The pain would appear to be for me alone, but
          can anyone suggest a way of defining a relation to avoid this?</div>
        <div><br>
        </div>
        <div>FWIW I'm using 2.14.3-64bit on Win7, this behaviour is true
          for sqlite and shp formats.</div>
        <div><br>
        </div>
        <div>Thank you for your attention,</div>
        <div>Chris</div>
        <br>
        Chris Berens, GISc<br>
        <a href="http://www.mapland.co.za" rel="nofollow" link="external" target="_blank">www.mapland.co.za</a><br></span>
        <a href="tel:%2B27%20%280%2982%20567%209322" value="<a href="tel:%2B27825679322" value="+27825679322" target="_blank">+27825679322</a>" target="_blank"><a href="tel:%2B27%20%280%2982%20567%209322" value="+27825679322" target="_blank">+27 (0)82 567 9322</a></div>
      <br></div></div>
      _______________________________________________
      <br>
      Qgis-user mailing list
      <br>
      <a href="http:///user/SendEmail.jtp?type&#61;node&amp;node&#61;5270096&amp;i&#61;0">[hidden email]
      <br><span class="">
      List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
      Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
      <br>
      <br>
      <hr noshade size="1">
      <div style="color:rgb(68,68,68);font:12px "tahoma","geneva","helvetica","arial",sans-serif">
        <div style="font-weight:bold">If you reply to this email, your
          message will be added to the discussion below:</div>
        <a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html" rel="nofollow" link="external" target="_blank">http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html</a>
      </div>
      </span><div style="color:rgb(102,102,102);font:11px/1.5em "tahoma","geneva","helvetica","arial",sans-serif;margin-top:0.4em">
        To start a new topic under Quantum GIS - User, email
        <a href="http:///user/SendEmail.jtp?type&#61;node&amp;node&#61;5270145&amp;i&#61;0">[hidden email] <br><span class="">
        To unsubscribe from Quantum GIS - User, click
          here.<br></span>
        <a href="<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&%2361;instant_html%21nabble%3Aemail.naml&amp;base&%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&%2361;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" target="_blank">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&#61;instant_html%21nabble%3Aemail.naml&amp;base&#61;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&#61;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml</a>" style="font:9px serif">NAML </div>
    </blockquote><span class="">
    <br>
  



        
        
        
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270145.html" rel="nofollow" link="external" target="_blank">Re: Project relation - sci. notation</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" rel="nofollow" link="external" target="_blank">Quantum GIS - User mailing list archive</a> at Nabble.com.<br><br>_______________________________________________<br>
Qgis-user mailing list<br></span>
<a href="/user/SendEmail.jtp?type&#61;node&amp;node&#61;5270344&amp;i&#61;1">[hidden email]<span class=""><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></span></blockquote></div><br></div>
<br>_______________________________________________
<br>Qgis-user mailing list
<br><a href="/user/SendEmail.jtp?type&#61;node&amp;node&#61;5270344&amp;i&#61;2">[hidden email]
<br><span class="">List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>

        
        
        
        <br>
        <br>
        <hr noshade size="1">
        </span><div style="color:rgb(68,68,68);font:12px "tahoma","geneva","helvetica","arial",sans-serif"><span class="">
                <div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
                </span><a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270344.html" rel="nofollow" link="external" target="_blank">http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270344.html</a>
        </div>
        <div style="color:rgb(102,102,102);font:11px/1.5em "tahoma","geneva","helvetica","arial",sans-serif;margin-top:0.4em">
                To start a new topic under Quantum GIS - User, email <a href="mailto:ml-node%2Bs1560n4125267h38@n6.nabble.com" target="_blank">ml-node+s1560n4125267h38@n6.nabble.com</a> <br>
                To unsubscribe from Quantum GIS - User, <a href="<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;unsubscribe_by_code&amp;node&%2361;4125267&amp;code&%2361;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg&%2361;&%2361" target="_blank">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;unsubscribe_by_code&amp;node&#61;4125267&amp;code&#61;bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg&#61;&#61</a>;">click here.<br>
                <a href="<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&%2361;instant_html%21nabble%3Aemail.naml&amp;base&%2361;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&%2361;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" target="_blank">http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro&#61;macro_viewer&amp;id&#61;instant_html%21nabble%3Aemail.naml&amp;base&#61;nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&amp;breadcrumbs&#61;notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml</a>" style="font:9px serif">NAML
        </div></blockquote></div><div class=""><div class="h5">

        
        
        
<br><hr align="left" width="300">
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270380.html" target="_blank">Re: Project relation - sci. notation</a><br>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html" target="_blank">Quantum GIS - User mailing list archive</a> at Nabble.com.<br></div></div><br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div></div>