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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
9e0b83b81f13277b9da877bdd96c544e |
| User & Date: | drh 2006-05-27 11:15:48 |
Context
|
2006-05-31
| ||
| 11:12 | Fix typo in lang_analyze.html. (CVS 3195) check-in: fba8ce8c user: drh tags: trunk | |
|
2006-05-27
| ||
| 11:15 | Clarify the operation of sqlite3_last_insert_rowid() in the documentation. (CVS 3194) check-in: 9e0b83b8 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: ffc4730c user: drh tags: trunk | |
Changes
Changes to www/capi3ref.tcl.
1
2
3
4
5
6
7
8
...
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
|
set rcsid {$Id: capi3ref.tcl,v 1.38 2006/04/05 01:08:35 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}} {
................................................................................
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. (The key is
the value of the INTEGER PRIMARY KEY column if there is such a column,
otherwise the key is generated at random. The unique key is always
available as the ROWID, OID, or _ROWID_ column.) This routine
returns the integer key of the most recent insert in the database.
This function is similar to the mysql_insert_id() function from MySQL.
} {}
api {} {
char *sqlite3_mprintf(const char*,...);
char *sqlite3_vmprintf(const char*, va_list);
} {
These routines are variants of the "sprintf()" from the
|
|
|
|
<
|
>
|
|
>
>
>
>
>
>
>
>
>
>
|
1
2
3
4
5
6
7
8
...
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
|
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}} {
................................................................................
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
|