Hi, File created using CLI (command line interface) in Spatialite could not be opened in QGIS 1.5 and (QGIS 1.4) in Windows 7 and XP. And vice versa i.e. spatialite created in QGIS 1.5 could not be opened as well in Spatialite-GIS.
Please note that Spatialite test database could not open property in QGIS 1.4 and QGIS 1.5. You can open the file but it will not render the geometry polygon. I am trying to create a Spatialite file from a Shapefile. Steps In QGIS 1.5 1. Load Shapefile 2. Save Shapefile to Spatialite - Spatialite file successful created. 3. Remove Shapefile from Qgis. 4. Open Spatialte file that was created in QGIS - It is rendered 5. OK, no problem Steps in Spatialite CLI using Spatialite 2.4 1. Create a Spatialite database 3. Initalise the database (.read init_spatialite-2.4.sql ASCII) 2. Load Shapeflle (.loadshp) 3. Inspect tables (.tables) 4. Close command line Now, the problems. In QGIS - Problem in opening Spatialite file created by Spatialite CLI in QGIS. It ask you for layers to open. You can select any tables, yet it will not render the polygons. You can see the attributes though. In Spatialite-GIS - Problem in opening QGIS created spatialite file. Error Screen "Missing or invalid Spatial Metadata tables - spatial_ref_sys - geometry_columns" I examined theSpatialite file created in QGIS 1.5 using Spatialite CLI, the 2 metadata tables are present. What causes these incompatibilities and any solution to the problem? Problem in Geoserver with Spatialite. http://groups.google.com/group/spatialite-users/browse_thread/thread/4099a32ef20e6a19 Thanks. Noli _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer