My apology, I can not read. http://sqlite.org/lang_createtrigger.html clearly states that CTE is not supported in triggers.
Roman ________________________________________ From: sqlite-users [[email protected]] on behalf of Roman Fleysher [[email protected]] Sent: Tuesday, May 09, 2017 4:59 PM To: General Discussion of SQLite Database Subject: [sqlite] WITH inside trigger in 3.16.2 [This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing at http://aka.ms/LearnAboutSpoofing] Dear SQLiters, I am trying to create a trigger with body: WITH ... DELETE FROM ... and it does not seem to work (Error: near "DELETE": syntax error). But I can execute the body itself without errors. Does it mean that WITH clause is not supported within trigger? I use SQLite version 3.16.22. Thank you, Roman _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
