/ Check-in [a4c5804e]
Login

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

Overview
Comment:Updates to documentation on sqlite3_last_insert_rowid(). No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a4c5804efc63ff993e93f8a7b6acb6bb0a19dd3e
User & Date: drh 2013-11-09 21:19:12
Context
2013-11-09
22:08
Add the sqlite3_win32_compact_heap() function for cleaning up memory allocations on Win32 system. Also cleanup the winGetTempname() function. Changes to the Win32 VFS only. check-in: d06d9fdb user: drh tags: trunk
21:19
Updates to documentation on sqlite3_last_insert_rowid(). No changes to code. check-in: a4c5804e user: drh tags: trunk
19:47
Updates to requirements marks. No changes to code. check-in: 8a036628 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/sqlite.h.in.

  1778   1778   ** codes are disabled by default for historical compatibility.
  1779   1779   */
  1780   1780   int sqlite3_extended_result_codes(sqlite3*, int onoff);
  1781   1781   
  1782   1782   /*
  1783   1783   ** CAPI3REF: Last Insert Rowid
  1784   1784   **
  1785         -** ^Each entry in an SQLite table has a unique 64-bit signed
         1785  +** ^Each entry in most SQLite tables (except for [WITHOUT ROWID] tables)
         1786  +** has a unique 64-bit signed
  1786   1787   ** integer key called the [ROWID | "rowid"]. ^The rowid is always available
  1787   1788   ** as an undeclared column named ROWID, OID, or _ROWID_ as long as those
  1788   1789   ** names are not also used by explicitly declared columns. ^If
  1789   1790   ** the table has a column of type [INTEGER PRIMARY KEY] then that column
  1790   1791   ** is another alias for the rowid.
  1791   1792   **
  1792         -** ^This routine returns the [rowid] of the most recent
  1793         -** successful [INSERT] into a rowid table from the [database connection]
  1794         -** in the first argument.  ^As of SQLite version 3.7.7, this routines
  1795         -** records the last insert rowid of both ordinary tables and [virtual tables].
         1793  +** ^The sqlite3_last_insert_rowid(D) interface returns the [rowid] of the 
         1794  +** most recent successful [INSERT] into a rowid table or [virtual table]
         1795  +** on database connection D.
  1796   1796   ** ^Inserts into [WITHOUT ROWID] tables are not recorded.
  1797   1797   ** ^If no successful [INSERT]s into rowid tables
  1798   1798   ** have ever occurred on the database connection D, 
  1799   1799   ** then sqlite3_last_insert_rowid(D) returns zero.
  1800   1800   **
  1801   1801   ** ^(If an [INSERT] occurs within a trigger or within a [virtual table]
  1802   1802   ** method, then this routine will return the [rowid] of the inserted