sqlite_prepare () to set the ppStmt
"The sqlite3_bind_*() routines must be called after
(and its variants) or and
before .
"
sqlite3_bind* set the value of param
sqlite_step() to
"After a has been prepared using either
or or one of the legacy
interfaces or , this function
must be called one or more times to evaluate the statement."
The sqlite3_reset() function is called to reset a
object back to its initial state, ready to be re-executed.
Any SQL statement variables that had values bound to them using
the retain their values.
Use to reset the bindings.
The interface resets the S
back to the beginning of its program.
int sqlite3_finalize(sqlite3_stmt *pStmt);
The life of a statement object goes something like this:
- Create the object using or a related
function.
- Bind values to using the sqlite3_bind_*()
interfaces.
- Run the SQL by calling one or more times.
- Reset the statement using then go back
to step 2. Do this zero or more times.
- Destroy the object using .
阅读(468) | 评论(0) | 转发(0) |
