SqlLiteCommand Class Reference
[SQLITE]
A parameterized sqlite query. More...
#include <SqlLiteCommand.h>
Inheritance diagram for SqlLiteCommand:
Public Member Functions | |
| SqlLiteCommand (const SqlLiteCommand &cmd) | |
| SqlLiteCommand (void *db, const String &cmdtxt) | |
| SqlLiteCommand & | operator= (const SqlLiteCommand &cmd) |
| virtual void | Clear () |
| virtual void | Prepare () |
| virtual int | ExecuteNonQuery () |
| virtual RecordSetPtr | ExecuteQuery () |
Protected Member Functions | |
| void | BindParameters () |
Protected Attributes | |
| void * | m_db |
| void * | m_stmt |
Detailed Description
A parameterized sqlite query.
In your SQL string, prepend '@' to the parameter names and use the same fully qualified name in the command parameter.
CommandPtr cmd = con.CreateParameter("SELECT * FROM data WHERE FIELD1 = @param1;");
cmd->CreateParameter("@param1", DbSqlType::SQL_TYPE_INT32, ParameterDirection::PARAM_DIR_IN, 4)->Set(1);
The parameter direction is ignored in SQLite, since only IN parameters are supported.
Definition at line 42 of file SqlLiteCommand.h.
The documentation for this class was generated from the following files:
- spl/data/SqlLiteCommand.h
- src/data/SqlLiteCommand.cpp