theSq3Lite 10.0
Loading...
Searching...
No Matches
Sq3StmtC_Bind_C_API

Sq3StmtC - bind a typeMore...

+ Collaboration diagram for Sq3StmtC_Bind_C_API:

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
 

Typedefs

typedef Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret(* Sq3Fupu_Sq3StmtBindBlob64Hide_cb) (Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args)
 
typedef Sq3Fupu_Sq3StmtBindBlobHide_cb_ret(* Sq3Fupu_Sq3StmtBindBlobHide_cb) (Sq3Fupu_Sq3StmtBindBlobHide_cb_args)
 
typedef Sq3Fupu_Sq3StmtBindPointer_arg4_ret(* Sq3Fupu_Sq3StmtBindPointer_arg4) (Sq3Fupu_Sq3StmtBindPointer_arg4_args)
 
typedef Sq3Fupu_Sq3StmtBindText64Hide_cb_ret(* Sq3Fupu_Sq3StmtBindText64Hide_cb) (Sq3Fupu_Sq3StmtBindText64Hide_cb_args)
 
typedef Sq3Fupu_Sq3StmtBindTextHide_cb_ret(* Sq3Fupu_Sq3StmtBindTextHide_cb) (Sq3Fupu_Sq3StmtBindTextHide_cb_args)
 

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 - Sq3StmtC_Bind_C_API - function

enum MkErrorE Sq3StmtBindBlobP (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkBinaryR blob)
 Non-inline replacement for Sq3StmtBindBlob
 
enum MkErrorE Sq3StmtBindBlob64P (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkBinaryR blob)
 Non-inline replacement for Sq3StmtBindBlob64
 
enum MkErrorE Sq3StmtBindBlob64HideP (SQ3_STMT sq3stmt, MK_I32 pos, MK_PTRN blob, MK_I64 len, Sq3Fupu_Sq3StmtBindBlob64Hide_cb cb)
 Non-inline replacement for Sq3StmtBindBlob64Hide
 
enum MkErrorE Sq3StmtBindBlobHideP (SQ3_STMT sq3stmt, MK_I32 pos, MK_PTRN blob, MK_I32 len, Sq3Fupu_Sq3StmtBindBlobHide_cb cb)
 Non-inline replacement for Sq3StmtBindBlobHide
 
enum MkErrorE Sq3StmtBindDoubleP (SQ3_STMT sq3stmt, MK_I32 arg1, MK_DBL arg2)
 Non-inline replacement for Sq3StmtBindDouble
 
enum MkErrorE Sq3StmtBindIntP (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I32 arg2)
 Non-inline replacement for Sq3StmtBindInt
 
enum MkErrorE Sq3StmtBindInt64P (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I64 arg2)
 Non-inline replacement for Sq3StmtBindInt64
 
enum MkErrorE Sq3StmtBindNullP (SQ3_STMT sq3stmt, MK_I32 arg1)
 Non-inline replacement for Sq3StmtBindNull
 
enum MkErrorE Sq3StmtBindParameterCountP (SQ3_STMT sq3stmt)
 Non-inline replacement for Sq3StmtBindParameterCount
 
enum MkErrorE Sq3StmtBindParameterIndexP (SQ3_STMT sq3stmt, MK_STRN zName)
 Non-inline replacement for Sq3StmtBindParameterIndex
 
MK_STRN Sq3StmtBindParameterNameP (SQ3_STMT sq3stmt, MK_I32 arg1)
 Non-inline replacement for Sq3StmtBindParameterName
 
enum MkErrorE Sq3StmtBindPointerP (SQ3_STMT sq3stmt, MK_I32 arg1, MK_PTR arg2, MK_STRN arg3, Sq3Fupu_Sq3StmtBindPointer_arg4 arg4)
 Non-inline replacement for Sq3StmtBindPointer
 
enum MkErrorE Sq3StmtBindTextP (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkStringR text)
 Non-inline replacement for Sq3StmtBindText
 
enum MkErrorE Sq3StmtBindText64P (MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkStringR text, enum Sq3TextE encoding)
 Non-inline replacement for Sq3StmtBindText64
 
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 Sq3StmtBindTextHideP (SQ3_STMT sq3stmt, MK_I32 pos, MK_STRN text, MK_I32 len, Sq3Fupu_Sq3StmtBindTextHide_cb cb)
 Non-inline replacement for Sq3StmtBindTextHide
 
enum MkErrorE Sq3StmtBindValueP (SQ3_STMT sq3stmt, MK_I32 arg1, SQ3_VALN arg2)
 Non-inline replacement for Sq3StmtBindValue
 
enum MkErrorE Sq3StmtBindZeroblobP (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I32 n)
 Non-inline replacement for Sq3StmtBindZeroblob
 
