The Error And Warning Log
(errlog.html)
2. Interface Details
... The pointer can be used to pass application-specific
setup or state information, if desired. Or it can simply be a NULL
pointer which is ignored by the callback.
The second argument to the error logger callback is an integer ...
|
The Session Extension
(sessionintro.html)
3.3. Inspecting the Contents of a Changeset
... Additionally, the same API
can be used to obtain the name of the table the change applies to
and its expected number of columns and primary key columns.
If the iterator points to a valid INSERT or UPDATE entry, the ...
|
The Schema Table
(schematab.html)
3. Interpretation Of The Schema Table
... rootpage
The sqlite_schema.rootpage column stores the page number of the root
b-tree page for tables and indexes. For rows that define views, triggers,
and virtual tables, the rootpage column is 0 or NULL.
sql
The sqlite_schema.sql column ...
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
6. Binding Parameters and Reusing Prepared Statements
... These values can
later be changed and the same prepared statement can be evaluated
a second time using the new values.
SQLite allows a parameter wherever a string literal,
blob literal, numeric constant, or NULL is allowed
in queries or ...
|
CREATE TRIGGER
(lang_createtrigger.html)
... The INDEXED BY and NOT INDEXED clauses are not supported for UPDATE and
DELETE statements.
The ORDER BY and LIMIT clauses on UPDATE and DELETE statements are not
supported. ORDER BY and LIMIT are not normally supported for UPDATE or ...
|
Constraint Conflict Resolution in SQLite
(conflict.html)
Constraint Conflict Resolution in SQLite
In most SQL databases, if you have a UNIQUE, NOT NULL, or
CHECK constraint on
a table and you try to do an UPDATE or INSERT that violates
the constraint, the database will abort the ...
|
C API: The pre-update hook.
(c3ref/preupdate_blobwrite.html)
sqlite3_preupdate_hook(), sqlite3_preupdate_old(), sqlite3_preupdate_count(), sqlite3_preupdate_depth(), sqlite3_preupdate_new(), sqlite3_preupdate_blobwrite()
... The N parameter must be between 0
and one less than the number of columns or the behavior will be
undefined. This must only be used within SQLITE_UPDATE and SQLITE_DELETE
preupdate callbacks; if it is used by an SQLITE_INSERT callback ...
|
8+3 Filenames
(shortnames.html)
... Make sure that database filenames follow the 8+3 filename
format and that they do not have an empty name or extension.
In other words, the database filename must contain between
1 and 8 characters in the base name and ...
|
CREATE INDEX
(lang_createindex.html)
... Descending Indexes
Each column name or expression can be followed by one
of the "ASC" or "DESC" keywords to indicate sort order.
The sort order may or may not be ignored depending
on the database file format, and in particular ...
|
SELECT
(lang_select.html)
... If the join-operator is "CROSS JOIN", "INNER JOIN", "JOIN" or a comma
(",") and there is no ON or USING clause, then the result of the join is
simply the cartesian product of the left and right-hand datasets.
If ...
|
Page generated by FTS5 in about 307.22 ms.