Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
bind_parameter_name.html

Index Summary Markup Original


R-51077-27219-05589-60630-09467-24342-14957-57780 tcl slt th3 src

The sqlite3_bind_parameter_name(P,N) interface returns the name of the N-th SQL parameter in the prepared statement P.

th3/req1/bind04.test:14

/* IMP: R-51077-27219 */
# EVIDENCE-OF: R-51077-27219 The sqlite3_bind_parameter_name(P,N)
# interface returns the name of the N-th SQL parameter in the prepared
# statement P.

R-45882-09372-45562-22355-27454-39457-08272-55277 tcl slt th3 src

SQL parameters of the form "?NNN" or ":AAA" or "@AAA" or "$AAA" have a name which is the string "?NNN" or ":AAA" or "@AAA" or "$AAA" respectively. In other words, the initial ":" or "$" or "@" or "?" is included as part of the name.

th3/req1/bind04.test:18

/* IMP: R-45882-09372 */
# EVIDENCE-OF: R-45882-09372 SQL parameters of the form "?NNN" or ":AAA"
# or "@AAA" or "$AAA" have a name which is the string "?NNN" or ":AAA"
# or "@AAA" or "$AAA" respectively. In other words, the initial ":" or
# "$" or "@" or "?" is included as part of the name.

R-13183-30817-63475-03286-24149-37029-58658-28178 tcl slt th3 src

Parameters of the form "?" without a following integer have no name and are referred to as "nameless" or "anonymous parameters".

th3/req1/bind04.test:23

/* IMP: R-13183-30817 */
# EVIDENCE-OF: R-13183-30817 Parameters of the form "?" without a
# following integer have no name and are referred to as "nameless" or
# "anonymous parameters".

R-42680-10017-09402-35540-35488-37864-08326-19321 tcl slt th3 src

The first host parameter has an index of 1, not 0.

th3/req1/bind04.test:27

/* IMP: R-42680-10017 */
# EVIDENCE-OF: R-42680-10017 The first host parameter has an index of 1,
# not 0.

R-38595-30726-57286-21229-43510-46199-10154-57516 tcl slt th3 src

If the value N is out of range or if the N-th parameter is nameless, then NULL is returned.

th3/req1/bind04.test:33

/* IMP: R-38595-30726 */
# EVIDENCE-OF: R-38595-30726 If the value N is out of range or if the
# N-th parameter is nameless, then NULL is returned.

R-44190-32878-23725-35704-06982-10932-63377-41592 tcl slt th3 src

The returned string is always in UTF-8 encoding even if the named parameter was originally specified as UTF-16 in sqlite3_prepare16(), sqlite3_prepare16_v2(), or sqlite3_prepare16_v3().

th3/req1/bind04.test:48

/* IMP: R-44190-32878 */
# EVIDENCE-OF: R-44190-32878 The returned string is always in UTF-8
# encoding even if the named parameter was originally specified as
# UTF-16 in sqlite3_prepare16(), sqlite3_prepare16_v2(), or
# sqlite3_prepare16_v3().