Re: [Qgis-user] Common Table Expression on windows with spatialite

2016-08-16 Thread Jürgen E . Fischer
Hi Jonathan, On Tue, 16. Aug 2016 at 16:29:09 +0100, Jonathan Moules wrote: > I've just tested QGIS 2.12.3 on Windows - it's still using SQLite 3.7.17. 2.12? OSGeo4W has 2.16.1 and 2.14.5. And SQLite 3.14.1. ;) > Does anyone know if there is a reason the version of SQLite doesn't get >

Re: [Qgis-user] Common Table Expression on windows with spatialite

2016-08-16 Thread Jonathan Moules
: "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 "

Re: [Qgis-user] Common Table Expression on windows with spatialite

2016-08-16 Thread ludo
o" > 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

[Qgis-user] Common Table Expression on windows with spatialite

2016-08-16 Thread ludo
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 ___