enum MkErrorE Sq3StmtBindZeroblob64P (SQ3_STMT sq3stmt, MK_I32 arg1, MK_I64 arg2)
 Non-inline replacement for Sq3StmtBindZeroblob64
 

Sq3StmtC - Sq3StmtC_Bind_C_API - overload

#define Sq3StmtBindBlob_NULL(...)
 
#define Sq3StmtBindBlob(...)
 
#define Sq3StmtBindBlob_E(...)
 
#define Sq3StmtBindBlob_C(...)
 
#define Sq3StmtBindBlob64_NULL(...)
 
#define Sq3StmtBindBlob64(...)
 
#define Sq3StmtBindBlob64_E(...)
 
#define Sq3StmtBindBlob64_C(...)
 
#define Sq3StmtBindBlob64Hide_E(...)
 
#define Sq3StmtBindBlob64Hide_C(...)
 
#define Sq3StmtBindBlobHide_E(...)
 
#define Sq3StmtBindBlobHide_C(...)
 
#define Sq3StmtBindDouble_E(...)
 
#define Sq3StmtBindDouble_C(...)
 
#define Sq3StmtBindInt_E(...)
 
#define Sq3StmtBindInt_C(...)
 
#define Sq3StmtBindInt64_E(...)
 
#define Sq3StmtBindInt64_C(...)
 
#define Sq3StmtBindNull_E(...)
 
#define Sq3StmtBindNull_C(...)
 
#define Sq3StmtBindParameterCount_E(...)
 
#define Sq3StmtBindParameterCount_C(...)
 
#define Sq3StmtBindParameterIndex_E(...)
 
#define Sq3StmtBindParameterIndex_C(...)
 
#define Sq3StmtBindPointer_E(...)
 
#define Sq3StmtBindPointer_C(...)
 
#define Sq3StmtBindText_NULL(...)
 
#define Sq3StmtBindText(...)
 
#define Sq3StmtBindText_E(...)
 
#define Sq3StmtBindText_C(...)
 
#define Sq3StmtBindText64_NULL(...)
 
#define Sq3StmtBindText64(...)
 
#define Sq3StmtBindText64_E(...)
 
#define Sq3StmtBindText64_C(...)
 
#define Sq3StmtBindText64Hide_E(...)
 
#define Sq3StmtBindText64Hide_C(...)
 
#define Sq3StmtBindTextHide_E(...)
 
#define Sq3StmtBindTextHide_C(...)
 
#define Sq3StmtBindValue_E(...)
 
#define Sq3StmtBindValue_C(...)
 
#define Sq3StmtBindZeroblob_E(...)
 
#define Sq3StmtBindZeroblob_C(...)
 
#define Sq3StmtBindZeroblob64_E(...)
 
#define Sq3StmtBindZeroblob64_C(...)
 

Detailed Description

Sq3StmtC - bind a type

Macro Definition Documentation

◆ Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args

#define Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args   MK_PTR arg0

Definition at line 30 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret

#define Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret   void

Definition at line 29 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindBlobHide_cb_args

#define Sq3Fupu_Sq3StmtBindBlobHide_cb_args   MK_PTR arg0

Definition at line 37 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindBlobHide_cb_ret

#define Sq3Fupu_Sq3StmtBindBlobHide_cb_ret   void

Definition at line 36 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindPointer_arg4_args

#define Sq3Fupu_Sq3StmtBindPointer_arg4_args   MK_PTR arg0

Definition at line 44 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindPointer_arg4_ret

#define Sq3Fupu_Sq3StmtBindPointer_arg4_ret   void

Definition at line 43 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindText64Hide_cb_args

#define Sq3Fupu_Sq3StmtBindText64Hide_cb_args   MK_PTR arg0

Definition at line 51 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindText64Hide_cb_ret

#define Sq3Fupu_Sq3StmtBindText64Hide_cb_ret   void

Definition at line 50 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindTextHide_cb_args

#define Sq3Fupu_Sq3StmtBindTextHide_cb_args   MK_PTR arg0

Definition at line 58 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindTextHide_cb_ret

#define Sq3Fupu_Sq3StmtBindTextHide_cb_ret   void

Definition at line 57 of file Sq3StmtC_sq3.h.

◆ Sq3StmtBindBlob

#define Sq3StmtBindBlob ( ...)
Value:
#define MK_RT_CALL
static enum MkErrorE Sq3StmtBindBlob_RT(MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkBinaryR blob)
Bind a MkBinaryR Value To a Prepared Statement …

Definition at line 522 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob64

#define Sq3StmtBindBlob64 ( ...)
Value:
static enum MkErrorE Sq3StmtBindBlob64_RT(MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkBinaryR blob)
Bind a MkBinaryR Value To a Prepared Statement …

Definition at line 526 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob64_C

