Main Page   Class Hierarchy   Compound List   File List   Compound Members   File Members  

CTBodbcStatement Class Reference

DB statement. **. More...

#include "CTBodbcStatement.hxx"

Collaboration diagram for CTBodbcStatement:

Collaboration graph
[legend]
List of all members.

Public Types

enum  {
  format_bsv = 0, format_bsvh, format_tsv, format_tsvh,
  format_csv, format_csvh, format_lvp, format_lvph
}

Public Methods

 CTBodbcStatement (CTBodbcConnect &dbc)
 ~CTBodbcStatement ()
bool Prepare (const char *c_stmt)
bool Execute ()
bool Fetch ()
bool Close ()
bool UnbindParameter ()
bool UnbindCol ()
bool NumResultCols (int &i_ncol)
bool DescribeCol (int i_icol, char *c_colname, int i_size, SWORD &i_sqltype, int &i_precision, int &i_scale, bool &b_nullable)
bool FetchToStream (ostream &os, int i_format=format_bsv, int i_maxrow=0)
bool GetData (int i_icol, SWORD i_ctype, void *p_value, int i_size, bool &b_null)
bool GetData (int i_icol, char *c_value, int i_size, bool &b_null)
bool GetData (int i_icol, CTBint32 &i_value, bool &b_null)
bool GetData (int i_icol, float &f_value, bool &b_null)
bool GetData (int i_icol, double &d_value, bool &b_null)
bool GetData (int i_icol, CTBodbcTime &time, bool &b_null)
bool BindIParameter (int i_ipar, SWORD i_ctype, SWORD i_sqltype, void *p_value)
bool BindIParameter (int i_ipar, SWORD i_sqltype, const char *c_pvalue)
bool BindIParameter (int i_ipar, SWORD i_sqltype, CTBint32 &i_pvalue)
bool BindIParameter (int i_ipar, SWORD i_sqltype, float &f_pvalue)
bool BindIParameter (int i_ipar, SWORD i_sqltype, double &d_pvalue)
bool BindIParameter (int i_ipar, SWORD i_sqltype, CTBodbcTime &pvalue)
bool BindCol (int i_icol, SWORD i_ctype, void *p_value, int i_size, CTBint32 &pi_rsize)
bool BindCol (int i_icol, char *c_cvalue, int i_size, CTBint32 &i_rsize)
bool BindCol (int i_icol, CTBint32 &i_cvalue, CTBint32 &i_rsize)
bool BindCol (int i_icol, float &f_cvalue, CTBint32 &i_rsize)
bool BindCol (int i_icol, double &d_cvalue, CTBint32 &i_rsize)
bool BindCol (int i_icol, CTBodbcTime &cvalue, CTBint32 &i_rsize)
void PrintError (ostream &os=cout)

Private Methods

bool AllocIfNull ()

Private Attributes

CTBodbcConnect & m_dbc
HSTMT m_hstmt

Detailed Description

DB statement. **.

Definition at line 16 of file CTBodbcStatement.hxx.

Member Enumeration Documentation

anonymous enum
 

Enumeration values:
format_bsv   blank separated values.
format_bsvh   blank separated values w/ head.
format_tsv   tab separated values.
format_tsvh   tab separated values w/ head.
format_csv   comma separated values.
format_csvh   comma separated values w/ head.
format_lvp   label value pairs.
format_lvph   label value pairs w/ head.

Definition at line 20 of file CTBodbcStatement.hxx.

Constructor & Destructor Documentation

CTBodbcStatement::CTBodbcStatement (  CTBodbcConnect & dbc ) 
 

Contruct bound to connection.

Definition at line 28 of file CTBodbcStatement.cxx.

CTBodbcStatement::~CTBodbcStatement (  ) 
 

Destructor.

Definition at line 37 of file CTBodbcStatement.cxx.

Member Function Documentation

