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

[ludo]

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" 
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160816/6e4520f9/attachment.html>