#define Sq3StmtBindBlob64_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindBlob64(__VA_ARGS__)))
#define Sq3StmtBindBlob64(...)

Definition at line 528 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob64_E

#define Sq3StmtBindBlob64_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindBlob64(__VA_ARGS__))

Definition at line 527 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob64_NULL

#define Sq3StmtBindBlob64_NULL ( ...)
Value:
#define MK_RT_CALL_NULL

Definition at line 525 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob64Hide_C

#define Sq3StmtBindBlob64Hide_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindBlob64Hide(__VA_ARGS__)))
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 …

Definition at line 530 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob64Hide_E

#define Sq3StmtBindBlob64Hide_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindBlob64Hide(__VA_ARGS__))

Definition at line 529 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob_C

#define Sq3StmtBindBlob_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindBlob(__VA_ARGS__)))
#define Sq3StmtBindBlob(...)

Definition at line 524 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob_E

#define Sq3StmtBindBlob_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindBlob(__VA_ARGS__))

Definition at line 523 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlob_NULL

#define Sq3StmtBindBlob_NULL ( ...)
Value:

Definition at line 521 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlobHide_C

#define Sq3StmtBindBlobHide_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindBlobHide(__VA_ARGS__)))
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 …

Definition at line 532 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindBlobHide_E

#define Sq3StmtBindBlobHide_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindBlobHide(__VA_ARGS__))

Definition at line 531 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindDouble_C

#define Sq3StmtBindDouble_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindDouble(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindDouble(SQ3_STMT sq3stmt, MK_I32 arg1, MK_DBL arg2)
Binding Values To Prepared Statements …

Definition at line 534 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindDouble_E

#define Sq3StmtBindDouble_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindDouble(__VA_ARGS__))

Definition at line 533 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindInt64_C

#define Sq3StmtBindInt64_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindInt64(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindInt64(SQ3_STMT sq3stmt, MK_I32 arg1, MK_I64 arg2)
Binding Values To Prepared Statements …

Definition at line 538 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindInt64_E

#define Sq3StmtBindInt64_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindInt64(__VA_ARGS__))

Definition at line 537 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindInt_C

#define Sq3StmtBindInt_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindInt(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindInt(SQ3_STMT sq3stmt, MK_I32 arg1, MK_I32 arg2)
Binding Values To Prepared Statements …

Definition at line 536 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindInt_E

#define Sq3StmtBindInt_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindInt(__VA_ARGS__))

Definition at line 535 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindNull_C

#define Sq3StmtBindNull_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindNull(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindNull(SQ3_STMT sq3stmt, MK_I32 arg1)
Binding Values To Prepared Statements …

Definition at line 540 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindNull_E

#define Sq3StmtBindNull_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindNull(__VA_ARGS__))

Definition at line 539 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindParameterCount_C

#define Sq3StmtBindParameterCount_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindParameterCount(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindParameterCount(SQ3_STMT sq3stmt)
Number Of SQL Parameters …

Definition at line 542 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindParameterCount_E

#define Sq3StmtBindParameterCount_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindParameterCount(__VA_ARGS__))

Definition at line 541 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindParameterIndex_C

#define Sq3StmtBindParameterIndex_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindParameterIndex(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindParameterIndex(SQ3_STMT sq3stmt, MK_STRN zName)
Index Of A Parameter With A Given Name …

Definition at line 544 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindParameterIndex_E

#define Sq3StmtBindParameterIndex_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindParameterIndex(__VA_ARGS__))

Definition at line 543 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindPointer_C

#define Sq3StmtBindPointer_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindPointer(__VA_ARGS__)))
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 …

Definition at line 546 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindPointer_E

#define Sq3StmtBindPointer_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindPointer(__VA_ARGS__))

Definition at line 545 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText

#define Sq3StmtBindText ( ...)
Value:
static enum MkErrorE Sq3StmtBindText_RT(MK_RT mkrt, SQ3_STMT sq3stmt, MK_I32 pos, MkStringR text)
Bind a MkStringR Value To a Prepared Statement …

Definition at line 548 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText64

#define Sq3StmtBindText64 ( ...)
Value:
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 …

Definition at line 552 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText64_C

#define Sq3StmtBindText64_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindText64(__VA_ARGS__)))
#define Sq3StmtBindText64(...)

Definition at line 554 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText64_E

#define Sq3StmtBindText64_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindText64(__VA_ARGS__))

Definition at line 553 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText64_NULL

#define Sq3StmtBindText64_NULL ( ...)
Value:

Definition at line 551 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText64Hide_C

#define Sq3StmtBindText64Hide_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindText64Hide(__VA_ARGS__)))
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 …

Definition at line 556 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText64Hide_E

#define Sq3StmtBindText64Hide_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindText64Hide(__VA_ARGS__))

