<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Notice that you have duplicate ROWID
values in your view results. Spatialite (and DB manager) don't
care about this since the ROWID is more a convenience. But for
QGIS it's critical that this column be like a unique primary key.<br>
<br>
This is happening because you have GROUP BY with two columns in
your query. I think that what will resolve this is creating a new
integer column with unique values for each Fortas-rusis pair. <br>
<br>
If you could try this: add to both the siksnosparniai_rusis table
and the siksnosparniai_patalpa tables additional integer columns
with unique values for each Fortas and unique values for each
rusis. Then in your view, combine these two integers in some way
to get a new *unique* value to be used as the ROWID. That should
work out the duplicate error values in QGIS.<br>
<br>
Good luck,<br>
Micha<br>
<br>
<br>
<br>
<br>
On 05/02/2014 09:25, giedrius wrote:<br>
</div>
<blockquote cite="mid:1391585150013-5101983.post@n6.nabble.com"
type="cite">
<pre wrap="">Hello,
I have a problem with the display of tables add to QGIS from spatialite.
DB Manager displays the correct data, but uploading to QGIS table entries
changed to false:
<a class="moz-txt-link-freetext" href="http://i.imgur.com/Pahw13c.png">http://i.imgur.com/Pahw13c.png</a>
<a class="moz-txt-link-freetext" href="http://i.imgur.com/9Y1zaq4.png">http://i.imgur.com/9Y1zaq4.png</a>
When loaded data export to shapfile then show the correct data:
<a class="moz-txt-link-freetext" href="http://i.imgur.com/ZeXk6Xz.png">http://i.imgur.com/ZeXk6Xz.png</a>
Is this a bug? Is it my fault as a user?
I work with Debian
VAM_test_s.sqlite
<a class="moz-txt-link-rfc2396E" href="http://osgeo-org.1560.x6.nabble.com/file/n5101983/VAM_test_s.sqlite"><http://osgeo-org.1560.x6.nabble.com/file/n5101983/VAM_test_s.sqlite></a>
--
View this message in context: <a class="moz-txt-link-freetext" href="http://osgeo-org.1560.x6.nabble.com/Spatialite-problems-with-spatial-views-tp5036088p5101983.html">http://osgeo-org.1560.x6.nabble.com/Spatialite-problems-with-spatial-views-tp5036088p5101983.html</a>
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consulting
052-3665918
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a>
</pre>
</body>
</html>