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

[Jonathan Moules]

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.granjon at 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.granjon at wanadoo.fr>
> A : Qgis-user at 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 at 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 at lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160816/ae91c450/attachment.html>