Definition at line 555 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText_C

#define Sq3StmtBindText_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindText(__VA_ARGS__)))
#define Sq3StmtBindText(...)

Definition at line 550 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText_E

#define Sq3StmtBindText_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindText(__VA_ARGS__))

Definition at line 549 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindText_NULL

#define Sq3StmtBindText_NULL ( ...)
Value:

Definition at line 547 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindTextHide_C

#define Sq3StmtBindTextHide_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindTextHide(__VA_ARGS__)))
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 …

Definition at line 558 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindTextHide_E

#define Sq3StmtBindTextHide_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindTextHide(__VA_ARGS__))

Definition at line 557 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindValue_C

#define Sq3StmtBindValue_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindValue(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindValue(SQ3_STMT sq3stmt, MK_I32 arg1, SQ3_VALN arg2)
Binding Values To Prepared Statements …

Definition at line 560 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindValue_E

#define Sq3StmtBindValue_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindValue(__VA_ARGS__))

Definition at line 559 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindZeroblob64_C

#define Sq3StmtBindZeroblob64_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindZeroblob64(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindZeroblob64(SQ3_STMT sq3stmt, MK_I32 arg1, MK_I64 arg2)
Binding Values To Prepared Statements …

Definition at line 564 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindZeroblob64_E

#define Sq3StmtBindZeroblob64_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindZeroblob64(__VA_ARGS__))

Definition at line 563 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindZeroblob_C

#define Sq3StmtBindZeroblob_C ( ...)
Value:
if (MkErrorCheckI(Sq3StmtBindZeroblob(__VA_ARGS__)))
static enum MkErrorE Sq3StmtBindZeroblob(SQ3_STMT sq3stmt, MK_I32 arg1, MK_I32 n)
Binding Values To Prepared Statements …

Definition at line 562 of file sqlite3_overload_sq3.h.

◆ Sq3StmtBindZeroblob_E

#define Sq3StmtBindZeroblob_E ( ...)
Value:
MkErrorCheck(Sq3StmtBindZeroblob(__VA_ARGS__))

Definition at line 561 of file sqlite3_overload_sq3.h.

Typedef Documentation

◆ Sq3Fupu_Sq3StmtBindBlob64Hide_cb

typedef Sq3Fupu_Sq3StmtBindBlob64Hide_cb_ret(* Sq3Fupu_Sq3StmtBindBlob64Hide_cb) (Sq3Fupu_Sq3StmtBindBlob64Hide_cb_args)

Definition at line 31 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindBlobHide_cb

typedef Sq3Fupu_Sq3StmtBindBlobHide_cb_ret(* Sq3Fupu_Sq3StmtBindBlobHide_cb) (Sq3Fupu_Sq3StmtBindBlobHide_cb_args)

Definition at line 38 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindPointer_arg4

typedef Sq3Fupu_Sq3StmtBindPointer_arg4_ret(* Sq3Fupu_Sq3StmtBindPointer_arg4) (Sq3Fupu_Sq3StmtBindPointer_arg4_args)

Definition at line 45 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindText64Hide_cb

typedef Sq3Fupu_Sq3StmtBindText64Hide_cb_ret(* Sq3Fupu_Sq3StmtBindText64Hide_cb) (Sq3Fupu_Sq3StmtBindText64Hide_cb_args)

Definition at line 52 of file Sq3StmtC_sq3.h.

◆ Sq3Fupu_Sq3StmtBindTextHide_cb

typedef Sq3Fupu_Sq3StmtBindTextHide_cb_ret(* Sq3Fupu_Sq3StmtBindTextHide_cb) (Sq3Fupu_Sq3StmtBindTextHide_cb_args)

Definition at line 59 of file Sq3StmtC_sq3.h.

Function Documentation

◆ Sq3StmtBindBlob64_RT()

static enum MkErrorE Sq3StmtBindBlob64_RT ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkBinaryR blob )
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.

Parameters
[in]mkrtthe MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only)
[in]sq3stmtthe Sq3StmtC instance to work on a statement
[in]posThe index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1.
[in]blobThe MkBinaryR value to be bind.
Exceptions
MkExceptionC→ The default-exception from the Programming-Language-Micro-Kernel (PLMK)

Sq3StmtBindBlob64Hide : documentation

Binding Values To Prepared Statements …

Definition at line 617 of file Sq3StmtC_sq3.h.

622 {
623 SQ3_INSTANCE_RT_X(sq3stmt);
624 MkErrorCheck(Sq3StmtBindBlob64Hide(sq3stmt, pos, blob.data, blob.size, SQLITE_TRANSIENT));
625 MkErrorReturnLabel(sq3stmt);
626}
#define SQ3_INSTANCE_RT_X(x)
#define SQLITE_TRANSIENT
MK_SIZE size
MK_BINN data

