Sq3StmtC - bind a type … More...
Macros | |
#define | Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret void |
#define | Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args MK_PTR arg0 |
#define | Sq3Fupu_Sq3StmtBindBlobHide_cb_ret void |
#define | Sq3Fupu_Sq3StmtBindBlobHide_cb_args MK_PTR arg0 |
#define | Sq3Fupu_Sq3StmtBindPointer_arg4_ret void |
#define | Sq3Fupu_Sq3StmtBindPointer_arg4_args MK_PTR arg0 |
#define | Sq3Fupu_Sq3StmtBindText64Hide_cb_ret void |
#define | Sq3Fupu_Sq3StmtBindText64Hide_cb_args MK_PTR arg0 |
#define | Sq3Fupu_Sq3StmtBindTextHide_cb_ret void |
#define | Sq3Fupu_Sq3StmtBindTextHide_cb_args MK_PTR arg0 |
Functions | |
static enum MkErrorE | Sq3StmtBindBlob64Hide (SQ3_STMT sq3stmt, MK_I32 pos, MK_PTRN blob, MK_I64 len, Sq3Fupu_Sq3StmtBindBlob64Hide_cb cb) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindBlobHide (SQ3_STMT sq3stmt, MK_I32 pos, MK_PTRN blob, MK_I32 len, Sq3Fupu_Sq3StmtBindBlobHide_cb cb) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindDouble (SQ3_STMT sq3stmt, MK_I32 arg1, MK_DBL arg2) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindInt (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I32 arg2) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindInt64 (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I64 arg2) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindNull (SQ3_STMT sq3stmt, MK_I32 arg1) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindParameterCount (SQ3_STMT sq3stmt) |
Number Of SQL Parameters … | |
static enum MkErrorE | Sq3StmtBindParameterIndex (SQ3_STMT sq3stmt, MK_STRN zName) |
Index Of A Parameter With A Given Name … | |
static MK_STRN | Sq3StmtBindParameterName (SQ3_STMT sq3stmt, MK_I32 arg1) |
Name Of A Host Parameter … | |
static enum MkErrorE | Sq3StmtBindPointer (SQ3_STMT sq3stmt, MK_I32 arg1, MK_PTR arg2, MK_STRN arg3, Sq3Fupu_Sq3StmtBindPointer_arg4 arg4) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindText64Hide (SQ3_STMT sq3stmt, MK_I32 pos, MK_STRN text, MK_I64 len, Sq3Fupu_Sq3StmtBindText64Hide_cb cb, enum Sq3TextE encoding) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindTextHide (SQ3_STMT sq3stmt, MK_I32 pos, MK_STRN text, MK_I32 len, Sq3Fupu_Sq3StmtBindTextHide_cb cb) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindValue (SQ3_STMT sq3stmt, MK_I32 arg1, SQ3_VALN arg2) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindZeroblob (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I32 n) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindZeroblob64 (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I64 arg2) |
Binding Values To Prepared Statements … | |
static enum MkErrorE | Sq3StmtBindText64_RT (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkStringR text, enum Sq3TextE encoding) |
Bind a MkStringR Value To a Prepared Statement … | |
static enum MkErrorE | Sq3StmtBindText_RT (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkStringR text) |
Bind a MkStringR Value To a Prepared Statement … | |
static enum MkErrorE | Sq3StmtBindBlob64_RT (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkBinaryR blob) |
Bind a MkBinaryR Value To a Prepared Statement … | |
static enum MkErrorE | Sq3StmtBindBlob_RT (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkBinaryR blob) |
Bind a MkBinaryR Value To a Prepared Statement … | |
Sq3StmtC - bind a type …
#define Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args MK_PTR arg0 |
Definition at line 33 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret void |
Definition at line 32 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindBlobHide_cb_args MK_PTR arg0 |
Definition at line 40 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindBlobHide_cb_ret void |
Definition at line 39 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindPointer_arg4_args MK_PTR arg0 |
Definition at line 47 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindPointer_arg4_ret void |
Definition at line 46 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindText64Hide_cb_args MK_PTR arg0 |
Definition at line 54 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindText64Hide_cb_ret void |
Definition at line 53 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindTextHide_cb_args MK_PTR arg0 |
Definition at line 61 of file Sq3StmtC_sq3.h.
#define Sq3Fupu_Sq3StmtBindTextHide_cb_ret void |
Definition at line 60 of file Sq3StmtC_sq3.h.
#define Sq3StmtBindBlob | ( | ... | ) |
Definition at line 525 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob64 | ( | ... | ) |
Definition at line 529 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob64_C | ( | ... | ) |
Definition at line 531 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob64_E | ( | ... | ) |
Definition at line 530 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob64_NULL | ( | ... | ) |
Definition at line 528 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob64Hide_C | ( | ... | ) |
Definition at line 533 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob64Hide_E | ( | ... | ) |
Definition at line 532 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob_C | ( | ... | ) |
Definition at line 527 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob_E | ( | ... | ) |
Definition at line 526 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlob_NULL | ( | ... | ) |
Definition at line 524 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlobHide_C | ( | ... | ) |
Definition at line 535 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindBlobHide_E | ( | ... | ) |
Definition at line 534 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindDouble_C | ( | ... | ) |
Definition at line 537 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindDouble_E | ( | ... | ) |
Definition at line 536 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindInt64_C | ( | ... | ) |
Definition at line 541 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindInt64_E | ( | ... | ) |
Definition at line 540 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindInt_C | ( | ... | ) |
Definition at line 539 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindInt_E | ( | ... | ) |
Definition at line 538 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindNull_C | ( | ... | ) |
Definition at line 543 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindNull_E | ( | ... | ) |
Definition at line 542 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindParameterCount_C | ( | ... | ) |
Definition at line 545 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindParameterCount_E | ( | ... | ) |
Definition at line 544 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindParameterIndex_C | ( | ... | ) |
Definition at line 547 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindParameterIndex_E | ( | ... | ) |
Definition at line 546 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindPointer_C | ( | ... | ) |
Definition at line 549 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindPointer_E | ( | ... | ) |
Definition at line 548 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText | ( | ... | ) |
Definition at line 551 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText64 | ( | ... | ) |
Definition at line 555 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText64_C | ( | ... | ) |
Definition at line 557 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText64_E | ( | ... | ) |
Definition at line 556 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText64_NULL | ( | ... | ) |
Definition at line 554 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText64Hide_C | ( | ... | ) |
Definition at line 559 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText64Hide_E | ( | ... | ) |
Definition at line 558 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText_C | ( | ... | ) |
Definition at line 553 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText_E | ( | ... | ) |
Definition at line 552 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindText_NULL | ( | ... | ) |
Definition at line 550 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindTextHide_C | ( | ... | ) |
Definition at line 561 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindTextHide_E | ( | ... | ) |
Definition at line 560 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindValue_C | ( | ... | ) |
Definition at line 563 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindValue_E | ( | ... | ) |
Definition at line 562 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindZeroblob64_C | ( | ... | ) |
Definition at line 567 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindZeroblob64_E | ( | ... | ) |
Definition at line 566 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindZeroblob_C | ( | ... | ) |
Definition at line 565 of file sqlite3_overload_sq3.h.
#define Sq3StmtBindZeroblob_E | ( | ... | ) |
Definition at line 564 of file sqlite3_overload_sq3.h.
typedef Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret(* Sq3Fupu_Sq3StmtBindBlob64Hide_cb) (Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args) |
Definition at line 34 of file Sq3StmtC_sq3.h.
typedef Sq3Fupu_Sq3StmtBindBlobHide_cb_ret(* Sq3Fupu_Sq3StmtBindBlobHide_cb) (Sq3Fupu_Sq3StmtBindBlobHide_cb_args) |
Definition at line 41 of file Sq3StmtC_sq3.h.
typedef Sq3Fupu_Sq3StmtBindPointer_arg4_ret(* Sq3Fupu_Sq3StmtBindPointer_arg4) (Sq3Fupu_Sq3StmtBindPointer_arg4_args) |
Definition at line 48 of file Sq3StmtC_sq3.h.
typedef Sq3Fupu_Sq3StmtBindText64Hide_cb_ret(* Sq3Fupu_Sq3StmtBindText64Hide_cb) (Sq3Fupu_Sq3StmtBindText64Hide_cb_args) |
Definition at line 55 of file Sq3StmtC_sq3.h.
typedef Sq3Fupu_Sq3StmtBindTextHide_cb_ret(* Sq3Fupu_Sq3StmtBindTextHide_cb) (Sq3Fupu_Sq3StmtBindTextHide_cb_args) |
Definition at line 62 of file Sq3StmtC_sq3.h.
|
inlinestatic |
Bind a MkBinaryR Value To a Prepared Statement …
This is an enhanced version of Sq3StmtBindBlob64Hide using the Programming-Language-Micro-Kernel (PLMK) definition of a blob called MkBinaryR and the default value for the cb as SQLITE_TRANSIENT.
[in] | mkrt | the MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only) |
[in] | sq3stmt | the Sq3StmtC instance to work on a statement |
[in] | pos | The index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1. |
[in] | blob | The MkBinaryR value to be bind. |
MkExceptionC | → The default-exception from the Programming-Language-Micro-Kernel (PLMK) |
Definition at line 620 of file Sq3StmtC_sq3.h.
|
inlinestatic |
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 76 of file Sq3StmtC_sq3.h.
enum MkErrorE Sq3StmtBindBlob64HideP | ( | SQ3_STMT | sq3stmt, |
MK_I32 | pos, | ||
MK_PTRN | blob, | ||
MK_I64 | len, | ||
Sq3Fupu_Sq3StmtBindBlob64Hide_cb | cb ) |
Non-inline replacement for Sq3StmtBindBlob64Hide …
Non-inline replacement for Sq3StmtBindBlob64 …
|
inlinestatic |
Bind a MkBinaryR Value To a Prepared Statement …
This is an enhanced version of Sq3StmtBindBlob64Hide using the Programming-Language-Micro-Kernel (PLMK) definition of a blob called MkBinaryR and the default value for the cb as SQLITE_TRANSIENT.
[in] | mkrt | the MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only) |
[in] | sq3stmt | the Sq3StmtC instance to work on a statement |
[in] | pos | The index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1. |
[in] | blob | The MkBinaryR value to be bind. |
MkExceptionC | → The default-exception from the Programming-Language-Micro-Kernel (PLMK) |
Definition at line 645 of file Sq3StmtC_sq3.h.
|
inlinestatic |
Binding Values To Prepared Statements …
In the SQL statement text input to Sq3StmtPrepareV2 () and its variants, literals may be replaced by a parameter that matches one of following templates:
In the templates above, NNN represents an integer literal, and VVV represents an alphanumeric identifier. The values of these parameters (also called "host parameter names" or "SQL parameters") can be set using the Sq3StmtBindValue*() routines defined here.
The first argument to the Sq3StmtBindValue*() routines is always a pointer to the Sq3StmtC object returned from Sq3StmtPrepareV2 () or its variants.
The second argument is the index of the SQL parameter to be set. The leftmost SQL parameter has an index of 1. When the same named SQL parameter is used more than once, second and subsequent occurrences have the same index as the first occurrence. The index for named parameters can be looked up using the Sq3StmtBindParameterIndex () API if desired. The index for "?NNN" parameters is the value of NNN. The NNN value must be between 1 and the Sq3LiteLimit () parameter SQ3_LIMIT_VARIABLE_NUMBER (default value: 32766).
The third argument is the value to bind to the parameter. If the third parameter to Sq3StmtBindText() or sqlite3_bind_text16() or Sq3StmtBindBlob() is a NULL pointer then the fourth parameter is ignored and the end result is the same as Sq3StmtBindNull(). If the third parameter to Sq3StmtBindText() is not NULL, then it should be a pointer to well-formed UTF8 text. If the third parameter to sqlite3_bind_text16() is not NULL, then it should be a pointer to well-formed UTF16 text. If the third parameter to Sq3StmtBindText64() is not NULL, then it should be a pointer to a well-formed unicode string that is either UTF8 if the sixth parameter is SQ3_TEXT_UTF8, or UTF16 otherwise.
The byte-order of UTF16 input text is determined by the byte-order mark (BOM, U+FEFF) found in first character, which is removed, or in the absence of a BOM the byte order is the native byte order of the host machine for sqlite3_bind_text16() or the byte order specified in the 6th parameter for Sq3StmtBindText64(). If UTF16 input text contains invalid unicode characters, then SQLite might change those invalid characters into the unicode replacement character: U+FFFD.
In those routines that have a fourth argument, its value is the number of bytes in the parameter. To be clear: the value is the number of bytes in the value, not the number of characters. If the fourth parameter to Sq3StmtBindText() or sqlite3_bind_text16() is negative, then the length of the string is the number of bytes up to the first zero terminator. If the fourth parameter to Sq3StmtBindBlob() is negative, then the behavior is undefined. If a non-negative fourth parameter is provided to Sq3StmtBindText() or sqlite3_bind_text16() or Sq3StmtBindText64() then that parameter must be the byte offset where the NUL terminator would occur assuming the string were NUL terminated. If any NUL characters occurs at byte offsets less than the value of the fourth parameter then the resulting string value will contain embedded NULs. The result of expressions involving strings with embedded NULs is undefined.
The fifth argument to the BLOB and string binding interfaces controls or indicates the lifetime of the object referenced by the third parameter. These three options exist: (1) A destructor to dispose of the BLOB or string after SQLite has finished with it may be passed. It is called to dispose of the BLOB or string even if the call to the bind API fails, except the destructor is not called if the third parameter is a NULL pointer or the fourth parameter is negative. (2) The special constant, SQLITE_STATIC, may be passed to indicate that the application remains responsible for disposing of the object. In this case, the object and the provided pointer to it must remain valid until either the prepared statement is finalized or the same SQL parameter is bound to something else, whichever occurs sooner. (3) The constant, SQLITE_TRANSIENT, may be passed to indicate that the object is to be copied prior to the return from Sq3StmtBindValue*(). The object and pointer to it must remain valid until then. SQLite will then manage the lifetime of its private copy.
The sixth argument to Sq3StmtBindText64() must be one of SQ3_TEXT_UTF8, SQ3_TEXT_UTF16, SQ3_TEXT_UTF16BE, or SQ3_TEXT_UTF16LE to specify the encoding of the text in the third parameter. If the sixth argument to Sq3StmtBindText64() is not one of the allowed values shown above, or if the text encoding is different from the encoding specified by the sixth parameter, then the behavior is undefined.
The Sq3StmtBindZeroblob() routine binds a BLOB of length N that is filled with zeroes. A zeroblob uses a fixed amount of memory (just an integer to hold its size) while it is being processed. Zeroblobs are intended to serve as placeholders for BLOBs whose content is later written using incremental BLOB I/O routines. A negative value for the zeroblob results in a zero-length BLOB.
The Sq3StmtBindPointer(S,I,P,T,D) routine causes the I-th parameter in prepared statement S to have an SQL value of NULL, but to also be associated with the pointer P of type T. D is either a NULL pointer or a pointer to a destructor function for P. SQLite will invoke the destructor D with a single argument of P when it is finished using P. The T parameter should be a static string, preferably a string literal. The Sq3StmtBindPointer() routine is part of the pointer passing interface added for SQLite 3.20.0.
If any of the Sq3StmtBindValue*() routines are called with a NULL pointer for the prepared statement or with a prepared statement for which Sq3StmtStep () has been called more recently than Sq3StmtReset (), then the call will return SQ3_RESULT_MISUSE. If any Sq3StmtBindValue() routine is passed a prepared statement that has been finalized, the result is undefined and probably harmful.
Bindings are not cleared by the Sq3StmtReset () routine. Unbound parameters are interpreted as NULL.
The Sq3StmtBindValue* routines return SQ3_RESULT_OK on success or an error code if anything goes wrong. SQ3_RESULT_TOOBIG might be returned if the size of a string or BLOB exceeds limits imposed by Sq3LiteLimit(SQ3_LIMIT_LENGTH) or SQLITE_MAX_LENGTH. SQ3_RESULT_RANGE is returned if the parameter index is out of range. SQ3_RESULT_NOMEM is returned if malloc() fails.
See also: Sq3StmtBindParameterCount (), Sq3StmtBindParameterName (), and Sq3StmtBindParameterIndex ().
Reference code from sqlite3:
Definition at line 86 of file Sq3StmtC_sq3.h.
enum MkErrorE Sq3StmtBindBlobHideP | ( | SQ3_STMT | sq3stmt, |
MK_I32 | pos, | ||
MK_PTRN | blob, | ||
MK_I32 | len, | ||
Sq3Fupu_Sq3StmtBindBlobHide_cb | cb ) |
Non-inline replacement for Sq3StmtBindBlobHide …
Non-inline replacement for Sq3StmtBindBlob …
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 96 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindDouble …
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 106 of file Sq3StmtC_sq3.h.
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 116 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindInt64 …
Non-inline replacement for Sq3StmtBindInt …
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 126 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindNull …
Number Of SQL Parameters …
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 "@@amp;AAA" that serve as placeholders for values that are bound to the parameters at a later time.
This routine actually returns the index of the largest (rightmost) parameter. For all forms except ?NNN, this will correspond to the number of unique parameters. If parameters of the ?NNN form are used, there may be gaps in the list.
See also: sqlite3_bind(), Sq3StmtBindParameterName (), and Sq3StmtBindParameterIndex ().
Reference code from sqlite3:
Definition at line 136 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindParameterCount …
Index Of A Parameter With A Given Name …
Return the index of an SQL parameter given its name. The index value returned is suitable for use as the second parameter to sqlite3_bind(). A zero is returned if no matching parameter is found. 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(), Sq3StmtBindParameterCount (), and Sq3StmtBindParameterName ().
Reference code from sqlite3:
Definition at line 146 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindParameterIndex …
Name Of A Host Parameter …
The Sq3StmtBindParameterName(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 "@@amp;AAA" or "$AAA" have a name which is the string "?NNN" or ":AAA" or "@@amp;AAA" or "$AAA" respectively. In other words, the initial ":" or "$" or "@@amp;" or "?" is included as part of the name. Parameters of the form "?" without a following integer have no name and are referred to as "nameless" or "anonymous parameters".
The first host parameter has an index of 1, not 0.
If the value N is out of range or if the N-th parameter is nameless, then NULL is returned. 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 ().
See also: sqlite3_bind(), Sq3StmtBindParameterCount (), and Sq3StmtBindParameterIndex ().
Reference code from sqlite3:
Definition at line 156 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindParameterName …
|
inlinestatic |
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 163 of file Sq3StmtC_sq3.h.
enum MkErrorE Sq3StmtBindPointerP | ( | SQ3_STMT | sq3stmt, |
MK_I32 | arg1, | ||
MK_PTR | arg2, | ||
MK_STRN | arg3, | ||
Sq3Fupu_Sq3StmtBindPointer_arg4 | arg4 ) |
Non-inline replacement for Sq3StmtBindPointer …
|
inlinestatic |
Bind a MkStringR Value To a Prepared Statement …
This is an enhanced version of Sq3StmtBindText64Hide using the Programming-Language-Micro-Kernel (PLMK) definition of a text called MkStringR and the default value for the cb as SQLITE_TRANSIENT.
[in] | mkrt | the MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only) |
[in] | sq3stmt | the Sq3StmtC instance to work on a statement |
[in] | pos | The index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1. |
[in] | text | The MkStringR value to be bind. |
[in] | encoding | The encoding of the text using one of the Sq3TextE values. |
MkExceptionC | → The default-exception from the Programming-Language-Micro-Kernel (PLMK) |
Definition at line 568 of file Sq3StmtC_sq3.h.
|
inlinestatic |
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 173 of file Sq3StmtC_sq3.h.
enum MkErrorE Sq3StmtBindText64HideP | ( | SQ3_STMT | sq3stmt, |
MK_I32 | pos, | ||
MK_STRN | text, | ||
MK_I64 | len, | ||
Sq3Fupu_Sq3StmtBindText64Hide_cb | cb, | ||
enum Sq3TextE | encoding ) |
Non-inline replacement for Sq3StmtBindText64Hide …
enum MkErrorE Sq3StmtBindText64P | ( | MK_RT | mkrt, |
SQ3_STMT | sq3stmt, | ||
MK_I32 | pos, | ||
MkStringR | text, | ||
enum Sq3TextE | encoding ) |
Non-inline replacement for Sq3StmtBindText64 …
|
inlinestatic |
Bind a MkStringR Value To a Prepared Statement …
This is an enhanced version of Sq3StmtBindText64Hide using the Programming-Language-Micro-Kernel (PLMK) definition of a text called MkStringR and the default value for the cb as SQLITE_TRANSIENT.
[in] | mkrt | the MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only) |
[in] | sq3stmt | the Sq3StmtC instance to work on a statement |
[in] | pos | The index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1. |
[in] | text | The MkStringR value to be bind. |
MkExceptionC | → The default-exception from the Programming-Language-Micro-Kernel (PLMK) |
Definition at line 594 of file Sq3StmtC_sq3.h.
|
inlinestatic |
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 183 of file Sq3StmtC_sq3.h.
enum MkErrorE Sq3StmtBindTextHideP | ( | SQ3_STMT | sq3stmt, |
MK_I32 | pos, | ||
MK_STRN | text, | ||
MK_I32 | len, | ||
Sq3Fupu_Sq3StmtBindTextHide_cb | cb ) |
Non-inline replacement for Sq3StmtBindTextHide …
Non-inline replacement for Sq3StmtBindText …
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 193 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindValue …
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 204 of file Sq3StmtC_sq3.h.
|
inlinestatic |
Binding Values To Prepared Statements …
read more at 'Sq3StmtBindBlob'
Definition at line 214 of file Sq3StmtC_sq3.h.
Non-inline replacement for Sq3StmtBindZeroblob64 …
Non-inline replacement for Sq3StmtBindZeroblob …