/ Check-in [2fd487fd]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the header comment for sqlite3_blob_open to note that it is not possible to write to a column that is indexed, part of a primary key or, if foreign key support is enabled, part of a foreign key.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2fd487fdb669df89a8eb62cd0b7dc27ea1016edf
User & Date: dan 2009-10-07 11:29:40
Context
2009-10-07
16:04
Add a missing OP_Close opcode to VDBE programs that check for FK constraint violations. check-in: 5caa4a2b user: dan tags: trunk
11:29
Update the header comment for sqlite3_blob_open to note that it is not possible to write to a column that is indexed, part of a primary key or, if foreign key support is enabled, part of a foreign key. check-in: 2fd487fd user: dan tags: trunk
10:43
Update header file comments describing the sqlite3_changes and sqlite3_total_changes functions to describe how changes made by foreign key actions are handled. check-in: 4c342c02 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

  4503   4503   **
  4504   4504   ** <pre>
  4505   4505   **     SELECT zColumn FROM zDb.zTable WHERE [rowid] = iRow;
  4506   4506   ** </pre> {END}
  4507   4507   **
  4508   4508   ** If the flags parameter is non-zero, then the BLOB is opened for read
  4509   4509   ** and write access. If it is zero, the BLOB is opened for read access.
         4510  +** It is not possible to open a column that is part of an index or primary 
         4511  +** key for writing. ^If [foreign key constraints] are enabled, it is 
         4512  +** not possible to open a column that is part of a foreign key (sometimes 
         4513  +** termed a child key) for writing.
  4510   4514   **
  4511   4515   ** Note that the database name is not the filename that contains
  4512   4516   ** the database but rather the symbolic name of the database that
  4513   4517   ** is assigned when the database is connected using [ATTACH].
  4514   4518   ** For the main database file, the database name is "main".
  4515   4519   ** For TEMP tables, the database name is "temp".
  4516   4520   **