sqlite3_column_name(), sqlite3_column_name16()

 ... The first parameter is the prepared statement that implements the SELECT statement. The second parameter is the column number. The leftmost column is number 0. The returned string pointer is valid until either the prepared statement is destroyed by sqlite3_finalize ... 

SQLITE_LIMIT_LENGTH, SQLITE_LIMIT_SQL_LENGTH, SQLITE_LIMIT_COLUMN, SQLITE_LIMIT_EXPR_DEPTH, SQLITE_LIMIT_COMPOUND_SELECT, SQLITE_LIMIT_VDBE_OP ... 

 ... SQLITE_LIMIT_VDBE_OP The maximum number of instructions in a virtual machine program used to implement an SQL statement. If sqlite3_prepare_v2() or the equivalent tries to allocate space for more than this many opcodes in a single prepared statement, an SQLITE_NOMEM error ... 

sqlite3_stmt_readonly()

The sqlite3_stmt_readonly(X) interface returns true (non-zero) if and only if the prepared statement X makes no direct changes to the content of the database file. Note that application-defined SQL functions or virtual tables might change the database ... 

 ... The sqlite3_finalize() routine deallocates a prepared SQL statement. All prepared statements must be finalized before the database can be closed. The sqlite3_reset() routine resets a prepared SQL statement so that it can be executed again. The SQL statement may contain ... 

sqlite3_bind_parameter_index()

 ... The parameter name must be given in UTF-8 even if the original statement was prepared from UTF-16 text using sqlite3_prepare16_v2() or sqlite3_prepare16_v3(). See also: sqlite3_bind(), sqlite3_bind_parameter_count(), and sqlite3_bind_parameter_name(). See also lists of Objects, Constants, and Functions.

sqlite3_bind_parameter_count()

This routine can be used to find the number of SQL parameters in a prepared statement. SQL parameters are tokens of the form "?", "?NNN", ":AAA", "$AAA", or "@AAA" that serve as placeholders for values that are bound to the parameters ... 

sqlite3_column_decltype(), sqlite3_column_decltype16()

The first parameter is a prepared statement. If this statement is a SELECT statement and the Nth column of the returned result set of that SELECT is a table column (not an expression or subquery) then the declared type of ... 

 ... clause The routines sqlite3_prepare_v2(), sqlite3_prepare(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_exec(), and sqlite3_get_table() accept an SQL statement list (sql-stmt-list) which is a semicolon-separated list of statements. sql-stmt-list: Each SQL statement in the statement list is an instance of ... 

2. Virtual Tables  ... bytecode A table-valued function that shows the bytecodes of a prepared statement. carray A table-valued function that allows a C-language array of integers, doubles, or strings to be used as table in a query. closure Compute the ... 

sqlite3_bind_parameter_name()

The sqlite3_bind_parameter_name(P,N) interface returns the name of the N-th SQL parameter in the prepared statement P. SQL parameters of the form "?NNN" or ":AAA" or "@AAA" or "$AAA" have a name which is the string "?NNN" or ...