I find that a UPDATE statement with WITH CLAUSE always fails, although I use the syntax as SQLite syntax suggested. Also, the `lang_with.html` do no show a UPDATE statement with WITH CLAUSE. They all run in a SELECT statement.
Here is the sample SQL I tried: ``` CREATE TABLE t(i INTEGER); INSERT INTO t VALUES(1); WITH cte AS(SELECT i FROM t) UPDATE cte SET i = 0; // Failed with "Error: no such table: cte" ``` Note that the sample WITH CLAUSE make no sense. It's just for testing. But still failed. Did I use it in a wrong way? What's the suggesting rule? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
