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().