cssq3lite.Sq3StmtC Class Reference

Sq3StmtC - the class known as sq3stmt or Statement defined by Sq3StmtS … More...

Inheritance diagram for cssq3lite.Sq3StmtC:

Collaboration diagram for cssq3lite.Sq3StmtC:

Public Member Functions
void	BindBlob (int pos, byte[] blob)
	C#: sq3stmt.BindBlob(int pos, byte[] blob) → C-API Bind a MkBinaryR Value To a Prepared Statement …
void	BindDouble (int arg1, double arg2)
	C#: sq3stmt.BindDouble(int arg1, double arg2) → C-API Binding Values To Prepared Statements …
void	BindInt (int arg1, int arg2)
	C#: sq3stmt.BindInt(int arg1, int arg2) → C-API Binding Values To Prepared Statements …
void	BindInt64 (int arg1, long arg2)
	C#: sq3stmt.BindInt64(int arg1, long arg2) → C-API Binding Values To Prepared Statements …
void	BindNull (int arg1)
	C#: sq3stmt.BindNull(int arg1) → C-API Binding Values To Prepared Statements …
void	BindParameterCount ()
	C#: sq3stmt.BindParameterCount() → C-API Number Of SQL Parameters …
void	BindParameterIndex (string zName)
	C#: sq3stmt.BindParameterIndex(string zName) → C-API Index Of A Parameter With A Given Name …
string	BindParameterName (int arg1)
	C#: string sq3stmt.BindParameterName(int arg1) → C-API Name Of A Host Parameter …
void	BindText (int pos, string text)
	C#: sq3stmt.BindText(int pos, string text) → C-API Bind a MkStringR Value To a Prepared Statement …
void	BindValue (int arg1, Sq3ValueC arg2)
	C#: sq3stmt.BindValue(int arg1, Sq3ValueC arg2) → C-API Binding Values To Prepared Statements …
void	BindZeroblob (int arg1, int n)
	C#: sq3stmt.BindZeroblob(int arg1, int n) → C-API Binding Values To Prepared Statements …
void	BindZeroblob64 (int arg1, long arg2)
	C#: sq3stmt.BindZeroblob64(int arg1, long arg2) → C-API Binding Values To Prepared Statements …
new Sq3StmtC	Next ()
	C#: Sq3StmtC stmt.Next() → C-API get next instance from linked-list of Sq3StmtS type
new Sq3StmtC	Prev ()
	C#: Sq3StmtC stmt.Prev() → C-API get previous instance from linked-list of Sq3StmtS type
Sq3ValueC	ColumnValue (int iCol)
	C#: Sq3ValueC sq3stmt.ColumnValue(int iCol) → C-API Result Values From A Query …
byte[]	ColumnBlob (int iCol)
	C#: byte[] sq3stmt.ColumnBlob(int iCol) → C-API Result a MkBinaryR Value From A Query.
int	ColumnBytes (int iCol)
	C#: int sq3stmt.ColumnBytes(int iCol) → C-API Result Values From A Query …
int	ColumnCount ()
	C#: int pStmt.ColumnCount() → C-API Number Of Columns In A Result Set …
double	ColumnDouble (int iCol)
	C#: double sq3stmt.ColumnDouble(int iCol) → C-API Result Values From A Query …
int	ColumnInt (int iCol)
	C#: int sq3stmt.ColumnInt(int iCol) → C-API Result Values From A Query …
long	ColumnInt64 (int iCol)
	C#: long sq3stmt.ColumnInt64(int iCol) → C-API Result Values From A Query …
string	ColumnName (int N)
	C#: string sq3stmt.ColumnName(int N) → C-API Column Names In A Result Set …
string	ColumnText (int iCol)
	C#: string sq3stmt.ColumnText(int iCol) → C-API Result a MkStringR Value From A Query.
Sq3TypeE	ColumnType (int iCol)
	C#: Sq3TypeE sq3stmt.ColumnType(int iCol) → C-API Result Values From A Query …
Sq3LiteC	DbHandle ()
	C#: Sq3LiteC sq3stmt.DbHandle() → C-API Find The Database Handle Of A Prepared Statement …
void	Busy ()
	C#: sq3stmt.Busy() → C-API Determine If A Prepared Statement Has Been Reset …
