<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi Paolo:<BR>
<BR>
The ogr driver for sqlite is outdated and does not work with Spatialite. <BR>
It uses diferent table structure that spatialite (for example in sqlite driver<BR>
the table spatial_ref_sys uses a column named SRTEXT while spatialite has<BR>
a column named proj4text). I have been working in an ogr driver for spatialite<BR>
based in sqlite driver, solving the problems with tables structures and solving<BR>
the problems with constrains but it needs more work and more testing.<BR>
<BR>
Regards<BR>
<BR>
Godofredo Contreras <BR> <BR>> Date: Mon, 23 Mar 2009 08:18:09 +0100<BR>> From: cavallini@faunalia.it<BR>> To: frdcn@hotmail.com<BR>> CC: qgis-developer@lists.osgeo.org<BR>> Subject: Re: [Qgis-developer] Improvements to open vector dialog<BR>> <BR>> godofredo contreras ha scritto:<BR>> > Thank you for the feedback, I will test it and try to fix the problem if it<BR>> > is ogr provider specific or post a bug in gdal/ogr trac.<BR>> <BR>> Hi Godofredo.<BR>> I tried pushing the provider a bit further, asking it to open a<BR>> SpatiaLite file, but it fails to recognize spatial data (including<BR>> projections, and crashes when trying to open the attached table.<BR>> Nothing serious I guess, I know SpatiaLite support is still<BR>> experimental, but it might be interesting to know.<BR>> All the best.<BR>> -- <BR>> Paolo Cavallini: http://www.faunalia.it/pc<BR><br /><hr />Get quick access to your favorite MSN content with Internet Explorer 8. <a href='http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN55C0701A' target='_new'>Download FREE now!</a></body>
</html>