<div>Hi Noli, <br></div><div><br></div><div>sure! Here it is: </div><div><br></div><div><a href="http://downloads.tuxfamily.org/tuxgis/geoblogs/visor_qgis_capas_spatialite/visor_pyqgis.tar.bz2">http://downloads.tuxfamily.org/tuxgis/geoblogs/visor_qgis_capas_spatialite/visor_pyqgis.tar.bz2</a></div>

<div><br></div><div>Regards, </div><div><br></div><div>Germán</div><div><br></div><div class="gmail_quote">2010/9/10 Noli Sicad <span dir="ltr">&lt;<a href="mailto:nsicad@gmail.com">nsicad@gmail.com</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

Hi Germán,<br>
<br>
Thank you.<br>
<br>
Now it is English :-). Using Google Translate.<br>
<br>
<a href="http://translate.google.com/translate?js=n&amp;prev=_t&amp;hl=en&amp;ie=UTF-8&amp;layout=2&amp;eotf=1&amp;sl=auto&amp;tl=en&amp;u=http%3A%2F%2Fgeotux.tuxfamily.org%2Findex.php%3Foption%3Dcom_myblog%26task%3Dview%26id%3D251%26Itemid%3D59" target="_blank">http://translate.google.com/translate?js=n&amp;prev=_t&amp;hl=en&amp;ie=UTF-8&amp;layout=2&amp;eotf=1&amp;sl=auto&amp;tl=en&amp;u=http%3A%2F%2Fgeotux.tuxfamily.org%2Findex.php%3Foption%3Dcom_myblog%26task%3Dview%26id%3D251%26Itemid%3D59</a><br>


<br>
German, would be able to share the whole source code of the project?<br>
<br>
Thanks again.<br>
<br>
Regards, Noli<br>
<div><div class="h5"><br>
<br>
<br>
On 9/11/10, Germán Carrillo &lt;<a href="mailto:carrillo.german@gmail.com">carrillo.german@gmail.com</a>&gt; wrote:<br>
&gt; Hi Noli,<br>
&gt;<br>
&gt; you could use this [1] (sorry, it&#39;s in Spanish). It uses the Sqlite3 Python<br>
&gt; module [2].<br>
&gt;<br>
&gt; Regards,<br>
&gt;<br>
&gt; Germán<br>
&gt;<br>
&gt; ----------------------------<br>
&gt; [1]<br>
&gt; <a href="http://geotux.tuxfamily.org/index.php?option=com_myblog&amp;task=view&amp;id=251&amp;Itemid=59" target="_blank">http://geotux.tuxfamily.org/index.php?option=com_myblog&amp;task=view&amp;id=251&amp;Itemid=59</a><br>


&gt; [2] <a href="http://docs.python.org/library/sqlite3.html" target="_blank">http://docs.python.org/library/sqlite3.html</a><br>
&gt;<br>
&gt; On Fri, Sep 10, 2010 at 9:49 AM, Noli Sicad &lt;<a href="mailto:nsicad@gmail.com">nsicad@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt;&gt; Hi,<br>
&gt;&gt;<br>
&gt;&gt; Given, this example from PyQGIS documentation.<br>
&gt;&gt;<br>
&gt;&gt; ~~~~~~~~<br>
&gt;&gt; uri = QgsDataSourceURI()<br>
&gt;&gt; uri.setDatabase(&#39;/home/martin/test-2.3.sqlite&#39;)<br>
&gt;&gt; uri.setDataSource(&#39;&#39;,&#39;Towns&#39;, &#39;Geometry&#39;)<br>
&gt;&gt;<br>
&gt;&gt; layer = QgsVectorLayer(uri.uri(), &#39;Towns&#39;, &#39;spatialite&#39;)<br>
&gt;&gt; ~~~~~~~~~<br>
&gt;&gt;<br>
&gt;&gt; How do you do a runtime for the above. I want to select the table /<br>
&gt;&gt; layer to load. How you figure out the  uri.setDataSource(&#39;&#39;,&#39; &#39;,<br>
&gt;&gt; &#39;Geometry&#39;) and  QgsVectorLayer(uri.uri(), &#39; &#39;, &#39;Spatialite&#39;)?<br>
&gt;&gt;<br>
&gt;&gt; ~~~~~~~~<br>
&gt;&gt;    file = QFileDialog.getOpenFileName(self,&quot;Open Spatialite&quot;, &quot;.&quot;,<br>
&gt;&gt; &quot;Spatialite (*.sqlite)&quot;)<br>
&gt;&gt;    fileInfo = QFileInfo(file)<br>
&gt;&gt;<br>
&gt;&gt;    uri = QgsDataSourceURI()<br>
&gt;&gt;    uri.setDatabase(file)<br>
&gt;&gt;    uri.setDataSource(&#39;&#39;,&#39; &#39;, &#39;Geometry&#39;)<br>
&gt;&gt;<br>
&gt;&gt;    # Add the layer<br>
&gt;&gt;    layer = QgsVectorLayer(uri.uri(), &#39; &#39;, &#39;Spatialite&#39;)<br>
&gt;&gt;<br>
&gt;&gt; ~~~~~~~~~<br>
&gt;&gt;<br>
&gt;&gt; Noli<br>
&gt;&gt; _______________________________________________<br>
&gt;&gt; Qgis-developer mailing list<br>
&gt;&gt; <a href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
&gt;&gt; <a href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
&gt;&gt;<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; --<br>
&gt; -----------<br>
&gt;   |\__<br>
&gt; (:&gt;__)(<br>
&gt;   |/<br>
&gt;<br>
&gt; Soluciones Geoinformáticas Libres<br>
&gt; <a href="http://geotux.tuxfamily.org/" target="_blank">http://geotux.tuxfamily.org/</a><br>
&gt;<br>
</div></div></blockquote></div><br>-- <br>-----------<br>  |\__  <br>(:&gt;__)(<br>  |/    <br><br>Soluciones Geoinformáticas Libres                            <br><a href="http://geotux.tuxfamily.org/">http://geotux.tuxfamily.org/</a><br>