◆ Sq3StmtBindBlob64Hide()

static enum MkErrorE Sq3StmtBindBlob64Hide ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_PTRN blob,
MK_I64 len,
Sq3Fupu_Sq3StmtBindBlob64Hide_cb cb )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 73 of file Sq3StmtC_sq3.h.

73 {
74 SQ3_INSTANCE_HDL(sq3stmt);
75 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_blob64(sq3stmt->nat, pos, blob, (MK_U64)len, cb);
76 Sq3ErrorE_Check(sq3stmt, errVal);
77 return MK_OK;
78 error:
79 return MK_ERROR;
80 }
MK_ERROR
MK_OK
unsigned long long MK_U64
Sq3ErrorE
Result Codes.
#define Sq3ErrorE_Check(sq3_hdl, PROC)
check on a pysq3lite error and convert into a pysq3lite error …
#define SQ3_INSTANCE_HDL(x)
SQLITE_API int sqlite3_bind_blob64(sqlite3_stmt *, int, const void *, sqlite3_uint64, void(*)(void *))
sqlite3_stmt * nat
internal - link between Sq3StmtS and native library
+ Here is the caller graph for this function:

◆ Sq3StmtBindBlob64HideP()

enum MkErrorE Sq3StmtBindBlob64HideP ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_PTRN blob,
MK_I64 len,
Sq3Fupu_Sq3StmtBindBlob64Hide_cb cb )

Non-inline replacement for Sq3StmtBindBlob64Hide

◆ Sq3StmtBindBlob64P()

enum MkErrorE Sq3StmtBindBlob64P ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkBinaryR blob )

Non-inline replacement for Sq3StmtBindBlob64

◆ Sq3StmtBindBlob_RT()

static enum MkErrorE Sq3StmtBindBlob_RT ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkBinaryR blob )
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.

Parameters
[in]mkrtthe MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only)
[in]sq3stmtthe Sq3StmtC instance to work on a statement
[in]posThe index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1.
[in]blobThe MkBinaryR value to be bind.
Exceptions
MkExceptionC→ The default-exception from the Programming-Language-Micro-Kernel (PLMK)

Sq3StmtBindBlobHide : documentation

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:
  • ?
  • ?NNN
  • :VVV
  • @amp;VVV
  • $VVV
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.
Reference code from sqlite3:
SQLITE_API int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*));
void(*)(void*));
SQLITE_API int sqlite3_bind_text(sqlite3_stmt*,int,const char*,int,void(*)(void*));
SQLITE_API int sqlite3_bind_text16(sqlite3_stmt*, int, const void*, int, void(*)(void*));
void(*)(void*), unsigned char encoding);
SQLITE_API int sqlite3_bind_pointer(sqlite3_stmt*, int, void*, const char*,void(*)(void*));
SQLITE_API int sqlite3_bind_pointer(sqlite3_stmt *, int, void *, const char *, void(*)(void *))
sqlite_int64 sqlite3_int64
#define SQLITE_API
sqlite_uint64 sqlite3_uint64
SQLITE_API int sqlite3_bind_null(sqlite3_stmt *, int)
SQLITE_API int sqlite3_bind_zeroblob64(sqlite3_stmt *, int, sqlite3_uint64)
SQLITE_API int sqlite3_bind_blob(sqlite3_stmt *, int, const void *, int n, void(*)(void *))
SQLITE_API int sqlite3_bind_text16(sqlite3_stmt *, int, const void *, int, void(*)(void *))
SQLITE_API int sqlite3_bind_text(sqlite3_stmt *, int, const char *, int, void(*)(void *))
SQLITE_API int sqlite3_bind_double(sqlite3_stmt *, int, double)
SQLITE_API int sqlite3_bind_value(sqlite3_stmt *, int, const sqlite3_value *)
SQLITE_API int sqlite3_bind_text64(sqlite3_stmt *, int, const char *, sqlite3_uint64, void(*)(void *), unsigned char encoding)
SQLITE_API int sqlite3_bind_int(sqlite3_stmt *, int, int)
struct sqlite3_value sqlite3_value
struct sqlite3_stmt sqlite3_stmt
SQLITE_API int sqlite3_bind_int64(sqlite3_stmt *, int, sqlite3_int64)
SQLITE_API int sqlite3_bind_zeroblob(sqlite3_stmt *, int, int n)

Definition at line 642 of file Sq3StmtC_sq3.h.

647 {
648 SQ3_INSTANCE_RT_X(sq3stmt);
649 MkErrorCheck(Sq3StmtBindBlobHide(sq3stmt, pos, blob.data, (MK_I32) blob.size, SQLITE_TRANSIENT));
650 MkErrorReturnLabel(sq3stmt);
651}
signed int MK_I32