bool CTBodbcStatement::Prepare (  const char * c_stmt ) 
 

Prepare statement.

Definition at line 50 of file CTBodbcStatement.cxx.

bool CTBodbcStatement::Execute (  ) 
 

Execute prepared statement.

Definition at line 70 of file CTBodbcStatement.cxx.

bool CTBodbcStatement::Fetch (  ) 
 

Fetch next row.

Definition at line 90 of file CTBodbcStatement.cxx.

Referenced by FetchToStream().

bool CTBodbcStatement::Close (  ) 
 

Close cursor.

Definition at line 110 of file CTBodbcStatement.cxx.

Referenced by FetchToStream().

bool CTBodbcStatement::UnbindParameter (  ) 
 

Unbind parameters.

Definition at line 130 of file CTBodbcStatement.cxx.

bool CTBodbcStatement::UnbindCol (  ) 
 

Unbind columns.

Definition at line 150 of file CTBodbcStatement.cxx.

bool CTBodbcStatement::NumResultCols (  int & i_ncol ) 
 

Get number of result set columns.

Definition at line 170 of file CTBodbcStatement.cxx.

Referenced by FetchToStream().

bool CTBodbcStatement::DescribeCol (  int i_icol,
char * c_colname,
int i_size,
SWORD & i_sqltype,
int & i_precision,
int & i_scale,
bool & b_nullable
) 
 

Get attributes of result column.

  • i_icol - column index (from 1)
  • c_colname - column name
  • i_size - size if column name buffer
  • i_sqltype - SQL data type
  • i_precision - precision
  • i_scale - scale factor
  • b_nullable - column can contain NULL

Definition at line 202 of file CTBodbcStatement.cxx.

Referenced by FetchToStream().

bool CTBodbcStatement::FetchToStream (  ostream & os,
int i_format = format_bsv,
int i_maxrow = 0
) 
 

Fetch and output to stream.

Fetches at most i_maxrow rows and writes the result to stream os using the format given by i_format. An unlimited number of rows is fetched when i_maxrow is 0.

Definition at line 245 of file CTBodbcStatement.cxx.

bool CTBodbcStatement::GetData (  int i_icol,
SWORD i_ctype,
void * p_value,
int i_size,
bool & b_null
) 
 

Get an unbound column (generic).

  • i_icol - column index (1...)
  • i_ctype - C type
  • p_value - pointer to value
  • i_size - size of value
  • b_null - NULL flag

Definition at line 510 of file CTBodbcStatement.cxx.

Referenced by FetchToStream(), and GetData().

bool CTBodbcStatement::GetData (  int i_icol,
char * c_value,
int i_size,
bool & b_null
)  [inline]
 

Get an unbound column (char*) - see above.

Definition at line 15 of file CTBodbcStatement.icc.

bool CTBodbcStatement::GetData (  int i_icol,
CTBint32 & i_value,
bool & b_null
)  [inline]
 

Get an unbound column (int) - see above.

Definition at line 24 of file CTBodbcStatement.icc.

bool CTBodbcStatement::GetData (  int i_icol,
float & f_value,
bool & b_null
)  [inline]
 

Gget an unbound column (float) - see above.

Definition at line 33 of file CTBodbcStatement.icc.

bool CTBodbcStatement::GetData (  int i_icol,
double & d_value,
bool & b_null
)  [inline]
 

Get an unbound column (double) - see above.

Definition at line 42 of file CTBodbcStatement.icc.

bool CTBodbcStatement::GetData (  int i_icol,
CTBodbcTime & time,
bool & b_null
)  [inline]
 

Get an unbound column (time) - see above.

Definition at line 51 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindIParameter (  int i_ipar,
SWORD i_ctype,
SWORD i_sqltype,
void * p_value
) 
 

Bind a parameter (generic).

  • i_ipar - parameter index (1...)
  • i_ctype - C data type of parameter
  • i_sqltype - SQL data type of parameter
  • p_value - pointer to value