void	DataCount ()
	C#: pStmt.DataCount() → C-API Number of columns in a result set …
void	IsExplain ()
	C#: pStmt.IsExplain() → C-API Query The EXPLAIN Setting For A Prepared Statement …
void	Readonly ()
	C#: pStmt.Readonly() → C-API Determine If An SQL Statement Writes The Database …
void	Status (Sq3StmtStatusE op, bool resetFlg)
	C#: sq3stmt.Status(Sq3StmtStatusE op, bool resetFlg) → C-API Prepared Statement Status …
void	ClearBindings ()
	C#: sq3stmt.ClearBindings() → C-API Reset All Bindings On A Prepared Statement …
void	Explain (int eMode)
	C#: pStmt.Explain(int eMode) → C-API Change The EXPLAIN Setting For A Prepared Statement …
void	Reset ()
	C#: pStmt.Reset() → C-API Reset A Prepared Statement Object …
Sq3ErrorE	Step ()
	C#: Sq3ErrorE sq3stmt.Step() → C-API Evaluate An SQL Statement …
string	ExpandedSql ()
	C#: string pStmt.ExpandedSql() → C-API Retrieving Statement SQL …
string	GetPzTail ()
	C#: string sq3stmt.GetPzTail() → C-API return the non compiled sql-statement from Sq3StmtPrepareV2 and Sq3StmtPrepareV3 …
string	Sql ()
	C#: string pStmt.Sql() → C-API Retrieving Statement SQL …
	Sq3StmtC (Sq3LiteC db, string zSql)
	CONSTRUCTOR.
void	Sq3Finalize ()
	C#: [destructor] pStmt.Sq3Finalize() → C-API Destroy A Prepared Statement Object …
Public Member Functions inherited from csmkkernel::MkObjectC
delegate void	MkObjectDeleteSCB (string typeName, int typeHdl, int objHdl)
void	ErrorCheck (MkErrorE err)
bool	Check ()
string	ToNameOfClass ()
void	HandleDelete ()
bool	HandleExists ()
Int32	HandleGet ()
Int32	HandleGetOfType ()
Int32	HandleGetOr0 ()
MkObjectC	Next ()
MkObjectC	Prev ()
void	DbgDump (string message="var",[CallerMemberName]string callfunc=null)
void	DbgL (string message, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0)
void	DbgLogC ([CallerMemberName]string callfunc=null)
void	DbgO ([CallerMemberName]string callfunc=null)
void	DbgSTACK (int skip=0, int num=-1,[CallerMemberName]string callfunc=null)
void	LogC (string message, int debug=0,[CallerMemberName]string callfunc=null)
void	LogHEX (string callfunc, byte[] data)
void	Log (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0)
void	LogLong (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0)
void	LogShort (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0)
void	LogType (MkObjectC fmtobj=null, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0)
MkErrorC	ErrorCatch (Exception exception=null,[CallerMemberName]string callfunc=null)
MkErrorC	ToError ()
bool	IsNull ()
string	ToName ()
string	ToNameOfType ()
override string	ToString ()
int	RefGet ()
void	SysKill (int pid, int signal)
int	SysGetPid ()
void	Dispose ()
void	Delete ()

Static Public Member Functions
static Sq3StmtC	Sq3StmtC_ObjNew (IntPtr hdl)
new static Sq3StmtC	HandleResolve (Int32 netHdl)
	C#: [static] Sq3StmtC Sq3StmtC.HandleResolve(Int32 netHdl) → C-API Handle-Resolve-Slot - return a Sq3StmtC from netHdl or null if invalid…
new static Sq3StmtC	Instances ()
	C#: [static] Sq3StmtC Sq3StmtC.Instances() → C-API get head-instance from linked-list of Sq3StmtS type …
new static Sq3StmtC	GetNull ()
	C#: [static] Sq3StmtC Sq3StmtC.GetNull() → C-API Null-Slot - return a Sq3StmtC typed NULL instance …
static Sq3StmtC	NextStmt (Sq3LiteC pDb, Sq3StmtC pStmt=null)
	C#: [static] Sq3StmtC Sq3StmtC.NextStmt(Sq3LiteC pDb, Sq3StmtC pStmt = null) → C-API Find the next prepared statement …
