Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Clarify the operation of sqlite3_last_insert_rowid() in the documentation. (CVS 3194) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
9e0b83b81f13277b9da877bdd96c544e |
User & Date: | drh 2006-05-27 11:15:48.000 |
Context
2006-05-31
| ||
11:12 | Fix typo in lang_analyze.html. (CVS 3195) (check-in: fba8ce8c38 user: drh tags: trunk) | |
2006-05-27
| ||
11:15 | Clarify the operation of sqlite3_last_insert_rowid() in the documentation. (CVS 3194) (check-in: 9e0b83b81f user: drh tags: trunk) | |
2006-05-26
| ||
19:57 | Allow SQL statements to be executed from within a progress callback. Be warned, however, that the progress callback might be called recursively in this case. It is up to the program to disable the progress callback to prevent recursive invocations. Ticket #1827. (CVS 3193) (check-in: ffc4730c05 user: drh tags: trunk) | |
Changes
Changes to www/capi3ref.tcl.
|
| | | 1 2 3 4 5 6 7 8 | set rcsid {$Id: capi3ref.tcl,v 1.39 2006/05/27 11:15:48 drh Exp $} source common.tcl header {C/C++ Interface For SQLite Version 3} puts { <h2>C/C++ Interface For SQLite Version 3</h2> } proc api {name prototype desc {notused x}} { |
︙ | ︙ | |||
891 892 893 894 895 896 897 | or Ctrl-C where the user wants a long query operation to halt immediately. } {} api {} { long long int sqlite3_last_insert_rowid(sqlite3*); } { | | > > | > | | | > > > < > > > > > | 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 | or Ctrl-C where the user wants a long query operation to halt immediately. } {} api {} { long long int sqlite3_last_insert_rowid(sqlite3*); } { Each entry in an SQLite table has a unique integer key called the "rowid". The rowid is always available as an undeclared column named ROWID, OID, or _ROWID_. If the table has a column of type INTEGER PRIMARY KEY then that column is another an alias for the rowid. This routine returns the rowid of the most recent INSERT into the database from the database connection given in the first argument. If no inserts have ever occurred on this database connection, zero is returned. If an INSERT occurs within a trigger, then the rowid of the inserted row is returned by this routine as long as the trigger is running. But once the trigger terminates, the value returned by this routine reverts to the last value inserted before the trigger fired. } {} api {} { char *sqlite3_mprintf(const char*,...); char *sqlite3_vmprintf(const char*, va_list); } { These routines are variants of the "sprintf()" from the |
︙ | ︙ |