WITH inside trigger in 3.16.2

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

WITH inside trigger in 3.16.2

Roman Fleysher
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: WITH inside trigger in 3.16.2

Roman Fleysher
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 [[hidden email]] on behalf of Roman Fleysher [[hidden email]]
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users