Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix more typos in the foreignkey.html document. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
2de942054f0fb41c9ff97918d055ca5e |
User & Date: | drh 2014-04-25 20:46:04.340 |
Context
2014-04-29
| ||
15:08 | Added documentation for the sqlite3_rtree_query_callback() enhancement. (check-in: 89557fb903 user: drh tags: trunk) | |
2014-04-25
| ||
20:47 | Fix more typos in the foreignkey.html document. (check-in: 25bc66990e user: drh tags: version-3.8.4.3) | |
20:46 | Fix more typos in the foreignkey.html document. (check-in: 2de942054f user: drh tags: trunk) | |
20:23 | Fix a typo in the foreign key documentation. (check-in: 821750714a user: drh tags: trunk) | |
Changes
Changes to pages/foreignkeys.in.
︙ | ︙ | |||
241 242 243 244 245 246 247 | (for backwards compatibility), so must be enabled separately for each [database connection]. (Note, however, that future releases of SQLite might change so that foreign key constraints enabled by default. Careful developers will not make any assumptions about whether or not foreign keys are enabled by default but will instead enable or disable them as necessary.) | | | 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 | (for backwards compatibility), so must be enabled separately for each [database connection]. (Note, however, that future releases of SQLite might change so that foreign key constraints enabled by default. Careful developers will not make any assumptions about whether or not foreign keys are enabled by default but will instead enable or disable them as necessary.) ^The application can also use a [PRAGMA foreign_keys] statement to determine if foreign keys are currently enabled. ^(The following command-line session demonstrates this: <codeblock> sqlite> PRAGMA foreign_keys; 0 sqlite> PRAGMA foreign_keys = ON; sqlite> PRAGMA foreign_keys; |
︙ | ︙ | |||
895 896 897 898 899 900 901 | <li><p> <b>Recursion limit on foreign key actions.</b> ^(The [SQLITE_MAX_TRIGGER_DEPTH] and [SQLITE_LIMIT_TRIGGER_DEPTH] settings determine the maximum allowable depth of trigger program recursion. For the purposes of these limits, [foreign key actions] are considered trigger programs.)^ ^The | | | 895 896 897 898 899 900 901 902 903 904 905 | <li><p> <b>Recursion limit on foreign key actions.</b> ^(The [SQLITE_MAX_TRIGGER_DEPTH] and [SQLITE_LIMIT_TRIGGER_DEPTH] settings determine the maximum allowable depth of trigger program recursion. For the purposes of these limits, [foreign key actions] are considered trigger programs.)^ ^The [PRAGMA recursive_triggers] setting does not affect the operation of foreign key actions. It is not possible to disable recursive foreign key actions. </ol> |