◆ Sq3StmtBindBlobHide()

static enum MkErrorE Sq3StmtBindBlobHide ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_PTRN blob,
MK_I32 len,
Sq3Fupu_Sq3StmtBindBlobHide_cb cb )
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:

  • ?
  • ?NNN
  • :VVV
  • @amp;VVV
  • $VVV

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:

SQLITE_API int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*));
void(*)(void*));
SQLITE_API int sqlite3_bind_text(sqlite3_stmt*,int,const char*,int,void(*)(void*));
SQLITE_API int sqlite3_bind_text16(sqlite3_stmt*, int, const void*, int, void(*)(void*));
void(*)(void*), unsigned char encoding);
SQLITE_API int sqlite3_bind_pointer(sqlite3_stmt*, int, void*, const char*,void(*)(void*));

Definition at line 83 of file Sq3StmtC_sq3.h.

83 {
84 SQ3_INSTANCE_HDL(sq3stmt);
85 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_blob(sq3stmt->nat, pos, blob, len, cb);
86 Sq3ErrorE_Check(sq3stmt, errVal);
87 return MK_OK;
88 error:
89 return MK_ERROR;
90 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindBlobHideP()

enum MkErrorE Sq3StmtBindBlobHideP ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_PTRN blob,
MK_I32 len,
Sq3Fupu_Sq3StmtBindBlobHide_cb cb )

Non-inline replacement for Sq3StmtBindBlobHide

◆ Sq3StmtBindBlobP()

enum MkErrorE Sq3StmtBindBlobP ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkBinaryR blob )

Non-inline replacement for Sq3StmtBindBlob

◆ Sq3StmtBindDouble()

static enum MkErrorE Sq3StmtBindDouble ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_DBL arg2 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 93 of file Sq3StmtC_sq3.h.

93 {
94 SQ3_INSTANCE_HDL(sq3stmt);
95 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_double(sq3stmt->nat, arg1, arg2);
96 Sq3ErrorE_Check(sq3stmt, errVal);
97 return MK_OK;
98 error:
99 return MK_ERROR;
100 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindDoubleP()

enum MkErrorE Sq3StmtBindDoubleP ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_DBL arg2 )

Non-inline replacement for Sq3StmtBindDouble

◆ Sq3StmtBindInt()

static enum MkErrorE Sq3StmtBindInt ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I32 arg2 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 103 of file Sq3StmtC_sq3.h.

103 {
104 SQ3_INSTANCE_HDL(sq3stmt);
105 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_int(sq3stmt->nat, arg1, arg2);
106 Sq3ErrorE_Check(sq3stmt, errVal);
107 return MK_OK;
108 error:
109 return MK_ERROR;
110 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindInt64()

static enum MkErrorE Sq3StmtBindInt64 ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I64 arg2 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 113 of file Sq3StmtC_sq3.h.

113 {
114 SQ3_INSTANCE_HDL(sq3stmt);
115 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_int64(sq3stmt->nat, arg1, arg2);
116 Sq3ErrorE_Check(sq3stmt, errVal);
117 return MK_OK;
118 error:
119 return MK_ERROR;
120 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindInt64P()

enum MkErrorE Sq3StmtBindInt64P ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I64 arg2 )

Non-inline replacement for Sq3StmtBindInt64

◆ Sq3StmtBindIntP()

enum MkErrorE Sq3StmtBindIntP ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I32 arg2 )

Non-inline replacement for Sq3StmtBindInt

◆ Sq3StmtBindNull()