Definition at line 540 of file CTBodbcStatement.cxx.

Referenced by BindIParameter().

bool CTBodbcStatement::BindIParameter (  int i_ipar,
SWORD i_sqltype,
const char * c_pvalue
) 
 

Bind a parameter (char*).

  • i_ipar - parameter index (1...)
  • i_sqltype - SQL data type of parameter
  • c_pvalue - parameter value

Definition at line 570 of file CTBodbcStatement.cxx.

bool CTBodbcStatement::BindIParameter (  int i_ipar,
SWORD i_sqltype,
CTBint32 & i_pvalue
)  [inline]
 

Bind a parameter (int) - see above.

Definition at line 61 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindIParameter (  int i_ipar,
SWORD i_sqltype,
float & f_pvalue
)  [inline]
 

Bind a parameter (float) - see above.

Definition at line 70 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindIParameter (  int i_ipar,
SWORD i_sqltype,
double & d_pvalue
)  [inline]
 

Bind a parameter (double) - see above.

Definition at line 79 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindIParameter (  int i_ipar,
SWORD i_sqltype,
CTBodbcTime & pvalue
)  [inline]
 

Bind a parameter (time) - see above.

Definition at line 88 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindCol (  int i_icol,
SWORD i_ctype,
void * p_value,
int i_size,
CTBint32 & i_rsize
) 
 

Bind a column (generic).

  • i_icol - column index (1...)
  • i_ctype - C data type of parameter
  • p_value - pointer to value
  • i_size - size of value
  • i_rsize - returned size

Definition at line 602 of file CTBodbcStatement.cxx.

Referenced by BindCol().

bool CTBodbcStatement::BindCol (  int i_icol,
char * c_cvalue,
int i_size,
CTBint32 & i_rsize
)  [inline]
 

Bind a column (char*) - see above.

Definition at line 97 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindCol (  int i_icol,
CTBint32 & i_cvalue,
CTBint32 & i_rsize
)  [inline]
 

Bind a column (int) - see above.

Definition at line 106 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindCol (  int i_icol,
float & f_cvalue,
CTBint32 & i_rsize
)  [inline]
 

Bind a column (float) - see above.

Definition at line 115 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindCol (  int i_icol,
double & d_cvalue,
CTBint32 & i_rsize
)  [inline]
 

Bind a column (double) - see above.

Definition at line 124 of file CTBodbcStatement.icc.

bool CTBodbcStatement::BindCol (  int i_icol,
CTBodbcTime & value,
CTBint32 & i_rsize
)  [inline]
 

Bind a column (time) - see above.

Definition at line 133 of file CTBodbcStatement.icc.

void CTBodbcStatement::PrintError (  ostream & os = cout ) 
 

Print s+c+e errors to stream.

Definition at line 623 of file CTBodbcStatement.cxx.

Referenced by AllocIfNull(), BindCol(), BindIParameter(), Close(), DescribeCol(), Execute(), Fetch(), GetData(), NumResultCols(), Prepare(), UnbindCol(), and UnbindParameter().

bool CTBodbcStatement::AllocIfNull (  )  [private]
 

Alloc statement if none allocated.

Definition at line 641 of file CTBodbcStatement.cxx.

Referenced by BindCol(), BindIParameter(), Execute(), Fetch(), GetData(), and Prepare().

Member Data Documentation

CTBodbcConnect& CTBodbcStatement::m_dbc [private]
 

back reference to dbConnect.

Definition at line 103 of file CTBodbcStatement.hxx.

HSTMT CTBodbcStatement::m_hstmt [private]
 

ODBC statement handle.

Definition at line 104 of file CTBodbcStatement.hxx.

The documentation for this class was generated from the following files:
Generated at Fri Oct 24 18:16:06 2003 for CTBodbc by doxygen1.2.9-20010812 written by Dimitri van Heesch, © 1997-2001