I've just tested QGIS 2.12.3 on Windows - it's still using SQLite 3.7.17. 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)
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). ---- On Tue, 16 Aug 2016 15:28:21 +0100 ludo<ludovic.gran...@wanadoo.fr> wrote ---- OK I see here http://gis.stackexchange.com/questions/116969/spatialite-with-clause-issue 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 ... Thanks Ludovic > Message du 16/08/16 16:09 > De : "ludo" <ludovic.gran...@wanadoo.fr> > A : Qgis-user@lists.osgeo.org > Copie à : > Objet : [Qgis-user] Common Table Expression on windows with spatialite > > > Hi all > I try to use recursive CTE on qgis with spatialite database. > All it's ok on linux, but when I try on windows I have "une erreur est survenue: near "WITH: syntax error"" > Is it possible to use CTE on windows ? > Thanks a lot > Regards > Ludovic _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user