Hi, 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. 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.
----- Julian Bogdani [email protected] http://bradypus.net On 19 Aug 2012, at 9:55 , Andre Joost wrote: > Am 18.08.2012 23:43, schrieb Julian Bogdani: >> In reference to a previous post and to >> http://gis.stackexchange.com/questions/31732/primary-key-field-hidden-on-atributes-tables-addes-to-qgis >> here are the files showing the problem. >> I'm running QGIS 1.8 on MacOS Snow Leopard. >> > > Hi, > > I have tested your database and encountered the same problem. > 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. > > 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. > > 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. > > I think the problem will not accur if you create a sqlite database within > qgis, and start with a geometry layer. > > HTH, > Andre Joost > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
