Hey,<br><br><div>Do you have a primary key (int based) on those tables?</div><div><br></div><div>- Nathan</div><br><div class="gmail_quote">On Sun Dec 28 2014 at 9:44:23 PM Bernard BISconsult <<a href="mailto:emile.bernard@bisconsult.ch">emile.bernard@bisconsult.ch</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="DE-CH" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-US">Hello friends<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">I'm using QGIS 2.2 Valmiera on a Windows 7 environment with SQL Server 2012 holding the data and I'm quite happy about how QGIS displays the data. The connection to SQL Servre goes via ODBC. As in my project QGIS is used to present data than to create or modify them, I use SQL-Server views as the underlying data reference which works fine and fast. However I've got one serious problem that is when I use the "Open Attribute Table" on a layer it will show the exact number of records, but the record content is always the same, probably repeating the content of the first record found instead of showing the individual contents (see ccreenshot attached).<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">I thought this might be a 2.2 problem meanwhile fixed and installed QGIS 2.6 by using the existing .qgs file from 2.2. But after that many layers (not all) lost there connection to the SQL Server database and I'm unable to connect them. Furthermore using "Open Attribute Table" crashes on layers from SQL Server.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">By this mail I hope to get answers on:<u></u><u></u></span></p><p><u></u><span lang="EN-US"><span>1.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span lang="EN-US">How can I fix the 2.2 problem which displays repeatedly the same record when using Open Attribute Table on a layer from SQL Server<u></u><u></u></span></p><p><u></u><span lang="EN-US"><span>2.<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span lang="EN-US">How can I migrate a .qgs mapping from 2.2 to 2.6 which is mainly filled with layers on SQL Server data.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Regards Emile<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p></div>
<br><br>
<hr style="border:none;color:#909090;background-color:#b0b0b0;min-height:1px;width:99%">
<table style="border-collapse:collapse;border:none">
<tr>
<td style="border:none;padding:0px 15px 0px 8px">
<a href="http://www.avast.com/" target="_blank">
<img border="0" src="http://static.avast.com/emails/avast-mail-stamp.png">
</a>
</td>
<td>
<p style="color:#3d4d5a;font-family:"Calibri","Verdana","Arial","Helvetica";font-size:12pt">
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
<br><a href="http://www.avast.com/" target="_blank">www.avast.com</a>
</p>
</td>
</tr>
</table>
<br>
</div>______________________________<u></u>_________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/qgis-user</a></blockquote></div>