C API: Obtain Values For URI Parameters
(c3ref/uri_boolean.html)
sqlite3_uri_parameter(), sqlite3_uri_boolean(), sqlite3_uri_int64(), sqlite3_uri_key()
... The sqlite3_uri_boolean(F,P,B) routine assumes that P is a boolean
parameter and returns true (1) or false (0) according to the value
of P. The sqlite3_uri_boolean(F,P,B) routine returns true (1) if the
value of query ...
|
The DBSTAT Virtual Table
(dbstat.html)
1. Overview
... However, if the hidden column "aggregate" is TRUE, then
results are aggregated and there is a single row in the DBSTAT table
for each btree in the database, providing information about space
utilization across the entire btree.
|
Partial Indexes
(partialindex.html)
3. Queries Using Partial Indexes
... Instead, SQLite uses
two simple rules to find the common cases where W⇒X is true, and
it assumes all the other cases are false. The rules used by SQLite
are these:
If W is AND-connected terms and ...
|
JSON Functions And Operators
(json1.html)
4.10. The json_type() function
... json_type('{"a":[2,3.5,true,false,null,"x"]}')
→ 'object'
json_type('{"a":[2,3.5,true,false,null,"x"]}','$')
→ 'object'
json_type('{"a":[2,3.5,true,false,null,"x"]}','$.a')
→ 'array'
json_type('{"a":[2,3.5,true ...
|
C API: Database Connection Status
(c3ref/db_status.html)
sqlite3_db_status()
... If
the resetFlg is true, then the highest instantaneous value is
reset back down to the current value.
The sqlite3_db_status() routine returns SQLITE_OK on success and a
non-zero error code on failure.
See also: sqlite3_status() and sqlite3_stmt_status().
See also ...
|
C API: Determine If A Prepared Statement Has Been Reset
(c3ref/stmt_busy.html)
sqlite3_stmt_busy()
The sqlite3_stmt_busy(S) interface returns true (non-zero) if the
prepared statement S has been stepped at least once using
sqlite3_step(S) but has neither run to completion (returned
SQLITE_DONE from sqlite3_step(S)) nor
been reset using sqlite3_reset(S). The ...
|
C API: Memory Allocator Statistics
(c3ref/memory_highwater.html)
sqlite3_memory_used(), sqlite3_memory_highwater()
... The memory high-water mark is reset to the current value of
sqlite3_memory_used() if and only if the parameter to
sqlite3_memory_highwater() is true. The value returned
by sqlite3_memory_highwater(1) is the high-water mark
prior to the reset.
See also ...
|
C API: Prepared Statement Status
(c3ref/stmt_status.html)
sqlite3_stmt_status()
... If the resetFlg is true, then the counter is reset to zero after this
interface call returns.
See also: sqlite3_status() and sqlite3_db_status().
See also lists of
Objects,
Constants, and
Functions.
*** DRAFT ***
|
Row Values
(rowvalue.html)
2.1. Row Value Comparisons
... The overall result of comparison is NULL if it is possible to make the
result either true or false by substituting alternative values in place
of the constituent NULLs.
The following query demonstrates some row value comparisons:
SELECT
(1,2 ...
|
C API: SQLite Runtime Status
(c3ref/status.html)
sqlite3_status(), sqlite3_status64()
... If the
resetFlag is true, then the highest record value is reset after
*pHighwater is written. Some parameters do not record the highest
value. For those parameters
nothing is written into *pHighwater and the resetFlag is ignored.
Other parameters record ...
|
Page generated by FTS5 in about 71.60 ms.