Re: [sqlite] Documentation clarification request... (re: Triggers)

2017-02-02 Thread Simon Slavin
On 2 Feb 2017, at 2:38pm, Michael Tiernan wrote: > So that makes sense (I think) and isn't causing a problem for me but then, a > little further on it says: > > If a WHEN clause is supplied, the SQL statements specified are only > executed for rows for which the WHEN clause is true. If no

[sqlite] Documentation clarification request... (re: Triggers)

2017-02-02 Thread Michael Tiernan
In the online documentation: https://sqlite.org/lang_createtrigger.html It says: At this time SQLite supports only FOR EACH ROW triggers, not FOR EACH STATEMENT triggers. Hence explicitly specifying FOR EACH ROW is optional. FOR EACH ROW implies that the SQL statements specified in t