<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi,<br>
<br>
simplest way is to reindex, if that does not work delete existing
and create a new.<br>
See in spatialite deocumentation
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<a
href="http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t8">http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t8</a>
and here
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<a
href="http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/rtree.html">http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/rtree.html</a><br>
<br>
And check if the data at all are stored in database.<br>
<br>
Regards,<br>
<br>
On 2012.12.06. 15:12, Justin Hubbard wrote:<br>
</div>
<blockquote
cite="mid:CAMFSZzrNKRgRDOkr6po97jx5GVkoyYdGXXvN6CXYBUZzhurnjQ@mail.gmail.com"
type="cite">
<div>Hi.</div>
<div><br>
</div>
When I load the layer outside of the plugin I get the same
problem.
<div>If there is a problem with the database indexes, how would I
rectify this?</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">
On Thu, Dec 6, 2012 at 10:36 AM, Pēteris Brūns <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:pb@sungis.lv" target="_blank">pb@sungis.lv</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hi,<br>
<br>
try to open your Spatialite db and add layer without
plugin. If then also are missing some geometries can be
problems with your Spatialite database indexes.<br>
<br>
Regards, <br>
<div>
<div class="h5"> <br>
On <a moz-do-not-send="true"
href="tel:2012.12.06.%2010" value="+12012120610"
target="_blank">2012.12.06. 10</a>:22, Tim Sutton
wrote:<br>
</div>
</div>
</div>
<div>
<div class="h5">
<blockquote type="cite">Hi
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Thu, Dec 6, 2012 at
8:47 AM, Justin Hubbard <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:justin@pyrotechsoftware.com"
target="_blank">justin@pyrotechsoftware.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">Hi
<div><br>
</div>
<div>I am using QGis 1.8. <br>
</div>
<div>The code I am using is identical to the
code in the cookbook. I have also tried
doing this in the console. Same result.</div>
<div>When I create a new shapefile layer and
add the points as described in the code,
they appear correctly. </div>
<div>However with this layer - Which is a
Spatialite Layer I cannot see the points at
all.</div>
<div><br>
</div>
<div>With regards to the symbology, I have
tried new and old symbology, and even
loading the layer in a blank project with no
custom symbology at all. Same result.</div>
<div>If I use the map tool to create a point
with the mouse the point appears, and works
correctly. This is causing me to think that
the error is in the code. (Perhaps
Spatialite requires something extra?)</div>
<div class="gmail_extra">
<div>
<div> <br>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Justin it is always better to provide code
samples (as plain text) - it makes it much
easier to help you as we can see exactly what
you are doing....</div>
<div><br>
</div>
<div><br>
</div>
<div>Did you commit your changes to the dataset?</div>
<div><br>
</div>
<div>Regards</div>
<div><br>
</div>
<div>Tim</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0
0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">
<div class="gmail_extra">
<div>
<div><br>
<div class="gmail_quote">On Wed, Dec 5,
2012 at 8:35 PM, Ian Packham <span
dir="ltr"><<a
moz-do-not-send="true"
href="mailto:i.packham@ucd.ie"
target="_blank">i.packham@ucd.ie</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0
.8ex;border-left:1px #ccc
solid;padding-left:1ex"> Justin<br>
<br>
Which version of QGIS are you using?
Are you using code exactly as in the
cookbook (Using Vector Layers
chapter?)?. If not, can you provide
the code? Also how did you create
the symbology?<span><font
color="#888888"><br>
<br>
Ian</font></span>
<div>
<div><br>
<br>
----- Original Message -----<br>
From: Justin Hubbard <<a
moz-do-not-send="true"
href="mailto:justin@pyrotechsoftware.com"
target="_blank">justin@pyrotechsoftware.com</a>><br>
Date: Wednesday, December 5,
2012 1:51 pm<br>
Subject: [Qgis-developer] Where
are the points?<br>
To: qgis-developer <<a
moz-do-not-send="true"
href="mailto:qgis-developer@lists.osgeo.org"
target="_blank">qgis-developer@lists.osgeo.org</a>><br>
<br>
<font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font>In my plugin, I am able
to create features as per the
cookbook. And when I zoom to the
layer extent I can see the
points are there and they are
rendered as per my symbology.
<div> <br>
</div>
<div><font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font>However when I try to
zoom / Pan to them,
they disappear.</div>
<div><font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font>If I run
QgsFeature.isValid() they all
return true. I just cannot
understand it.<br>
<div>
<div><font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font><br>
</div>
<font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font>-- <br>
<p><span
style="font-family:verdana,geneva;font-size:x-small"><font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font>Warm regards</span><br>
<strong><span
style="font-family:verdana,geneva;font-size:x-small"><font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font>Justin Hubbard</span></strong><br>
<font
style="font-style:normal;font-weight:normal;background-color:rgb(245,248,240);font-size:14px">>
</font><br>
<strong><span
style="font-family:verdana,geneva;font-size:x-small"></span></strong></p>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
</div>
</div>
<p><span
style="font-family:verdana,geneva;font-size:x-small">Warm
regards</span><span><font
color="#888888"><br>
<strong><span
style="font-family:verdana,geneva;font-size:x-small">Justin
Hubbard</span></strong><br>
<br>
<strong><span
style="font-family:verdana,geneva;font-size:x-small">--</span></strong><br>
</font></span></p>
<div>
<table
style="background-color:rgb(0,51,102);width:250px;min-height:217px"
border="0" cellpadding="0"
cellspacing="1">
<tbody>
<tr>
<td
style="margin:0px;padding:1.5pt;font-family:arial,sans-serif;background-color:white">
<table
style="background-color:white;width:241px;min-height:207px"
border="0" cellpadding="0">
<tbody>
<tr>
<td colspan="2"
style="margin:0px;padding:0.75pt">
<table
style="width:347px;min-height:212px"
border="0"
cellpadding="0"
cellspacing="0">
<tbody>
<tr
style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top"
width="14"> </td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p dir="ltr"
style="margin:0px;text-align:justify"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p dir="ltr"
style="margin:0px;text-align:justify"><span
style="font-family:verdana,geneva"><strong><span
style="font-size:10pt;color:red">Justin
Hubbard</span></strong></span></p>
<p dir="ltr"
style="margin:0px;text-align:justify"><span
style="font-size:7.5pt;color:rgb(0,51,102)">Software Engineer and
Support<br>
<br>
</span></p>
</td>
</tr>
<tr
style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top"
width="14">
<p
style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> Mobile:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> <a moz-do-not-send="true"
href="tel:%2B27%20%280%2979%20827%201657" value="+27798271657"
target="_blank">+27
(0)79 827 1657</a></span></p>
</td>
</tr>
<tr
style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top"
width="14">
<p
style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> Fax:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> <a moz-do-not-send="true"
href="tel:%2B27%20%280%2986%20540%206016" value="+27865406016"
target="_blank">+27
(0)86 540 6016</a></span></p>
</td>
</tr>
<tr
style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top"
width="14">
<p
style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> Email:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:navy"> <span style="color:blue"><span
style="color:rgb(0,0,204)"><a
moz-do-not-send="true" title="Email Me"
href="mailto:robert@plannermunicipalsoftware.co.za"
target="_blank">justin@pyrotechsoftware.com</a></span></span></span></p>
</td>
</tr>
<tr
style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top"
width="14">
<p
style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt">
<span
style="font-size:7.5pt;color:rgb(0,51,102)">
Web Site:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p
style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:navy"> <span style="color:blue"><span
style="color:rgb(0,0,204)"><a
moz-do-not-send="true" title="About Me"
href="http://www.plannermunicipalsoftware.co.za/"
target="_blank">www.pyrotechsoftware.co</a>m</span></span></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<br>
</div>
</div>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-developer@lists.osgeo.org"
target="_blank">Qgis-developer@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-developer"
target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Tim Sutton - QGIS Project Steering Committee
Member (Release Manager)<br>
==============================================<br>
Please do not email me off-list with technical<br>
support questions. Using the lists will gain<br>
more exposure for your issues and the knowledge<br>
surrounding your issue will be shared with all.<br>
<br>
Visit <a moz-do-not-send="true"
href="http://linfiniti.com" target="_blank">http://linfiniti.com</a>
to find out about:<br>
* QGIS programming and support services<br>
* Mapserver and PostGIS based hosting plans<br>
* FOSS Consulting Services<br>
Skype: timlinux<br>
Irc: timlinux on #qgis at <a
moz-do-not-send="true"
href="http://freenode.net" target="_blank">freenode.net</a><br>
==============================================<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Qgis-developer mailing list
<a moz-do-not-send="true" href="mailto:Qgis-developer@lists.osgeo.org" target="_blank">Qgis-developer@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a>
</pre>
</blockquote>
<br>
<br>
</div>
</div>
<span class="HOEnZb"><font color="#888888">
<pre cols="72">--
Pēteris</pre>
</font></span></div>
<br>
_______________________________________________<br>
Qgis-developer mailing list<br>
<a moz-do-not-send="true"
href="mailto:Qgis-developer@lists.osgeo.org">Qgis-developer@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/qgis-developer"
target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br>
<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<p><span style="font-family:verdana,geneva;font-size:x-small">Warm
regards</span><br>
<strong><span
style="font-family:verdana,geneva;font-size:x-small">Justin
Hubbard</span></strong><br>
<br>
<strong><span
style="font-family:verdana,geneva;font-size:x-small">--</span></strong><br>
</p>
<table
style="background-color:rgb(0,51,102);width:250px;height:217px"
border="0" cellpadding="0" cellspacing="1">
<tbody>
<tr>
<td
style="margin:0px;padding:1.5pt;font-family:arial,sans-serif;background-color:white">
<table
style="background-color:white;width:241px;height:207px"
border="0" cellpadding="0">
<tbody>
<tr>
<td colspan="2" style="margin:0px;padding:0.75pt">
<table style="width:347px;height:212px"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top" width="14"> </td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p dir="ltr"
style="margin:0px;text-align:justify"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p dir="ltr"
style="margin:0px;text-align:justify"><span
style="font-family:verdana,geneva"><strong><span
style="font-size:10pt;color:red">Justin
Hubbard</span></strong></span></p>
<p dir="ltr"
style="margin:0px;text-align:justify"><span
style="font-size:7.5pt;color:rgb(0,51,102)">Software Engineer and
Support<br>
<br>
</span></p>
</td>
</tr>
<tr style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top" width="14">
<p style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> Mobile:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> +27 (0)79 827 1657</span></p>
</td>
</tr>
<tr style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top" width="14">
<p style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> Fax:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> +27 (0)86 540 6016</span></p>
</td>
</tr>
<tr style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top" width="14">
<p style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:rgb(0,51,102)"> Email:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:navy"> <span
style="color:blue"><span
style="color:rgb(0,0,204)"><a
moz-do-not-send="true"
title="Email Me"
href="mailto:robert@plannermunicipalsoftware.co.za"
target="_blank">justin@pyrotechsoftware.com</a></span></span></span></p>
</td>
</tr>
<tr style="min-height:10.5pt">
<td
style="margin:0px;padding:0in;min-height:10.5pt;width:10.5pt"
valign="top" width="14">
<p style="margin:0px"> </p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt">
<span
style="font-size:7.5pt;color:rgb(0,51,102)">
Web Site:</span></p>
</td>
<td
style="margin:0px;padding:0in;min-height:10.5pt">
<p style="margin:0px;line-height:10.5pt"><span
style="font-size:7.5pt;color:navy"> <span
style="color:blue"><span
style="color:rgb(0,0,204)"><a
moz-do-not-send="true"
title="About Me"
href="http://www.plannermunicipalsoftware.co.za/"
target="_blank">www.pyrotechsoftware.co</a>m</span></span></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<br>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Pēteris Brūns
SunGIS
+371 26336691
<a class="moz-txt-link-abbreviated" href="mailto:pb@sungis.lv">pb@sungis.lv</a></pre>
</body>
</html>