<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi,<div>it's not a spatialite db I want to add to my project, but a simple text table. I need to load external attributes from plain text tables and join with my vector layers. I'll not be able to perform the join until ID fields does not show up.</div><div>I think that the missing ID field should be considered a bug, because we should be able to manage external data as they are, without filters.</div><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br class="Apple-interchange-newline"><br></div><div>-----</div><div>Julian Bogdani</div><div><a href="mailto:jbogdani@gmail.com">jbogdani@gmail.com</a></div><div><a href="http://bradypus.net">http://bradypus.net</a></div></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline"></span>
</div>
<br><div><div>On 19 Aug 2012, at 9:55 , Andre Joost wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Am 18.08.2012 23:43, schrieb Julian Bogdani:<br><blockquote type="cite">In reference to a previous post and to<br></blockquote><blockquote type="cite"><a href="http://gis.stackexchange.com/questions/31732/primary-key-field-hidden-on-atributes-tables-addes-to-qgis">http://gis.stackexchange.com/questions/31732/primary-key-field-hidden-on-atributes-tables-addes-to-qgis</a><br></blockquote><blockquote type="cite">here are the files showing the problem.<br></blockquote><blockquote type="cite">I'm running QGIS 1.8 on MacOS Snow Leopard.<br></blockquote><blockquote type="cite"><br></blockquote><br>Hi,<br><br>I have tested your database and encountered the same problem.<br>I think it is because there are no geometry information in your database. So far it is only a sqlite database, not a spatialite one.<br><br>I have created a new test sqlite database with a point layer, but DB Manager would not let me copy your geometryless table to my database.<br><br>So I opened your database with qspatialite, and that plugin added tables geom_cols_ref_sys, geometry_columns and spatial_ref_sys to it. Now I could drag and drop table "test" from your database to mine using DB Manager. And adding that table to the canvas by checking geometryless tables, gives the correct table view with ID and text field.<br><br>I think the problem will not accur if you create a sqlite database within qgis, and start with a geometry layer.<br><br>HTH,<br>Andre Joost<br><br><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/qgis-user<br></div></blockquote></div><br></body></html>