BASE CLASS FOR ODBC DATABASE. More...
#include <Zclassdb.h>
Public Member Functions | |
| void | Commit (void) |
| void | Rollback (void) |
| bool | Connect (void) |
Public Attributes | |
| bool | verbose |
| XSTRINGVECTOR | prefix |
| XSTRINGVECTOR | suffix |
| SQLUINTEGER | autocommit |
BASE CLASS FOR ODBC DATABASE.
% Represents a connection to a data source, through which you can operate on the data source. A data source is a specific instance of data hosted by some database management system (DBMS). Examples include Microsoft SQL Server,Microsoft Access,BorlandŽ dBASEŽ and xBASE. Open Database Connectivity (ODBC) are application programming interfaces (APIs) that give you the ability to write applications that are independent of any particular database management system (DBMS). ODBC provides an API that different database vendors implement via ODBC drivers specific to a particular database management system (DBMS). Your program uses this API to call the ODBC Driver Manager, which passes the calls to the appropriate driver. The driver, in turn, interacts with the DBMS using Structured Query Language (SQL).
| void zDB::Commit | ( | void | ) |
Commit operation for all active operations on all statements associated with a connection.
| bool zDB::Connect | ( | void | ) |
Establishes connections to a driver and a data source. The connection handle references storage of all information about the connection to the data source, including status, transaction state, and error information.
| void zDB::Rollback | ( | void | ) |
Rollback operation for all active operations on all statements associated with a connection.
| SQLUINTEGER zDB::autocommit |
Specifies whether to use autocommit or manual-commit mode: SQL_AUTOCOMMIT_OFF - The driver uses manual-commit mode, and the application must explicitly commit or roll back transactions. SQL_AUTOCOMMIT_ON - The driver uses autocommit mode. Each statement is committed immediately after it is executed. default. Any open transactions on the connection are committed when is set to SQL_AUTOCOMMIT_ON to change from manual-commit mode to autocommit mode.
| XSTRINGVECTOR zDB::prefix |
Character or characters used to prefix a literal; for example, a single quotation mark (') for character data types or 0x for binary data types; NULL is returned for data types where a literal prefix is not applicable.
| XSTRINGVECTOR zDB::suffix |
Character or characters used to terminate a literal; for example, a single quotation mark (') for character data types; NULL is returned for data types where a literal suffix is not applicable.
| bool zDB::verbose |
In case of errors, the function members will show a message box with detailed information. This member may be one of following values:
1.6.1