Hi, 
You could trouble shoot by changing the E to another letter to see if that 
changes anything... 
Nicolas 
On Jun 7, 2016 5:46 AM, "Chris Berens [via OSGeo.org]" 
<[email protected]> wrote: 

        Hi Nicolas, The fields are both TEXT. Regards, Chris Chris Berens, GISc 
www.mapland.co.za +27 (0)82 567 9322 
On 6 June 2016 at 16:17, Nicolas Cadieux < [hidden email] > wrote: 
  
    
  
  
    Hi, 
    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? 
    Nicolas 
    
https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/
 
    
    Le 2016-06-06 06:13, Chris Berens [via
      OSGeo.org] a écrit : 
    
    
      
        Hi there, 
        
        
        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. 
        
        
        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. 
        
        
        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. 
        
        
        I have an Attribute table in the a Composer
          window in the same project that references the same
          relation perfectly, ie it only returns the residents
          particular to eg 18E23.  So is the Identify Features
          tool using a different select rule set or parameters? 
        
        
        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? 
        
        
        FWIW I'm using 2.14.3-64bit on Win7, this behaviour is true
          for sqlite and shp formats. 
        
        
        Thank you for your attention, 
        Chris 
        
        Chris Berens, GISc 
        www.mapland.co.za 
        <a href="tel:%2B27%20%280%2982%20567%209322" 
value="+27825679322" target="_blank">+27 
(0)82 567 9322 
      
      _______________________________________________
      
      Qgis-user mailing list
      
      [hidden email] 
      
      List info: http://lists.osgeo.org/mailman/listinfo/qgis-user 
      Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
      
      
      
      
        If you reply to this email, your
          message will be added to the discussion below: 
        
http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096.html
 
      
      
        To start a new topic under Quantum GIS - User, email
        [hidden email]  
        To unsubscribe from Quantum GIS - User, click
          here. 
        NAML  
    
    
  



        
        
        

View this message in context: Re: Project relation - sci. notation 
Sent from the Quantum GIS - User mailing list archive  at Nabble.com. 
_______________________________________________ 
Qgis-user mailing list 
[hidden email] 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user 
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user 
_______________________________________________
Qgis-user mailing list
[hidden email] 
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: 
http://lists.osgeo.org/mailman/listinfo/qgis-user 

        
        
        
        
        
        
        
                If you reply to this email, your message will be added to the 
discussion below: 
                
http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270344.html
 
        
        
                To start a new topic under Quantum GIS - User, email 
ml-node+s1560n4125267h38@n6.nabble.com 
                To unsubscribe from Quantum GIS - User, click here . 
                NAML 
        



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Project-relation-sci-notation-tp5270096p5270380.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to