#include <cpl_odbc.h>
Public Member Functions | |
void | Clear () |
void | AppendEscaped (const char *) |
void | Append (const char *) |
void | Append (int) |
void | Append (double) |
int | Appendf (const char *,...) |
int | ExecuteSQL (const char *=0) |
int | Fetch (int nOrientation=SQL_FETCH_NEXT, int nOffset=0) |
int | GetColCount () |
const char * | GetColName (int iCol) |
short | GetColType (int iCol) |
short | GetColSize (int iCol) |
short | GetColPrecision (int iCol) |
short | GetColNullable (int iCol) |
int | GetColId (const char *) |
const char * | GetColData (int, const char *=0) |
const char * | GetColData (const char *, const char *=0) |
int | GetColumns (const char *pszTable, const char *pszCatalog=0, const char *pszSchema=0) |
int | GetPrimaryKeys (const char *pszTable, const char *pszCatalog=0, const char *pszSchema=0) |
int | GetTables (const char *pszCatalog=0, const char *pszSchema=0) |
void | DumpResult (FILE *fp, int bShowSchema=0) |
Static Public Member Functions | |
static const char * | GetTypeName (int) |
Includes methods for executing an SQL statement, and for accessing the resultset from that statement. Also provides for executing other ODBC requests that produce results sets such as SQLColumns() and SQLTables() requests.
|
Append to internal command. The passed value is formatted and appended to the internal SQL command text.
|
|
Append to internal command. The passed value is formatted and appended to the internal SQL command text.
|
|
Append text to internal command. The passed text is appended to the internal SQL command text.
|
|
Append text to internal command. The passed text is appended to the internal SQL command text after escaping any special characters so it can be used as a character string in an SQL statement.
|
|
Append to internal command. The passed format is used to format other arguments and the result is appended to the internal command text. Long results may not be formatted properly, and should be appended with the direct Append() methods.
|
|
Clear internal command text and result set definitions. |
|
Dump resultset to file. The contents of the current resultset are dumped in a simply formatted form to the provided file. If requested, the schema definition will be written first.
|
|
Execute an SQL statement. This method will execute the passed (or stored) SQL statement, and initialize information about the resultset if there is one. If a NULL statement is passed, the internal stored statement that has been previously set via Append() or Appendf() calls will be used.
|
|
Fetch a new record. Requests the next row in the current resultset using the SQLFetchScroll() call. Note that many ODBC drivers only support the default forward fetching one record at a time. Only SQL_FETCH_NEXT (the default) should be considered reliable on all drivers. Currently it isn't clear how to determine whether an error or a normal out of data condition has occured if Fetch() fails.
|
|
Fetch the resultset column count.
|
|
Fetch column data. Fetches the data contents of the requested column for the currently loaded row. The result is returned as a string regardless of the column type. NULL is returned if an illegal column is given, or if the actual column is "NULL".
|
|
Fetch column data. Fetches the data contents of the requested column for the currently loaded row. The result is returned as a string regardless of the column type. NULL is returned if an illegal column is given, or if the actual column is "NULL".
|
|
Fetch column index. Gets the column index corresponding with the passed name. The name comparisons are case insensitive.
|
|
Fetch a column name.
|
|
Fetch the column nullability.
|
|
Fetch the column precision.
|
|
Fetch the column width.
|
|
Fetch a column type. The return type code is a an ODBC SQL_ code, one of SQL_UNKNOWN_TYPE, SQL_CHAR, SQL_NUMERIC, SQL_DECIMAL, SQL_INTEGER, SQL_SMALLINT, SQL_FLOAT, SQL_REAL, SQL_DOUBLE, SQL_DATETIME, SQL_VARCHAR, SQL_TYPE_DATE, SQL_TYPE_TIME, SQL_TYPE_TIMESTAMPT.
|
|
Fetch column definitions for a table. The SQLColumn() method is used to fetch the definitions for the columns of a table (or other queriable object such as a view). The column definitions are digested and used to populate the CPLODBCStatement column definitions essentially as if a "SELECT * FROM tablename" had been done; however, no resultset will be available.
|
|
Fetch primary keys for a table. The SQLPrimaryKeys() function is used to fetch a list of fields forming the primary key. The result is returned as a result set matching the SQLPrimaryKeys() function result set. The 4th column in the result set is the column name of the key, and if the result set contains only one record then that single field will be the complete primary key.
|
|
Fetch tables in database. The SQLTables() function is used to fetch a list tables in the database. The result is returned as a result set matching the SQLTables() function result set. The 3rd column in the result set is the table name. Only tables of type "TABLE" are returned.
|
|
Get name for SQL column type. Returns a pointer to an internal static string name for the indicate type code (as returned from CPLODBCStatement::GetColType().
|