SqlLiteCommand Class Reference

A parameterized sqlite query. More...

#include <SqlLiteCommand.h>

Inheritance diagram for SqlLiteCommand:
Command IMemoryValidate

List of all members.

Public Member Functions

 SqlLiteCommand (const SqlLiteCommand &cmd)
 SqlLiteCommand (void *db, const String &cmdtxt)
SqlLiteCommandoperator= (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: