Concept Framework 2.2 documentation Contents | Index

standard.db.sql

Static library name Version Deprecated
standard.db.sql version 1.0 no

Import library : standard.db.sql
(you must include this at the top of your source: "import standard.db.sql" (no quotes)


Description:
ODBC library for database control. This is a low level library. Instead of this, is recommended that you use the ADOConnection, ADODataSet and ADODataRecord objects.

The ODBC (Open DataBase Connectivity ) is a standard for handling various types of database engine (including MS SQL and MySQL via MyODBC on both windows and penguins).

On linux or BSD systems (penguins) you should install the unixODBC or iODBC library before you compile this library. Concept doesn't provide data base specific libraries (like MySQLConnect or MSSQLConnect). Instead, you have this ODBC library that should provide access to most common used database engines.


Contained static functions:
ODBCAddParameter Add a parameter to a statement handle (same as result set)
ODBCAutoCommit Changes the default commit mode
ODBCBindResult Bind the results of a ODBCExecuteQuery or ODBCExecute
ODBCClearParameters Clear the parameters added to a previously created statement with ODBCStatement
ODBCColumnGet Get the data on the given column index on the current record
ODBCColumnSet Update data in a column
ODBCCommit Commit the data
ODBCConnect Connect to a database using a DSN(Data Source Name)
ODBCCountColumns Get the number of columns in the current result set
ODBCCountRows Get the number of rows in the current result set
ODBCDelete Delete the current row
ODBCDescribeCol Describe a column in a result set
ODBCDisconnect Disconnects a previously connected driver
ODBCDriver Get the name of the driver used for the given connection
ODBCDriverConnect Connects to a database using a connection string
ODBCError Get the last encountered errors, as reported by the ODBC driver
ODBCExecute Execute a prepared query
ODBCExecuteQuery Create and executes a statement
ODBCFetchAbsolute Position the current record on the given row (by its index) in the given data set
ODBCFetchFirst Position the current record on the first row in the given data set
ODBCFetchForward This function should be used only when working with MySQL and tables that contain big text fields
ODBCFetchLast Position the current record on the last record in the given data set
ODBCFetchNext Position the current record on the next row in the given data set
ODBCFetchPrior Position the current record on the previous row in the given data set
ODBCFirstDSN Get the name of the first system DSN(or user DSN, depending on the rights the application is using)
ODBCFreeQuery Free a result set
ODBCFreeResult Free the result set
ODBCListColumns Get the list of column names in specified tables
ODBCListTables Get the list of table, catalog, or schema names, and table types, stored in a specific data source
ODBCListTypes Get information about data types supported by the data source
ODBCLock Lock the access to a record
ODBCNextDSN Get the name of the next system DSN(or user DSN, depending on the rights the application is using)
ODBCPosition Get the absolute position of the current row
ODBCRollback Roll back the data
ODBCSkip Jump over a given number of rows
ODBCStatement Create an empty result set
ODBCUnlock Unlock the access to a previously locked record
ODBCUpdate Update the current row
ODBCWarning Get the last encountered warnings, as reported by the ODBC driver




Documented by Eduard Suica, generation time: Sun Jan 27 18:15:19 2013 GMT(c)2013 Devronium Applications