Hi folks,
I'm quite desperate, cause I do not seem to understand what I'm doing
wrong, or if it's just not possible to do.
I have a polygon layer in my spatialite database and a normal table with
bird observations. There are many observation entries for each item in
the polygons.
They share the simple field "id".
I created dozens of view, following strictly
http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/sp-view.html
(and i REALLY can't find any other tutorials).
When i query "SELECT * FROM "test17"" in Spatialite GUI, it shows all
the lines with different observation entries for each polygon id, when i
load the VIEW in QGIS, it doesn't but duplicates the first matching
observation for one polygon over and over.
The idea is to quickly identify all observations when selecting a
polygon, and then go to the attribute table to see which species are there.
Is it possible to create a one-to-many spatial VIEW with Spatialite GUI ?
if yes
Whats the trick?
if no
Is QGIS just not able to show the views table correctly?
if no
Whats the trick?
Wasted many days on that now, and time is running away.
Please, someone, heeeeelp
Bernd
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
