ParaInfoCenter::CSQLStatement Class Reference

this represents SQL statement or stored procedure. More...

#include <SQLStatement.h>

Inheritance diagram for ParaInfoCenter::CSQLStatement:

Public Member Functions
int	Execute ()
int	Reset ()
int	DataBinding (int index, double value)
int	DataBinding (const char *name, double value)
int	DataBinding (int index, int value)
int	DataBinding (const char *name, int value)
int	DataBinding (int index, int64 value)
int	DataBinding (const char *name, int64 value)
int	DataBindingNull (int index)
int	DataBindingNull (const char *name)
int	DataBinding (int index, const char *value)
int	DataBinding (const char *name, const char *value)
int	DataBinding (int index, const WCHAR *value)
int	DataBinding (const char *name, const WCHAR *value)
int	DataBinding (int index, const void *value, int size)
int	DataBinding (const char *name, const void *value, int size)
bool	IsEOF ()
	The recordset is IsEOF()==true when. More...
bool	IsBOF ()
	The recordset is IsBOF()==true before the first NextRow() is called; in other words, no DataBinding should occur if it is BOF is true. More...
bool	IsValid ()
	The recordset is invalid when: More...

Protected Attributes
sqlite3_stmt *	m_stmt
sqlite3 *	m_db
bool	m_isValid
bool	m_eof
bool	m_bof

Friends
class	DBEntity
	database entity

Detailed Description

this represents SQL statement or stored procedure.

Member Function Documentation

IsBOF()

bool ParaInfoCenter::CSQLStatement::IsBOF ( )

inline

The recordset is IsBOF()==true before the first NextRow() is called; in other words, no DataBinding should occur if it is BOF is true.

Returns

IsEOF()

bool ParaInfoCenter::CSQLStatement::IsEOF ( )

inline

The recordset is IsEOF()==true when.

• it is invalid, in most cases, but I don't guarantee that, because these two flags are not binding together.
• the sql string returns nothing
• after calling NextRow() when the current row is the last row

Returns

IsValid()

bool ParaInfoCenter::CSQLStatement::IsValid ( )

inline

The recordset is invalid when:

• it was created without any sql string
• the sql string is incorrect
• the sqlite statement is finalized.
• some other errors.

  Returns

---

The documentation for this class was generated from the following files:

• Client/trunk/ParaEngineClient/ic/SQLStatement.h
• Client/trunk/ParaEngineClient/ic/SQLStatement.cpp