Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the wording on the description of the WHEN clause on triggers. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
09d3dc5c517e7480ca45a54b74b2e348 |
| User & Date: | drh 2017-02-02 14:48:34 |
Context
|
2017-02-02
| ||
| 23:55 | Clarify the behavior of AUTOINCREMENT after an UPDATE. check-in: f6e2eab4e7 user: drh tags: trunk | |
| 14:48 | Update the wording on the description of the WHEN clause on triggers. check-in: 09d3dc5c51 user: drh tags: trunk | |
|
2017-01-29
| ||
| 11:39 | Fix an obsolete example in the FTS3 documentation. check-in: c90c7a1015 user: drh tags: trunk | |
Changes
Changes to pages/lang.in.
1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 |
<td valign="top" align="right" width=120><i>DELETE</i></td> <td valign="top">OLD references are valid</td> </tr> </table> </p>)^ <p>^If a WHEN clause is supplied, the SQL statements specified are only executed for rows for which the WHEN clause is true. ^If no WHEN clause is supplied, the SQL statements are executed for all rows.</p> <p>^The BEFORE or AFTER keyword determines when the trigger actions will be executed relative to the insertion, modification or removal of the associated row.</p> <p>^An [ON CONFLICT] clause may be specified as part of an [UPDATE] or [INSERT] action within the body of the trigger. |
| | | |
1178 1179 1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 |
<td valign="top" align="right" width=120><i>DELETE</i></td> <td valign="top">OLD references are valid</td> </tr> </table> </p>)^ <p>^If a WHEN clause is supplied, the SQL statements specified are only executed if the WHEN clause is true. ^If no WHEN clause is supplied, the SQL statements are executed every time the trigger fires.</p> <p>^The BEFORE or AFTER keyword determines when the trigger actions will be executed relative to the insertion, modification or removal of the associated row.</p> <p>^An [ON CONFLICT] clause may be specified as part of an [UPDATE] or [INSERT] action within the body of the trigger. |