PODBC::Table This is the main Class to access Data returned by a Select Query. More...
#include <podbc.h>
Public Member Functions | |
Constructor/Deconstructor | |
| Table (PODBC *odbc, PString Query) | |
| Constructor Using the HDBC and TableName/Select SQL Query creates a virtual Table in the OBDC driver. More... | |
| ~Table () | |
| Deconstructor. More... | |
Data Storage | |
| Row | NewRow () |
| Add New Row. More... | |
| PBoolean | DeleteRow (PINDEX row=0) |
| Delete Row 0 indicates Current Row. More... | |
| PBoolean | Post () |
| Post Update back to Database. More... | |
Utilities | |
| PINDEX | Rows () |
| Rows. More... | |
| PINDEX | Columns () |
| Columns. More... | |
| PStringArray | ColumnNames () |
| ColumnNames. More... | |
| Row & | RecordHandler () |
| Obtain the Record Handler. More... | |
| Row & | operator[] (PINDEX row) |
| Row return the fetched row in the Cached RecordSet. More... | |
| Field & | operator() (PINDEX row, PINDEX col) |
| Returns the Field data at a predetermined position in the Resultant RecordSet. More... | |
| Field & | Column (PINDEX col) |
| Returns the indicated Column Holder for the RecordSet, This can be used for iterative Row calls. More... | |
| Field & | Column (PString Name) |
| Returns the indicated Column Holder Name for the RecordSet,. More... | |
 Public Member Functions inherited from PObject | |
| virtual | ~PObject () |
| virtual PObject * | Clone () const |
| Create a copy of the class on the heap. More... | |
| virtual PINDEX | HashFunction () const |
This function yields a hash value required by the PDictionary class. More... | |
| virtual const char * | GetClass (unsigned ancestor=0) const |
| Get the current dynamic type of the object instance. More... | |
| PBoolean | IsClass (const char *cls) const |
| virtual PBoolean | InternalIsDescendant (const char *clsName) const |
| Determine if the dynamic type of the current instance is a descendent of the specified class. More... | |
| virtual Comparison | Compare (const PObject &obj) const |
| Compare the two objects and return their relative rank. More... | |
| virtual Comparison | CompareObjectMemoryDirect (const PObject &obj) const |
| Determine the byte wise comparison of two objects. More... | |
| bool | operator== (const PObject &obj) const |
| Compare the two objects. More... | |
| bool | operator!= (const PObject &obj) const |
| Compare the two objects. More... | |
| bool | operator< (const PObject &obj) const |
| Compare the two objects. More... | |
| bool | operator> (const PObject &obj) const |
| Compare the two objects. More... | |
| bool | operator<= (const PObject &obj) const |
| Compare the two objects. More... | |
| bool | operator>= (const PObject &obj) const |
| Compare the two objects. More... | |
| virtual void | PrintOn (ostream &strm) const |
| Output the contents of the object to the stream. More... | |
| virtual void | ReadFrom (istream &strm) |
| Input the contents of the object from the stream. More... | |
Protected Attributes | |
| PODBCStmt | stmt |
| PString | tableName |
| ODBC Fetched Statement Info. More... | |
| Row * | RowHandler |
| Name of the Fetched Table (if used in Constructor) More... | |
Additional Inherited Members | |
| Public Types inherited from PObject | |
| enum | Comparison { LessThan = -1, EqualTo = 0, GreaterThan = 1 } |
Result of the comparison operation performed by the Compare() function. More... | |
| Static Public Member Functions inherited from PObject | |
| static const char * | Class () |
| Get the name of the class as a C string. More... | |
| static Comparison | InternalCompareObjectMemoryDirect (const PObject *obj1, const PObject *obj2, PINDEX size) |
| Internal function caled from CompareObjectMemoryDirect() More... | |
| Protected Member Functions inherited from PObject | |
| PObject () | |
| Constructor for PObject, made protected so cannot ever create one on its own. More... | |
Detailed Description
PODBC::Table This is the main Class to access Data returned by a Select Query.
The Table does not actually create the RecordSet but acts as a wrapper to the driver to access the cached data in the Driver.
Constructor & Destructor Documentation
§ Table()
Constructor Using the HDBC and TableName/Select SQL Query creates a virtual Table in the OBDC driver.
§ ~Table()
| PODBC::Table::~Table | ( | ) |
Deconstructor.
Member Function Documentation
§ Column() [1/2]
| Field& PODBC::Table::Column | ( | PINDEX | col | ) |
Returns the indicated Column Holder for the RecordSet, This can be used for iterative Row calls.
§ Column() [2/2]
Returns the indicated Column Holder Name for the RecordSet,.
§ ColumnNames()
| PStringArray PODBC::Table::ColumnNames | ( | ) |
ColumnNames.
Return the list of column Names of the Resultant RecordSet
§ Columns()
| PINDEX PODBC::Table::Columns | ( | ) |
Columns.
Returns the Number of Columns in the Resultant RecordSet
§ DeleteRow()
§ NewRow()
§ operator()()
| Field& PODBC::Table::operator() | ( | PINDEX | row, |
| PINDEX | col | ||
| ) |
§ operator[]()
| Row& PODBC::Table::operator[] | ( | PINDEX | row | ) |
Row return the fetched row in the Cached RecordSet.
An Array of PODBC::Field
§ Post()
| PBoolean PODBC::Table::Post | ( | ) |
Post Update back to Database.
§ RecordHandler()
| Row& PODBC::Table::RecordHandler | ( | ) |
Obtain the Record Handler.
This can be used as a Template to obtain Record Information. A call to tablename[i] will update the recordHandler with the Values contained in i Record.
§ Rows()
| PINDEX PODBC::Table::Rows | ( | ) |
Rows.
Returns the Number of Rows in the Resultant RecordSet
Member Data Documentation
§ RowHandler
§ stmt
|
protected |
§ tableName
The documentation for this class was generated from the following file:
