<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Am 19.02.2014 20:02, schrieb Olivier
Dalang:<br>
</div>
<blockquote
cite="mid:CAExk7p1L8Sx9ABwXNrFMhbfVBLnjFfrtHynhtjVKe4NGkD9gDA@mail.gmail.com"
type="cite">
<div dir="ltr">Dear Bernd,
<div><br>
</div>
<div>I encountered some similar problems with Spatialite views,
but in the end I had it working (sometimes) both in 2.0 and in
master... I used the manual method from the spatialite
cookbook though (not the Spatialite GUI).</div>
<div><br>
</div>
<div>I have no time to test now, but from what I recall, this
does not work :</div>
<div>CREATE VIEW AS SELECT name, geometry FROM table</div>
<div>while this works :</div>
<div>CREATE VIEW AS SELECT ROWID, name, geometry FROM table</div>
<div><br>
</div>
<div>Maybe you want to give it a last try. I can testify I have
some working spatialite views here. Let us know if this works,
if not I may give it a better look when I have some time.</div>
<div><br>
</div>
<div>
Another method is running a SELECT query in the DB Manager in
QGIS, and then choosing "Add to map canvas". This is not an
actual sqlite view, but depending on what you need, it could
be enough.</div>
</div>
</blockquote>
<br>
Hi Olivier,<br>
added ROWID to the VIEW. Same result in QGIS.<br>
<br>
I also performed the select in the DB Manager as you proposed. When
executed, it perfectly show the results i would like to see in the
attribute table, but what "arrives" in the attribute table after
loading as layer is again the duplication of the the first entry for
ROWID of the polygon.<br>
<br>
So, this is my select: Anything important missing?<br>
<br>
SELECT "a"."ROWID" AS "ROWID", "a"."Geometry" AS "Geometry",<br>
"b"."zahl" AS "zahl", "b"."jahr" AS "jahr", "b"."art" AS "art",<br>
"b"."sta" AS "sta"<br>
FROM "ASK_VOEGEL" AS "a"<br>
JOIN "ask_art" AS "b" USING ("id")<br>
<br>
<br>
Thanx for your time<br>
Bernd<br>
<br>
<blockquote
cite="mid:CAExk7p1L8Sx9ABwXNrFMhbfVBLnjFfrtHynhtjVKe4NGkD9gDA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Good luck !</div>
<div><br>
</div>
<div>Olivier</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2014-02-19 19:54 GMT+01:00 Bernd
Vogelgesang <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:bernd.vogelgesang@gmx.de" target="_blank">bernd.vogelgesang@gmx.de</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Am
19.02.2014 19:14, schrieb Steve G:
<div class=""><br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
This does not directly answer your question about
spatialite views, but you<br>
might be able to use relationships directly in QGIS in
the near future (I<br>
think this is a 2.1 update). See:<br>
<br>
<a moz-do-not-send="true"
href="http://blog.vitu.ch/10112013-1201/qgis-relations"
target="_blank">http://blog.vitu.ch/10112013-1201/qgis-relations</a><br>
<br>
<br>
-Steve<br>
</blockquote>
<br>
</div>
Hi Steve,<br>
Actually I do not care by which means I reach my
destination, but I had the, maybe wrong; impression that
using a spatial database would do the trick.<br>
Anyway ...<br>
I already installed latest master cause I read about this
relation manager thing a while ago ... but I was left quite
clueless about how to use it.<br>
Searched the web for nearly an hour about any info but to no
avail, so many thanks for sharing the link!!<br>
<br>
Will have a look at it ASAP, maybe thats kind of a solution.<br>
<br>
Cheers<span class="HOEnZb"><font color="#888888"><br>
Bernd</font></span>
<div class="HOEnZb">
<div class="h5"><br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
--<br>
View this message in context: <a
moz-do-not-send="true"
href="http://osgeo-org.1560.x6.nabble.com/Spatialite-VIEW-in-QGIS-question-tp5104565p5104775.html"
target="_blank">http://osgeo-org.1560.x6.nabble.com/Spatialite-VIEW-in-QGIS-question-tp5104565p5104775.html</a><br>
Sent from the Quantum GIS - User mailing list archive
at Nabble.com.<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-user@lists.osgeo.org"
target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-user@lists.osgeo.org"
target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>