static enum MkErrorE Sq3StmtBindNull ( SQ3_STMT sq3stmt,
MK_I32 arg1 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 123 of file Sq3StmtC_sq3.h.

123 {
124 SQ3_INSTANCE_HDL(sq3stmt);
125 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_null(sq3stmt->nat, arg1);
126 Sq3ErrorE_Check(sq3stmt, errVal);
127 return MK_OK;
128 error:
129 return MK_ERROR;
130 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindNullP()

enum MkErrorE Sq3StmtBindNullP ( SQ3_STMT sq3stmt,
MK_I32 arg1 )

Non-inline replacement for Sq3StmtBindNull

◆ Sq3StmtBindParameterCount()

static enum MkErrorE Sq3StmtBindParameterCount ( SQ3_STMT sq3stmt)
inlinestatic

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:

SQLITE_API int sqlite3_bind_parameter_count(sqlite3_stmt *)

Definition at line 133 of file Sq3StmtC_sq3.h.

133 {
134 SQ3_INSTANCE_HDL(sq3stmt);
135 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_parameter_count(sq3stmt->nat);
136 Sq3ErrorE_Check(sq3stmt, errVal);
137 return MK_OK;
138 error:
139 return MK_ERROR;
140 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindParameterCountP()

enum MkErrorE Sq3StmtBindParameterCountP ( SQ3_STMT sq3stmt)

Non-inline replacement for Sq3StmtBindParameterCount

◆ Sq3StmtBindParameterIndex()

static enum MkErrorE Sq3StmtBindParameterIndex ( SQ3_STMT sq3stmt,
MK_STRN zName )
inlinestatic

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:

SQLITE_API int sqlite3_bind_parameter_index(sqlite3_stmt *, const char *zName)

Definition at line 143 of file Sq3StmtC_sq3.h.

143 {
144 SQ3_INSTANCE_HDL(sq3stmt);
145 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_parameter_index(sq3stmt->nat, zName);
146 Sq3ErrorE_Check(sq3stmt, errVal);
147 return MK_OK;
148 error:
149 return MK_ERROR;
150 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindParameterIndexP()

enum MkErrorE Sq3StmtBindParameterIndexP ( SQ3_STMT sq3stmt,
MK_STRN zName )

Non-inline replacement for Sq3StmtBindParameterIndex

◆ Sq3StmtBindParameterName()

static MK_STRN Sq3StmtBindParameterName ( SQ3_STMT sq3stmt,
MK_I32 arg1 )
inlinestatic

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:

SQLITE_API const char * sqlite3_bind_parameter_name(sqlite3_stmt *, int)

Definition at line 153 of file Sq3StmtC_sq3.h.

153 {
154 SQ3_INSTANCE_HDL(sq3stmt);
155 MK_STRN __retVal__L = sqlite3_bind_parameter_name(sq3stmt->nat, arg1);
156 return __retVal__L;
157 }
const MK_STRB * MK_STRN
+ Here is the caller graph for this function:

◆ Sq3StmtBindParameterNameP()

MK_STRN Sq3StmtBindParameterNameP ( SQ3_STMT sq3stmt,
MK_I32 arg1 )

Non-inline replacement for Sq3StmtBindParameterName

◆ Sq3StmtBindPointer()

static enum MkErrorE Sq3StmtBindPointer ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_PTR arg2,
MK_STRN arg3,
Sq3Fupu_Sq3StmtBindPointer_arg4 arg4 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 160 of file Sq3StmtC_sq3.h.

160 {
161 SQ3_INSTANCE_HDL(sq3stmt);
162 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_pointer(sq3stmt->nat, arg1, (MK_PTR)(arg2), arg3, arg4);
163 Sq3ErrorE_Check(sq3stmt, errVal);
164 return MK_OK;
165 error:
166 return MK_ERROR;
167 }
MK_PTRB * MK_PTR

◆ Sq3StmtBindPointerP()

enum MkErrorE Sq3StmtBindPointerP ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_PTR arg2,
MK_STRN arg3,
Sq3Fupu_Sq3StmtBindPointer_arg4 arg4 )

Non-inline replacement for Sq3StmtBindPointer

◆ Sq3StmtBindText64_RT()

static enum MkErrorE Sq3StmtBindText64_RT ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkStringR text,
enum Sq3TextE encoding )
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.

Parameters
[in]mkrtthe MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only)
[in]sq3stmtthe Sq3StmtC instance to work on a statement
[in]posThe index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1.
[in]textThe MkStringR value to be bind.
[in]encodingThe encoding of the text using one of the Sq3TextE values.
Exceptions
MkExceptionC→ The default-exception from the Programming-Language-Micro-Kernel (PLMK)

Sq3StmtBindText64Hide : documentation

Binding Values To Prepared Statements …

Definition at line 565 of file Sq3StmtC_sq3.h.

571 {
572 SQ3_INSTANCE_RT_X(sq3stmt);
573 MkErrorCheck(Sq3StmtBindText64Hide(sq3stmt, pos, text.ptr, text.len, SQLITE_TRANSIENT, encoding));
574 MkErrorReturnLabel(sq3stmt);
575}
MK_STRN ptr
MK_NUM len

◆ Sq3StmtBindText64Hide()

static enum MkErrorE Sq3StmtBindText64Hide ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_STRN text,
MK_I64 len,
Sq3Fupu_Sq3StmtBindText64Hide_cb cb,
enum Sq3TextE encoding )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 170 of file Sq3StmtC_sq3.h.

170 {
171 SQ3_INSTANCE_HDL(sq3stmt);
172 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_text64(sq3stmt->nat, pos, text, (MK_U64)len, cb, encoding);
173 Sq3ErrorE_Check(sq3stmt, errVal);
174 return MK_OK;
175 error:
176 return MK_ERROR;
177 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindText64HideP()

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

◆ Sq3StmtBindText64P()

enum MkErrorE Sq3StmtBindText64P ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkStringR text,
enum Sq3TextE encoding )

Non-inline replacement for Sq3StmtBindText64

◆ Sq3StmtBindText_RT()

