Sq3StmtC_C_API

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

Collaboration diagram for Sq3StmtC_C_API:

Topics
	Sq3StmtC_Class_C_API
	Sq3StmtC - define the class …
	Sq3StmtC_TOR_C_API
	Sq3StmtC - various functions to create, initialize and destroy …
	Sq3StmtC_Bind_C_API
	Sq3StmtC - bind a type …
	Sq3StmtC_Column_C_API
	Sq3StmtC - Result Values From A Query …
	Sq3StmtC_Info_C_API
	Sq3StmtC - get type-information …
	Sq3StmtC_Sql_C_API
	Sq3StmtC - Retrieving Statement SQL …
	Sq3StmtC_Misc_C_API
	Sq3StmtC - various functions to perform misc operations …

Classes
struct	Sq3StmtS
	Struct to represent the data of the Sq3StmtC … More...

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;