<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style='font-size:10pt;font-family:Verdana,Arial,Helvetica,sans-serif;'>I've just tested QGIS 2.12.3 on Windows - it's still using SQLite 3.7.17.<br><br>Does anyone know if there is a reason the version of SQLite doesn't get updated often, at least not on Windows? That version of SQLite is well over 3 years old (https://www.sqlite.org/releaselog/3_7_17.html)<br><br>The current version is of SQLite is 3.14.1. A number of users appear to want to use features in more recent versions of SQLite, so it may be worth updating to a newer version (there are also a considerable number of optimisations and fixes).<br><br><div class="zmail_extra"><div id="1"><br>---- On Tue, 16 Aug 2016 15:28:21 +0100 <b>ludo<ludovic.granjon@wanadoo.fr></b> wrote ---- <br></div><blockquote style="border-left: 1px solid #0000FF; padding-left: 6px; margin:0 0 0 5px"><div><p>OK<br><br>I see here <a rel="noreferrer" href="http://gis.stackexchange.com/questions/116969/spatialite-with-clause-issue" target="_blank">http://gis.stackexchange.com/questions/116969/spatialite-with-clause-issue</a><br><br>That CTE works with sqlite > 3.8.3 and then sqlite's version in qgis on windows seems to be 3.7.17 so it doesn't work ...<br><br>Thanks<br><br>Ludovic</p> <p> </p> <p> </p> <p> </p> <p> </p> <blockquote style="padding-left: 5.0px;margin-left: 5.0px;border-left: rgb(255,0,0) 2.0px solid;">> Message du 16/08/16 16:09<br>> De : "ludo" <<a subj="" mailid="ludovic.granjon%40wanadoo.fr" rel="noreferrer" href="mailto:ludovic.granjon@wanadoo.fr" target="_blank">ludovic.granjon@wanadoo.fr</a>><br>> A : <a subj="" mailid="Qgis-user%40lists.osgeo.org" rel="noreferrer" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>> Copie à : <br>> Objet : [Qgis-user] Common Table Expression on windows with spatialite<br>> <br>> <p>> Hi all</p> <p>> I try to use recursive CTE on qgis with spatialite database.</p> <p>> All it's ok on linux, but when I try on windows I have "une erreur est survenue: near "WITH: syntax error""</p> <p>> Is it possible to use CTE on windows ?</p> <p>> Thanks a lot</p> <p>> Regards</p> <p>> Ludovic</p> <br><br><br>_______________________________________________<br>Qgis-user mailing list<br><a subj="" mailid="Qgis-user%40lists.osgeo.org" rel="noreferrer" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>List info: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></blockquote>_______________________________________________<br>Qgis-user mailing list<br><a subj="" mailid="Qgis-user%40lists.osgeo.org" rel="noreferrer" href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>List info: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a rel="noreferrer" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div></blockquote><br></div><br></div></body></html>