static enum MkErrorE Sq3StmtBindText_RT ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkStringR text )
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.

Parameters
[in]mkrtthe MkRuntimeS instance to work on - the runtime argument, used by MK_RT_CALL (C-only)
[in]sq3stmtthe Sq3StmtC instance to work on a statement
[in]posThe index of the SQL parameter to be set, the leftmost SQL parameter has an index of 1.
[in]textThe MkStringR value to be bind.
Exceptions
MkExceptionC→ The default-exception from the Programming-Language-Micro-Kernel (PLMK)

Sq3StmtBindText64Hide : documentation

Binding Values To Prepared Statements …

Definition at line 591 of file Sq3StmtC_sq3.h.

596 {
597 SQ3_INSTANCE_RT_X(sq3stmt);
598 MkErrorCheck(Sq3StmtBindTextHide(sq3stmt, pos, text.ptr, text.len, SQLITE_TRANSIENT));
599 MkErrorReturnLabel(sq3stmt);
600}

◆ Sq3StmtBindTextHide()

static enum MkErrorE Sq3StmtBindTextHide ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_STRN text,
MK_I32 len,
Sq3Fupu_Sq3StmtBindTextHide_cb cb )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 180 of file Sq3StmtC_sq3.h.

180 {
181 SQ3_INSTANCE_HDL(sq3stmt);
182 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_text(sq3stmt->nat, pos, text, len, cb);
183 Sq3ErrorE_Check(sq3stmt, errVal);
184 return MK_OK;
185 error:
186 return MK_ERROR;
187 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindTextHideP()

enum MkErrorE Sq3StmtBindTextHideP ( SQ3_STMT sq3stmt,
MK_I32 pos,
MK_STRN text,
MK_I32 len,
Sq3Fupu_Sq3StmtBindTextHide_cb cb )

Non-inline replacement for Sq3StmtBindTextHide

◆ Sq3StmtBindTextP()

enum MkErrorE Sq3StmtBindTextP ( MK_RT mkrt,
SQ3_STMT sq3stmt,
MK_I32 pos,
MkStringR text )

Non-inline replacement for Sq3StmtBindText

◆ Sq3StmtBindValue()

static enum MkErrorE Sq3StmtBindValue ( SQ3_STMT sq3stmt,
MK_I32 arg1,
SQ3_VALN arg2 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 190 of file Sq3StmtC_sq3.h.

190 {
191 SQ3_INSTANCE_HDL(sq3stmt);
192 const struct sqlite3_value * arg2_hdl = arg2->nat;
193 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_value(sq3stmt->nat, arg1, arg2_hdl);
194 Sq3ErrorE_Check(sq3stmt, errVal);
195 return MK_OK;
196 error:
197 return MK_ERROR;
198 }
sqlite3_value * nat
internal - link between Sq3ValueS and native library
+ Here is the caller graph for this function:

◆ Sq3StmtBindValueP()

enum MkErrorE Sq3StmtBindValueP ( SQ3_STMT sq3stmt,
MK_I32 arg1,
SQ3_VALN arg2 )

Non-inline replacement for Sq3StmtBindValue

◆ Sq3StmtBindZeroblob()

static enum MkErrorE Sq3StmtBindZeroblob ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I32 n )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 201 of file Sq3StmtC_sq3.h.

201 {
202 SQ3_INSTANCE_HDL(sq3stmt);
203 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_zeroblob(sq3stmt->nat, arg1, n);
204 Sq3ErrorE_Check(sq3stmt, errVal);
205 return MK_OK;
206 error:
207 return MK_ERROR;
208 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindZeroblob64()

static enum MkErrorE Sq3StmtBindZeroblob64 ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I64 arg2 )
inlinestatic

Binding Values To Prepared Statements …

read more at 'Sq3StmtBindBlob'

Definition at line 211 of file Sq3StmtC_sq3.h.

211 {
212 SQ3_INSTANCE_HDL(sq3stmt);
213 enum Sq3ErrorE errVal = (enum Sq3ErrorE)sqlite3_bind_zeroblob64(sq3stmt->nat, arg1, (MK_U64)arg2);
214 Sq3ErrorE_Check(sq3stmt, errVal);
215 return MK_OK;
216 error:
217 return MK_ERROR;
218 }
+ Here is the caller graph for this function:

◆ Sq3StmtBindZeroblob64P()

enum MkErrorE Sq3StmtBindZeroblob64P ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I64 arg2 )

Non-inline replacement for Sq3StmtBindZeroblob64

◆ Sq3StmtBindZeroblobP()

enum MkErrorE Sq3StmtBindZeroblobP ( SQ3_STMT sq3stmt,
MK_I32 arg1,
MK_I32 n )

Non-inline replacement for Sq3StmtBindZeroblob