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@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

Reply via email to