static Sq3StmtC	PrepareV2 (Sq3LiteC db, string zSql)
	C#: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV2(Sq3LiteC db, string zSql) → C-API Compiling An SQL Statement …
static Sq3StmtC	PrepareV3 (Sq3LiteC db, string zSql, Sq3PrepareEF prepFlags=Sq3PrepareEF.NO)
	C#: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV3(Sq3LiteC db, string zSql, Sq3PrepareEF prepFlags = SQ3_PREPARE_NO) → C-API Compiling An SQL Statement …
Static Public Member Functions inherited from csmkkernel::MkObjectC
static MkObjectC	MkObjectC_ObjNew (IntPtr hdl)
static IntPtr	getOBJ (string cls, MkObjectC obj)
static IntPtr	getOBJ_null_allow (MkObjectC obj)
static MkObjectC	HandleResolve (Int32 netHdl)
static void	HandleDeleteByNetHdl (Int32 netHdl)
static MkObjectC	Instances ()
static MkObjectC	GetNull ()
static void	DbgM (string message, int debug=0,[CallerMemberName]string callfunc=null, int lvl=0)
static int	SysHashI32 (string key, int length=-1)
static string	SysHashSTR (string key, int length=-1)
static void	DeleteCallbackCleanup (string ident)
static void	DeleteCallbackSetup (string ident, MkObjectDeleteSCB callback=null, string filter=null)
static int	getPId ()
static int	getTId ()
static string	getStackTrace (int level=2)
static string	getCallerProc (int level=2)
static int	getCallerLine (int level=2)
static string	getCallerFile (int level=2)

Static Protected Member Functions
static IntPtr	CTOR (Sq3LiteC db, string zSql)
	C#: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV2(Sq3LiteC db, string zSql) → C-API Compiling An SQL Statement …
Static Protected Member Functions inherited from csmkkernel::MkObjectC
static object	atomObjNew (Type type, ConstructorInfo ctor, IntPtr obj)
static object	atomObjCreate (Type type, ConstructorInfo ctor, IntPtr obj)
static IntPtr	atomSelfCreate (ConstructorInfo ctor, IntPtr obj, IntPtr env)
static object	atomSelfNull (ConstructorInfo ctor)
static void	atomSelfUnlink (IntPtr self, IntPtr env)
static ConstructorInfo	getCtor (Type type)
static string	Name (IntPtr mkrt, IntPtr obj)

Additional Inherited Members
Protected Member Functions inherited from csmkkernel::MkObjectC
	MkObjectC (IntPtr obj)
	MkObjectC ()
virtual void	Dispose (bool disposing)
Protected Attributes inherited from csmkkernel::MkObjectC
IntPtr	pmkrt
Properties inherited from csmkkernel::MkObjectC
IntPtr	hdl
IntPtr	hdl_null_allow
IntPtr	mkrt

Detailed Description

Sq3StmtC - the class known as sq3stmt or Statement defined by Sq3StmtS …

Struct to represent the data of the Sq3StmtC …

Prepared Statement Object …

An instance of this object represents a single SQL statement that has been compiled into binary form and is ready to be evaluated.

Think of each SQL statement as a separate computer program. The original SQL text is source code. A prepared statement object is the compiled object code. All SQL must be converted into a prepared statement before it can be run.

The life-cycle of a prepared statement object usually goes like this:

1. Create the prepared statement object using Sq3StmtPrepareV2 ().
2. Bind values to parameters using the Sq3StmtBindValue*() interfaces.
3. Run the SQL by calling Sq3StmtStep () one or more times.
4. Reset the prepared statement using Sq3StmtReset () then go back to step 2. Do this zero or more times.
5. Destroy the object using Sq3StmtFinalize ().

Reference code from sqlite3:

typedef struct sqlite3_stmt sqlite3_stmt;

Definition at line 451 of file Sq3StmtC_cs.cs.

Member Function Documentation

Sq3StmtC_ObjNew()

static Sq3StmtC cssq3lite.Sq3StmtC.Sq3StmtC_ObjNew ( IntPtr hdl )

inlinestatic

Definition at line 38 of file Sq3StmtC_cs.cs.

                                                        {
      return hdl != IntPtr.Zero ? (Sq3StmtC) atomObjNew(typeof(Sq3StmtC), ctor, hdl) : MK_NULL.Value;
    }

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• Sq3StmtC_cs.cs