<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7" id="ecxen-NASB-29931">Hello QGIS Users,</span></font><div><div dir="ltr"><div dir="ltr"><div style="text-align: left;"><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7">Just wanted to know if anyone else has run into this... </span></font></div><div style="text-align: left;"><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7">I'm running QGIS 2.2 x64 (OSGeo4W installer) on Windows 7 SP1.</span></font></div><div style="text-align: left;"><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7"></span></font> </div><div style="text-align: left;"><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7">When trying to utilize the new Relations piece (which is a GREAT addition), I can establish relationships and have them work perfectly except when the child (or referencing layer) is in my SQL Express 2012 database. I set up a test project with identical address points and parcel layers in PostGIS, SpatiaLite and SQL. I can get any combination to work, but when the child layer is in the SQL db it will not.</span></font></div><div style="text-align: left;"><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7"></span></font> </div><div style="text-align: left;"><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7">A picture is worth a thousand words, so I took some screenshots:</span></font></div><font class="ecxApple-style-span" color="#000000" face="Courier New" size="2" style="font-size: 10pt;"><span class="ecxtext ecxTitus-3-7"><div style="text-align: left;"><div id="ecxinlineImage0" style="display: inline-block;"><span> </span><div class="ecxinlineImage" style="display: inline-block;"><img width="323" height="627" src="cid:inlineImage0"></div><span> </span></div><div id="ecxinlineImage2" style="display: inline-block;"><span> </span><div class="ecxinlineImage" style="display: inline-block;"><img width="285" height="627" src="cid:inlineImage1"></div><span> </span></div></div><div style="text-align: left;"> </div><div style="text-align: left;"> </div><div style="text-align: left;">I've double-checked the linking ID field for the parcels and it is always a 1:1 with the address point I have identified. However, just to be sure it wasn't something funky with the parcel base, I established a link between the address points and an aed (defibrillator) point layer that I had with the same result. I also tried establishing a relationship with a non-geometry table in another db in the same instance without any luck.</div><div style="text-align: left;"> </div><div style="text-align: left;"> </div><div style="text-align: left;">I'll be interested in your feedback...</div><div style="text-align: left;"> </div><div style="text-align: left;">Thanks,</div><div style="text-align: left;">James</div><div style="text-align: left;"> </div></span></font></div>
</div></div> </div></body>
</html>