Small, Fast, Reliable.
Choose any three.

SQLite C Interface

SQL Statement Object

typedef struct sqlite3_stmt sqlite3_stmt;

Instance of this object represent single SQL statements. This is variously known as a "prepared statement" or a "compiled SQL statement" or simply as a "statement".

The life of a statement object goes something like this:

  1. Create the object using sqlite3_prepare_v2() or a related function.
  2. Bind values to host parameters using sqlite3_bind_* interfaces.
  3. Run the SQL by calling sqlite3_step() one or more times.
  4. Reset the statement using sqlite3_reset() then go back to step 2. Do this zero or more times.
  5. Destroy the object using sqlite3_finalize().

Refer to documentation on individual methods above for additional information.

See also lists of Objects, Constants, and Functions.


This page last modified 2007/11/22 00:41:31 UTC