----- Original Message -----
From: "Frank Millman" <fr...@chagford.com>
To: <sqlite-users@sqlite.org>
Sent: Monday, August 25, 2014 2:32 PM
Subject: Re: [sqlite] Problem with recursive CTE
Could it be a version problem? I am using the version bundled with
Python3.4.1 for Windows.
sqlite3.sqlite_version shows '3.8.3.1'
I have just tried it on a Fedora 18 machine, which has version 3.7.13.
There it gives 'near "WITH": syntax error'
It seems that the WITH statement is a fairly recent addition. I will
upgrade and try again.
I have upgraded to version 3.8.6, and I can confirm that it now works.
Thanks very much, Richard and Keith
Now I have to figure out how to get Python to use the upgraded version, but
that is one for the python mailing list.
Frank
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users