theSq3Lite 10.0 NHI1 - theKernel - theLink - theConfig - theSq3Lite - theCompiler - theBrain - theGuard - theLib - theATL
c - tcl - atl - cs - py - rb - jv - cc
Loading...
Searching...
No Matches
Sq3StmtS Struct Reference

Struct to represent the data of the Sq3StmtCMore...

#include <Sq3StmtC_def_sq3.h>

+ Collaboration diagram for Sq3StmtS:

Public Attributes

union { 
 
   struct MkObjectS   obj 
 
super 
 
sqlite3_stmtnat
 internal - link between Sq3StmtS and native library
 
MK_STRN pzTail
 The non compiled sql-statement from Sq3StmtPrepareV2 and Sq3StmtPrepareV3
 

Detailed Description

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;
struct sqlite3_stmt sqlite3_stmt

Definition at line 39 of file Sq3StmtC_def_sq3.h.

Member Data Documentation

◆ nat

sqlite3_stmt* Sq3StmtS::nat

internal - link between Sq3StmtS and native library

Definition at line 50 of file Sq3StmtC_def_sq3.h.

◆ obj

struct MkObjectS Sq3StmtS::obj

Definition at line 43 of file Sq3StmtC_def_sq3.h.

◆ pzTail

MK_STRN Sq3StmtS::pzTail

The non compiled sql-statement from Sq3StmtPrepareV2 and Sq3StmtPrepareV3

Use Sq3StmtGetPzTail to get the string or MK_NULL_STR.

Note
only usefull after the Sq3StmtPrepareV2 or the Sq3StmtPrepareV3 command.

Definition at line 58 of file Sq3StmtC_def_sq3.h.

◆ [union]

union { ... } Sq3StmtS::super

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