podbc.dll

Classes:

Functions:

Index

Common index

Class DataSourceSpec

#module root.system.database
The DataSourceSpec class is returned by the
		Odbc::GetDataSourcesList,
		Odbc::GetSysDataSourcesList
		Odbc::GetUserDataSourcesList
methods and contains the data source description.
Class fields:
	Name			- data source name;
	Description		- data source description (for instance, 
"SQL Server" or "MS Access");

Class DriverSpec

#module root.system.database
The DriverSpec class is returned by the Odbc::GetDriversList method 
and contains the ODBC driver description.
Class fields:
	Descr		- driver description;
	Arttrib	- driver attributes (depends on driver);

Class Odbc

#module root.system.database
The Odbc class is the ODBC manager representative. 
It is necessary for creating the OdbcDs class which 
in turn is the Data Source representative.

Methods:

Odbc::AddDataSource(object String, object String, refer ...)

param Driver, Arguments [, MainWnd];

Creates new private data source of the driver specified via the 
Driver parameter. The source name and additional attributes are 
determined by the set of arguments specified via the Arguments 
parameter. 
Arguments represent the following pairs:
	<KeyWord>=<Data>;
where key word and data values depends on the specific driver.
If the MainWnd parameter is omitted then the data source is not 
created in case of data insufficiency. If the MainWnd parameter 
is a pointer to an object of the GWnd class then the dialog of 
driver settings is invoked in case of data insufficiency.
The dialog of driver settings is a child one relatively to MainWnd.
If the MainWnd parameter is not a pointer to an object of the GWnd 
class or its descendant then the ERR_CASTING_ERROR error is raised.
This method returns TRUE if succeeded, otherwise FALSE.

Odbc::AddSysDataSource(object String, object String, refer ...)

param Driver, Arguments [, MainWnd];

Creates new system data source of the driver specified via the 
Driver parameter. The source name and additional attributes are 
determined by the set of arguments specified via the Arguments 
parameter. 
Arguments represent the following pairs:
	<KeyWord>=<Data>;
where key word and data values depends on the specific driver.
If the MainWnd parameter is omitted then the data source is not 
created in case of data insufficiency. If the MainWnd parameter 
is a pointer to an object of the GWnd class then the dialog of 
driver settings is invoked in case of data insufficiency.
The dialog of driver settings is a child one relatively to MainWnd.
If the MainWnd parameter is not a pointer to an object of the GWnd 
class or its descendant then the ERR_CASTING_ERROR error is raised.
This method returns TRUE if succeeded, otherwise FALSE.

Odbc::ConfigDataSource(object String, object String, refer ...)

param Driver, Arguments [, MainWnd];

Modifies private data source of the driver specified via the 
Driver parameter. The source name and additional attributes are 
determined by the set of arguments specified via the Arguments 
parameter. 
Arguments represent the following pairs:
	<KeyWord>=<Data>;
where key word and data values depends on the specific driver.
If the MainWnd parameter is omitted then the data source is not 
modified in case of data insufficiency. If the MainWnd parameter 
is a pointer to an object of the GWnd class then the dialog of 
driver settings is invoked in case of data insufficiency.
The dialog of driver settings is a child one relatively to MainWnd.
If the MainWnd parameter is not a pointer to an object of the GWnd 
class or its descendant then the ERR_CASTING_ERROR error is raised.
This method returns TRUE if succeeded, otherwise FALSE.

Odbc::ConfigSysDataSource(object String, object String, refer ...)

param Driver, Arguments [, MainWnd];

Modifies system data source of the driver specified via the 
Driver parameter. The source name and additional attributes are 
determined by the set of arguments specified via the Arguments 
parameter. 
Arguments represent the following pairs:
	<KeyWord>=<Data>;
where key word and data values depends on the specific driver.
If the MainWnd parameter is omitted then the data source is not 
modified in case of data insufficiency. If the MainWnd parameter 
is a pointer to an object of the GWnd class then the dialog of 
driver settings is invoked in case of data insufficiency.
The dialog of driver settings is a child one relatively to MainWnd.
If the MainWnd parameter is not a pointer to an object of the GWnd 
class or its descendant then the ERR_CASTING_ERROR error is raised.
This method returns TRUE if succeeded, otherwise FALSE.

Odbc::GetDataSourcesList(void)

Returns vector that contains the list of data sources known by the 
ODBC manager.

Odbc::GetDriversList(void)

Returns vector that contains the list of drivers known by the ODBC 
manager.

Odbc::GetPlukTypeName(int)

Returns the Pluk-type that corresponds to the SQL type.

Odbc::GetSysDataSourcesList(void)

Returns vector that contains the list of system data sources known by 
the ODBC manager.

Odbc::GetTypeName(int)

Returns the name of the constant that describes the SQL type.

Odbc::GetUserDataSourcesList(void)

Returns vector that contains the list of user data sources known by 
the ODBC manager.

Odbc::IsValid(void)

Returns TRUE if connection with the ODBC manager is established 
successfully, otherwise - FALSE.

Odbc::Odbc(copy)

This constructor establishes connection with the ODBC manager.

Odbc::Odbc(void)

This constructor establishes connection with the ODBC manager.

Odbc::RemoveDataSource(object String, object String, refer ...)

param Driver, Arguments [, MainWnd];

Deletes private data source of the driver specified via the 
Driver parameter. The source name and additional attributes are 
determined by the set of arguments specified via the Arguments 
parameter. 
Arguments represent the following pairs:
	<KeyWord>=<Data>;
where key word and data values depends on the specific driver.
If the MainWnd parameter is omitted then the data source is not 
deleted in case of data insufficiency. If the MainWnd parameter 
is a pointer to an object of the GWnd class then the dialog of 
driver settings is invoked in case of data insufficiency.
The dialog of driver settings is a child one relatively to MainWnd.
If the MainWnd parameter is not a pointer to an object of the GWnd 
class or its descendant then the ERR_CASTING_ERROR error is raised.
This method returns TRUE if succeeded, otherwise FALSE.

Odbc::RemoveSysDataSource(object String, object String, refer ...)

param Driver, Arguments [, MainWnd];

Deletes system data source of the driver specified via the 
Driver parameter. The source name and additional attributes are 
determined by the set of arguments specified via the Arguments 
parameter. 
Arguments represent the following pairs:
	<KeyWord>=<Data>;
where key word and data values depends on the specific driver.
If the MainWnd parameter is omitted then the data source is not 
deleted in case of data insufficiency. If the MainWnd parameter 
is a pointer to an object of the GWnd class then the dialog of 
driver settings is invoked in case of data insufficiency.
The dialog of driver settings is a child one relatively to MainWnd.
If the MainWnd parameter is not a pointer to an object of the GWnd 
class or its descendant then the ERR_CASTING_ERROR error is raised.
This method returns TRUE if succeeded, otherwise FALSE.

Odbc::~Odbc(void)

This destructor releases connection with the ODBC manager.

Class OdbcDs

#module root.system.database
The OdbcDs class is the object that provides connection to the Data Source. 
Each Data Source query that is performed by an object of the OdbcStmt 
class demands the OdbcDs class existence.

Methods:

OdbcDs::AlterTable(object String, object Vector)

param TableName, ColumnSpec;

This method modifies the table whose name is specified via the 
TableName parameter in the data source.
If it is necessary to explicitly define the table owner then its 
name should be included into the TableName parameter.
The ColumnSpec parameter represents a vector of field specifications.
Field specification represents a vector of the following type: 
	<< ColumnName, ColumnType [, ColumnSize ] [, OptionalSpec] >>
here:
	ColumnName - object String that contains column name.
	ColumnType - int from the following list 
		SQL_CHAR
		SQL_NUMERIC
		SQL_DECIMAL
		SQL_INTEGER
		SQL_SMALLINT
		SQL_FLOAT
		SQL_REAL
		SQL_DOUBLE
		SQL_DATE
		SQL_TIME
		SQL_TIMESTAMP
		SQL_CHAR
		SQL_VARCHAR
		SQL_LONGVARCHAR
		SQL_NCHAR
		SQL_NVARCHAR
		SQL_NLONGVARCHAR
		SQL_BINARY
		SQL_VARBINARY
		SQL_LONGVARBINARY
		SQL_BIGINT
		SQL_TINYINT
		SQL_BIT.
	ColumnSize - int that determines the column size (if can be 
applied).
	OptionalSpec - object String that contains additional 
specification, for instance, \"UNIQUE NOT NULL\".
Note:
	This method just deletes superfluous columns and inserts new 
	ones to the table but does not change the existing columns that 
	is does not modify column size and/or type. RDBMS determines the 
	capability of existing columns deleting (for instance, MS SQL 
	Server 6.5 does not allow existing columns deleting).

OdbcDs::CSQLState(void)

Returns text interpretation of the additional information (error code) 
that was passed with the last operation performed at the Data Source.

OdbcDs::Commit(void)

Completes transaction with result recording to the database.
Returns TRUE if succeeded, otherwise - FALSE.
The ERR_TRN error is possible.

OdbcDs::CommitTransaction(void)

#rus Завершить успешно транзакцию.

OdbcDs::ConnectTo(object String, refer ...)

param SrcSpec [, ParentWnd];

Connects to the Data Source specified via the SrcSpec parameter. 
If the ParentWnd parameter is passed and driver does not have enough 
data for connection then the driver invokes dialog in order to request 
user for necessary data. 
This dialog is a child window relatively to ParentWnd.
The ERR_CONNECT error is raised in case of failure.

OdbcDs::CreateTable(object String, object Vector, ...)

param TableName, ColumnSpec, [AddtionalSpecs];

This method creates the table whose name is specified via the 
TableName parameter in the data source.
If it is necessary to explicitly define the table owner then its 
name should be included into the TableName parameter.
The ColumnSpec parameter represents a vector of field specifications.
Field specification represents a vector of the following type: 
	<< ColumnName, ColumnType [, ColumnSize ] [, OptionalSpec] >>
here:
	ColumnName - object String that contains column name.
	ColumnType - int from the following list 
		SQL_CHAR
		SQL_NUMERIC
		SQL_DECIMAL
		SQL_INTEGER
		SQL_SMALLINT
		SQL_FLOAT
		SQL_REAL
		SQL_DOUBLE
		SQL_DATE
		SQL_TIME
		SQL_TIMESTAMP
		SQL_CHAR
		SQL_VARCHAR
		SQL_LONGVARCHAR
		SQL_NCHAR
		SQL_NVARCHAR
		SQL_NLONGVARCHAR
		SQL_BINARY
		SQL_VARBINARY
		SQL_LONGVARBINARY
		SQL_BIGINT
		SQL_TINYINT
		SQL_BIT.
	ColumnSize - int that determines the column size (if can be 
applied).
	OptionalSpec - object String that contains additional 
specification, for instance, \"UNIQUE NOT NULL\".
The AddtionalSpecs parameter defines the specification that is not 
included in the descriptions of separate columns: 
	- primary keys for set of columns 
	- conditions for on set of columns 
	and others

OdbcDs::Disconnect(void)

Closes connection with the Data Source. 
The ERR_DISCONNECT error is raised in case of failure.

OdbcDs::GetColumns(refer object String)

param TableName;

Returns vector that consists of objects of the SQLColumnSpec class 
which describes all columns of the table specified via the TableName 
parameter.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetColumns(refer object String, refer object String, refer object String)

param TableQualifier, TableOwner, TableName;

Returns vector that consists of objects of the SQLColumnSpec class 
which describes all columns of the TableQualifier@TableOwner.TableName table.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetForeignKeys(refer object String, refer object String, refer object String)

param TableQualifier, TableOwner, TableName;

Returns vector that consists of objects of the 
SQLTableForeignKeys class which describes all 
foreign keys of the TableQualifier@TableOwner.TableName table.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetFunctions(int)

param FuncCode;

Returns flag that indicates whether any function is supported by driver.
Available parameter values include:
		SQL_API_ALL_FUNCTIONS
		SQL_API_SQLALLOCCONNECT
		SQL_API_SQLALLOCENV
		SQL_API_SQLALLOCSTMT
		SQL_API_SQLBINDCOL
		SQL_API_SQLCANCEL
		SQL_API_SQLCOLATTRIBUTES
		SQL_API_SQLCONNECT
		SQL_API_SQLDESCRIBECOL
		SQL_API_SQLDISCONNECT
		SQL_API_SQLERROR
		SQL_API_SQLEXECDIRECT
		SQL_API_SQLEXECUTE
		SQL_API_SQLFETCH
		SQL_API_SQLFREECONNECT
		SQL_API_SQLFREEENV
		SQL_API_SQLFREESTMT
		SQL_API_SQLGETCURSORNAME
		SQL_API_SQLNUMRESULTCOLS
		SQL_API_SQLPREPARE
		SQL_API_SQLROWCOUNT
		SQL_API_SQLSETCURSORNAME
		SQL_API_SQLSETPARAM
		SQL_API_SQLTRANSACT
		SQL_NUM_FUNCTIONS
		SQL_EXT_API_START
		SQL_API_SQLCOLUMNS
		SQL_API_SQLDRIVERCONNECT
		SQL_API_SQLGETCONNECTOPTION
		SQL_API_SQLGETDATA
		SQL_API_SQLGETFUNCTIONS
		SQL_API_SQLGETINFO
		SQL_API_SQLGETSTMTOPTION
		SQL_API_SQLGETTYPEINFO
		SQL_API_SQLPARAMDATA
		SQL_API_SQLPUTDATA
		SQL_API_SQLSETCONNECTOPTION
		SQL_API_SQLSETSTMTOPTION
		SQL_API_SQLSPECIALCOLUMNS
		SQL_API_SQLSTATISTICS
		SQL_API_SQLTABLES
		SQL_API_SQLBROWSECONNECT
		SQL_API_SQLCOLUMNPRIVILEGES
		SQL_API_SQLDATASOURCES
		SQL_API_SQLDESCRIBEPARAM
		SQL_API_SQLEXTENDEDFETCH
		SQL_API_SQLFOREIGNKEYS
		SQL_API_SQLMORERESULTS
		SQL_API_SQLNATIVESQL
		SQL_API_SQLNUMPARAMS
		SQL_API_SQLPARAMOPTIONS
		SQL_API_SQLPRIMARYKEYS
		SQL_API_SQLPROCEDURECOLUMNS
		SQL_API_SQLPROCEDURES
		SQL_API_SQLSETPOS
		SQL_API_SQLSETSCROLLOPTIONS
		SQL_API_SQLTABLEPRIVILEGES
		SQL_API_SQLDRIVERS
		SQL_API_SQLBINDPARAMETER
(for more information see the ODBC standard description)

OdbcDs::GetIndexList(object String, object String, object String)

param TableQualifier, TableOwner, TableName

#rus Возвращает массив из объектов SQLIndex с описанием индексов таблицы TableName.

OdbcDs::GetInfo(int)

param Info;

Returns the information specified via the Info parameter.
The type of the returned value depends on the request.
Available values for the Info parameter include:
	SQL_ACCESSIBLE_PROCEDURES
	SQL_ACCESSIBLE_TABLES
	SQL_COLUMN_ALIAS
	SQL_DATA_SOURCE_NAME
	SQL_DATA_SOURCE_READ_ONLY
	SQL_DATABASE_NAME
	SQL_DBMS_NAME
	SQL_DBMS_VER
	SQL_DRIVER_NAME
	SQL_DRIVER_ODBC_VER
	SQL_DRIVER_VER
	SQL_EXPRESSIONS_IN_ORDERBY
	SQL_IDENTIFIER_QUOTE_CHAR
	SQL_KEYWORDS
	SQL_LIKE_ESCAPE_CLAUSE
	SQL_MAX_ROW_SIZE_INCLUDES_LONG
	SQL_MULT_RESULT_SETS
	SQL_MULTIPLE_ACTIVE_TXN
	SQL_NEED_LONG_DATA_LEN
	SQL_ODBC_VER
	SQL_ORDER_BY_COLUMNS_IN_SELECT
	SQL_OUTER_JOINS
	SQL_OWNER_TERM
	SQL_PROCEDURE_TERM
	SQL_PROCEDURES
	SQL_QUALIFIER_NAME_SEPARATOR
	SQL_QUALIFIER_TERM
	SQL_ROW_UPDATES
	SQL_SEARCH_PATTERN_ESCAPE
	SQL_SERVER_NAME
	SQL_SPECIAL_CHARACTERS
	SQL_TABLE_TERM
	SQL_USER_NAME
	SQL_ACTIVE_CONNECTIONS
	SQL_ACTIVE_STATEMENTS
	SQL_CONCAT_NULL_BEHAVIOR
	SQL_CORRELATION_NAME
	SQL_CURSOR_COMMIT_BEHAVIOR
	SQL_CURSOR_ROLLBACK_BEHAVIOR
	SQL_FILE_USAGE
	SQL_GROUP_BY
	SQL_IDENTIFIER_CASE
	SQL_MAX_COLUMN_NAME_LEN
	SQL_MAX_COLUMNS_IN_GROUP_BY
	SQL_MAX_COLUMNS_IN_INDEX
	SQL_MAX_COLUMNS_IN_ORDER_BY
	SQL_MAX_COLUMNS_IN_SELECT
	SQL_MAX_COLUMNS_IN_TABLE
	SQL_MAX_CURSOR_NAME_LEN
	SQL_MAX_OWNER_NAME_LEN
	SQL_MAX_PROCEDURE_NAME_LEN
	SQL_MAX_QUALIFIER_NAME_LEN
	SQL_MAX_TABLES_IN_SELECT
	SQL_MAX_TABLE_NAME_LEN
	SQL_MAX_USER_NAME_LEN
	SQL_NON_NULLABLE_COLUMNS
	SQL_NULL_COLLATION
	SQL_ODBC_API_CONFORMANCE
	SQL_ODBC_SAG_CLI_CONFORMANCE
	SQL_ODBC_SQL_CONFORMANCE
	SQL_QUALIFIER_LOCATION
	SQL_TXN_CAPABLE
	SQL_ALTER_TABLE
	SQL_BOOKMARK_PERSISTENCE
	SQL_CONVERT_BIGINT
	SQL_CONVERT_BINARY
	SQL_CONVERT_BIT
	SQL_CONVERT_CHAR
	SQL_CONVERT_DATE
	SQL_CONVERT_DECIMAL
	SQL_CONVERT_DOUBLE
	SQL_CONVERT_FLOAT
	SQL_CONVERT_INTEGER
	SQL_CONVERT_LONGVARBINARY
	SQL_CONVERT_LONGVARCHAR
	SQL_CONVERT_NUMERIC
	SQL_CONVERT_REAL
	SQL_CONVERT_SMALLINT
	SQL_CONVERT_TIME
	SQL_CONVERT_TIMESTAMP
	SQL_CONVERT_TINYINT
	SQL_CONVERT_VARBINARY
	SQL_CONVERT_VARCHAR
	SQL_CONVERT_FUNCTIONS
	SQL_DEFAULT_TXN_ISOLATION
	SQL_DRIVER_HDBC
	SQL_DRIVER_HENV
	SQL_DRIVER_HLIB
	SQL_DRIVER_HSTMT
	SQL_FETCH_DIRECTION
	SQL_GETDATA_EXTENSIONS
	SQL_LOCK_TYPES
	SQL_MAX_BINARY_LITERAL_LEN
	SQL_MAX_CHAR_LITERAL_LEN
	SQL_MAX_INDEX_SIZE
	SQL_MAX_ROW_SIZE
	SQL_MAX_STATEMENT_LEN
	SQL_NUMERIC_FUNCTIONS
	SQL_OJ_CAPABILITIES
	SQL_OWNER_USAGE
	SQL_POS_OPERATIONS
	SQL_POSITIONED_STATEMENTS
	SQL_QUALIFIER_USAGE
	SQL_QUOTED_IDENTIFIER_CASE
	SQL_SCROLL_CONCURRENCY
	SQL_SCROLL_OPTIONS
	SQL_STATIC_SENSITIVITY
	SQL_STRING_FUNCTIONS
	SQL_SUBQUERIES
	SQL_SYSTEM_FUNCTIONS
	SQL_TIMEDATE_ADD_INTERVALS
	SQL_TIMEDATE_DIFF_INTERVALS
	SQL_TIMEDATE_FUNCTIONS
	SQL_TXN_ISOLATION_OPTION
	SQL_ODBC_SQL_OPT_IEF
	SQL_UNION
(for more information see the ODBC standard description)

OdbcDs::GetLastError(void)

Returns the last error text.

OdbcDs::GetODBCVersion(void)

Returns string that contains the driver version description in the 
##.##.#### format.

OdbcDs::GetOdbcStmt(void)

#rus Метод возвращает новый OdmlStmt
#rus Метод предназначен для работы с наследниками классов
#rus OdbcDs и OdbcStmt. В этом случае у наследника класса
#rus OdbcDs переписывается метод GetOdbcStmt так, чтобы он возвращаел
#rus соотвктсвующий наследник класса OdbcStmt.

OdbcDs::GetOption(int)

param OptionsCode;

Returns the connection to the source options. 
Available values for the OptionsCode parameter include:
	SQL_ACCESS_MODE
	SQL_AUTOCOMMIT
	SQL_LOGIN_TIMEOUT
	SQL_ODBC_CURSORS
	SQL_OPT_TRACE
	SQL_PACKET_SIZE
	SQL_QUIET_MODE
	SQL_TRANSLATE_OPTION
	SQL_TXN_ISOLATION_OPTION
	SQL_INTEGRATED_SECURITY
	SQL_CURRENT_QUALIFIER
	SQL_OPT_TRACEFILE
	SQL_TRANSLATE_DLL
(for more information see the ODBC standard description)
The ERR_OPTION error is raised in case of failure.

OdbcDs::GetPrimaryKeys(refer object String, refer object String, refer object String)

param TableQualifier, TableOwner, TableName;

Returns vector that consists of objects of the 
SQLTablePrimaryKeys class which describes all 
primary keys of the TableQualifier@TableOwner.TableName table.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetRetCode(void)

Returns the result of the last operation performed. 
The following returned values are available:
	SQL_INVALID_HANDLE
	SQL_ERROR
	SQL_SUCCESS
	SQL_SUCCESS_WITH_INFO
	SQL_NO_DATA_FOUND

OdbcDs::GetSQLStateText(void)

Returns text interpretation of the additional information (error code) 
that was passed with the last operation performed at the Data Source. 
See the ODBC description for the list of possible values.

OdbcDs::GetSpecialColumns(int, refer object String, refer object String, refer object String, int, int)

param QueryType, TableQualifier, TableOwner, TableName, Scope, Nullable;

Returns vector that consists of objects of the SQLSpecColumn class 
which describes tables specified via the TableQualifier, 
TableOwner, TableName parameters.
The QueryType parameter can possess _BEST_ROWID or SQL_ROWVER values.
The Scope parameter can possess 
		SQL_SCOPE_CURROW
		SQL_SCOPE_TRANSACTION
		SQL_SCOPE_SESSION
values.
The Nullable parameter can possess 
		SQL_NO_NULLS
		SQL_NULLABLE
		SQL_NULLABLE_UNKNOWN
values.
(for more information see the ODBC standard description)
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetStatistic(refer object String, refer object String, refer object String, int, int)

param TableQualifier, TableOwner, TableName, Unique, Accuracy;

Returns vector that consists of objects of the SQLStatistic class 
which describes tables specified via the TableQualifier, 
TableOwner, TableName parameters.
The Unique parameter can possess SQL_INDEX_UNIQUE or SQL_INDEX_ALL values.
The Accuracy parameter can possess SQL_ENSURE or SQL_QUICK values.
(for more information see the ODBC standard description)
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetTablePrivelegesList(refer object String, refer object String, refer object String)

param TableQualifier, TableOwner, TableName;

Returns vector that consists of objects of the SQLTablePrivelege class 
which describes privileges of all tables included into the Data Source 
that come within the descriptions of the TableQualifier, TableOwner, 
TableName parameters.
Empty string within parameters means missing of the appropriate field.
The % and # masks are available within the field.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetTablePrivelegesList(void)

Returns vector that consists of objects of the SQLTablePrivelege class 
which describes privileges of all tables included into the Data Source.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetTablesList(refer object String, refer object String, refer object String)

param TableQualifier, TableOwner, TableName;

Returns vector that consists of objects of the SQLTableSpec class 
which describes all tables included into the Data Source that come 
within the descriptions of the TableQualifier, TableOwner, TableName 
parameters.
Empty string within parameters means missing of the appropriate field.
The % and # masks are available within the field.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetTablesList(void)

Returns vector that consists of objects of the SQLTableSpec class 
which describes all tables included into the Data Source.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetTypeInfo(int)

param Type;

Returns vector that consists of SQLTypeSpec objects 
with the description type specified via the Type 
parameter in a specific Data Source.
Available values for the Type parameter include:
	SQL_ALL_TYPES
	SQL_CHAR
	SQL_NUMERIC
	SQL_DECIMAL
	SQL_INTEGER
	SQL_SMALLINT
	SQL_FLOAT
	SQL_REAL
	SQL_DOUBLE
	SQL_DATE
	SQL_TIME
	SQL_TIMESTAMP
	SQL_VARCHAR
	SQL_LONGVARCHAR
	SQL_BINARY
	SQL_VARBINARY
	SQL_LONGVARBINARY
	SQL_BIGINT
	SQL_TINYINT
	SQL_BIT
The ERR_GET_TYPEINFO error is possible.

OdbcDs::GetUnSerializeFlg(void)

This method returns the UnSerializeFlg flag.
(for more information see the OdbcDs::SetUnSerialize(boolean) method)

OdbcDs::GetViewesList(refer object String, refer object String, refer object String)

param TableQualifier, TableOwner, TableName;

Returns vector that consists of objects of the SQLTableSpec class 
which describes all views included into the Data Source that come 
within the descriptions of the TableQualifier, TableOwner, TableName 
parameters.
Empty string within parameters means missing of the appropriate field.
The % and # masks are available within the field.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::GetViewesList(void)

Returns vector that consists of objects of the SQLTableSpec class 
which describes all views included into the Data Source.
The ERR_GETTABLE is raised in case of failure.

OdbcDs::InsistType(void)

#rus Возвращает TRUE, если DBMS не обеспечивает полную
#rus поддержку типов

OdbcDs::NativeSql(refer object String)

param SQL_Query;

Returns string that contains interpretation of the SQL_Query 
query to the dialect of a specific Data Source.
The ERR_SQL_SINTAX error is possible.

OdbcDs::OdbcDs(copy)

param Src;

This constructor creates a copy of the object for the Data Source connection.
Created object does not have connection with the Data Source before 
calling the ConnectTo method.
The ERR_ALLOC_CONNECT error is possible in case of the ODBC manager 
denial of connection.

OdbcDs::OdbcDs(object String)

param SrcSpec;

This constructor creates an object for the Data Source connection.
Created object is connected with the Data Source specified via the 
SrcSpec parameter. The ERR_CONNECT error is raised in case of failure.
The ERR_ALLOC_CONNECT error is possible in case of the ODBC manager 
denial of connection.

OdbcDs::OdbcDs(void)

This constructor creates an object for the Data Source connection.
Created object does not have connection with the Data Source before 
calling the ConnectTo method.
The ERR_ALLOC_CONNECT error is possible in case of the ODBC manager 
denial of connection.

OdbcDs::OpenTransaction(int)

param Isolation;

#rus Начинает блок операций - транзакцию, которая должна
#rus закончиться либо командой Commit либо RollBack;
#rus Isolation - тип изоляции транзакции.
#rus Допустимые значения:
	SQL_TXN_SERIALIZABLE
	SQL_TXN_REPEATABLE_READ
	SQL_TXN_READ_COMMITTED
	SQL_TXN_READ_UNCOMMITTED

OdbcDs::OpenTransaction(void)

#rus Начинает блок операций - транзакцию, которая должна
#rus закончиться либо командой Commit либо RollBack;
#rus Тип изоляции транзакции - SQL_TXN_SERIALIZABLE

OdbcDs::RollBack(void)

Completes transaction with the rollback to the previous state of the database.
Returns TRUE if succeeded, otherwise - FALSE.
The ERR_TRN error is possible.

OdbcDs::RollBackTransaction(void)

#rus Произвести откатку транзакции к предыдущему стабильному состоянию.

OdbcDs::SQLState(void)

Returns text interpretation of the additional information (error code) 
that was passed with the last operation performed at the Data Source. 
The following returned values are available:
		SQL_UNKNOWN_STATE,
		SQL_GENERAL_WARNING,
		SQL_LINK_FAILURE,
		SQL_GENERAL_ERROR,
		SQL_SEQUENCE_ERROR,
		SQL_DISCONNECT_ERROR,
		SQL_CONNECTION_NOT_OPEN,
		SQL_INVALID_TRN_STATE,
		SQL_DRIVER_NOT_SUPPORT,
		SQL_OUT_OF_MEMORY,
		SQL_CNT_FAILURE_DURING_TRN,
		SQL_INVALID_TRN_CODE,
		SQL_DRIVER_NOT_CAPABLE,
		SQL_DATA_TRUNCATED,
		SQL_INVALID_CNT_STRING,
		SQL_OPTION_VALUE_CHANGED,
		SQL_CANT_CNT_TO_DS,
		SQL_CNT_BUSY,
		SQL_DS_DENY_CNT,
		SQL_INVALID_AUTORIZATION,
		SQL_DS_NOT_FOUND,
		SQL_CANT_LOAD_DRIVER,
		SQL_ALLC_EVN_FAILED,
		SQL_ALLC_CNT_FAILED,
		SQL_SET_CNT_FAILED,
		SQL_NO_SOURCE_SPEC,
		SQL_DIALOG_FAILED,
		SQL_DLL_LOAD_ERROR,
		SQL_DS_NAME_TOO_LONG,
		SQL_DRV_NAME_TOO_LONG,
		SQL_DRV_KWD_ERROR,
		SQL_INVALID_BUFFER_LEN,
		SQL_DRV_COMPL,
		SQL_TIMEOUT,
		SQL_WRONG_DIRECTION,
		SQL_WRONG_CURSOR_STATE,
		SQL_WRONG_ARG_VALUE,
		SQL_INVALID_AT_TIME,
		SQL_OUT_OF_RANGE,
		SQL_NUMBER_OUT_OF_RANGE,
		SQL_INFOTYPE_OUT_OF_RANGE,
		SQL_CANCELED,
		SQL_WRONG_ROW,
		SQL_NO_ROW_UPD_OR_DEL,
		SQL_MORE_THAN_1_ROW_UPD_OR_DEL,
		SQL_WONG_COLUMN_LIST,
		SQL_ASSIGN_ERROR,
		SQL_DATETIME_OVERFLOW,
		SQL_INTEGRITY_VIOLATION,
		SQL_ACCESS_VIOLATION,
		SQL_NO_DEFAULT_FOR_COLUMN,
		SQL_ROW_VALUE_OUT_OF_RANGE,
		SQL_INVALID_CURSOR_POS,
		SQL_WONG_COLUMN_NUMBER,
		SQL_DESCR_OUT_OF_RANGE,
		SQL_FETCH_BEFORE_RESULT_READY,
		SQL_TYPE_ATTR_VIOLATION,
		SQL_INDICATOR_ABSENT,
		SQL_DIVIDE_BY_ZERO,
		SQL_SERIALIZE_FAILURE,
		SQL_FETCH_OUT_OF_RANGE,
		SQL_INVALID_BOOKMARK,
		SQL_INVALID_CURSORNAME,
		SQL_DUPLICATE_CURSORNAME,
		SQL_NO_CURSORNAME,
		SQL_WRONG_UNIQUE_PARAM,
		SQL_WRONG_ACCUR_PARAM.

OdbcDs::SetOption(int, refer any)

param OptionsCode, Value;

Sets the connection to the source options. 
Available values for the OptionsCode parameter include:
	SQL_ACCESS_MODE
	SQL_AUTOCOMMIT
	SQL_LOGIN_TIMEOUT
	SQL_ODBC_CURSORS
	SQL_OPT_TRACE
	SQL_PACKET_SIZE
	SQL_QUIET_MODE
	SQL_TRANSLATE_OPTION
	SQL_TXN_ISOLATION
	SQL_INTEGRATED_SECURITY
	SQL_CURRENT_QUALIFIER
	SQL_OPT_TRACEFILE
	SQL_TRANSLATE_DLL
The Value parameter value and type depend on the option code. 
The Value parameter type is an integer number for the following options 
	from SQL_ACCESS_MODE till SQL_TXN_ISOLATION
and string for the following options
	from SQL_CURRENT_QUALIFIER till SQL_TRANSLATE_DLL.
(for more information see the ODBC standard description)
The ERR_OPTION error is raised in case of failure.

OdbcDs::SetUnSerializeFlg(boolean)

param UnSerializeFlg;

If the UnSerializeFlg parameter == TRUE then all the created OdbcStmt objects 
with the current source have the UnSerializeFlg flag == TRUE, by default.
Otherwise all the created OdbcStmt objects with the current source have 
the UnSerializeFlg flag == FALSE, by default.

OdbcDs::~OdbcDs(void)

This destructor releases the Data Source connection if it was established.
The ERR_FREE_CONNECT error is possible.

Class OdbcStmt

#module root.system.database
The OdbcStmt class is the object that provides data manipulation 
within the Data Source.

Methods:

OdbcStmt::BindColumn(int)

param Size;

Performs binding of all query columns on order to receive reply by 
the Fetch or ExtendedFetch method (with power of set captured by 
one call of the ExtendedFetch equal to the Size parameter ).
Returns an object of the SQLResult class with the initiated ColName field.
The following errors are possible:
	ERR_BIND_COL
	ERR_CONNECTION_BUSY
	ERR_DESCRIBE_COL

OdbcStmt::BindColumn(void)

Performs binding of all query columns on order to receive reply 
by the Fetch or ExtendedFetch method (with power of set captured 
by one call of the ExtendedFetch equal to 1).
Returns an object of the SQLResult class with the initiated ColName field.
The following errors are possible:
	ERR_BIND_COL
	ERR_CONNECTION_BUSY
	ERR_DESCRIBE_COL

OdbcStmt::Cancel(void)

Interrupts operation execution which is performed in the out-of-sync mode.
Returns TRUE if the operation is interrupted, otherwise FALSE.
The ERR_CANCEL_STMT is raised in case of failure.

OdbcStmt::Close(void)

Releases all resources related to the operations 
that were performed via the object.
The ERR_CLOSE_STMT is raised in case of failure.

OdbcStmt::DescribeCol(int)

param ColNumber;

Returns an object of the SQLColumnDescr class that describes the 
column specified via the ColNumber parameter in the result set.
The ERR_DESCRIBE_COL error is possible.

OdbcStmt::Exec(refer object String)

param SQL_Query;

Executes the SQL operator specified via the SQL_Query parameter.
According to the executed operation returns either the number of 
strings touched by the operator or an object of the SQLResult class. 
At that the vector with column names is contained within the ColName 
field and object contains (as a descendant of the Vector class) the 
set of vectors that represent result strings (cartridges).
The following errors are possible:
	ERR_SQL_PARAMETERS
	ERR_BIND_COL
	ERR_SQL_SINTAX
	ERR_CONNECTION_BUSY
	ERR_GET_DATA
	ERR_DESCRIBE_COL
	ERR_EXECUTE

OdbcStmt::Exec(refer object String, refer object Vector)

param SQL_Query, Parameters;

Executes the SQL operator specified via the SQL_Query parameter.
The Parameters parameter represents the vector which is considered to 
be a set of parameters that consists of vector elements.
According to the executed operation returns either the number of 
touched by the operator strings or an object of the SQLResult class. 
At that the vector with column names is contained within the ColName 
field and object contains (as a descendant of the Vector class) the 
set of vectors that represent result strings (cartridges).
The following errors are possible:
	ERR_SQL_PARAMETERS
	ERR_BIND_COL
	ERR_SQL_SINTAX
	ERR_CONNECTION_BUSY
	ERR_GET_DATA
	ERR_DESCRIBE_COL
	ERR_EXECUTE

OdbcStmt::ExtendedFetch(int, int, boolean)

param FetchType, Row, ReadLineStatus;

Returns the following set of cartridges. 
(for more information see the Prepare and BindColumn methods description);
Available values for the FetchType parameter include:
	SQL_FETCH_NEXT
	SQL_FETCH_FIRST
	SQL_FETCH_LAST
	SQL_FETCH_PRIOR
	SQL_FETCH_ABSOLUTE
	SQL_FETCH_RELATIVE
The meaning of the Row parameter depends on the FetchType parameter value.
(for more information see the ODBC standard description)
If the ReadLineStatus parameter == TRUE then the result consists of 
the following pairs: << String, StringStatus >>, otherwise only 
read strings are returned.
Available values for the StringStatus include:
	SQL_ROW_SUCCESS
	SQL_ROW_UPDATED
	SQL_ROW_DELETED
	SQL_ROW_ADDED
	SQL_ROW_ERROR
Returns EMPTY in case of null data.
The following errors are possible:
	ERR_GET_DATA

OdbcStmt::ExtendedFetch(refer object SQLResult, int, int, boolean)

param Result, FetchType, Row, ReadLineStatus;

Places the following set of cartridges into the Result object. 
(for more information see the Prepare and BindColumn methods description);
Available values for the FetchType parameter include:
	SQL_FETCH_NEXT
	SQL_FETCH_FIRST
	SQL_FETCH_LAST
	SQL_FETCH_PRIOR
	SQL_FETCH_ABSOLUTE
	SQL_FETCH_RELATIVE
The meaning of the Row parameter depends on the FetchType parameter value.
(for more information see the ODBC standard description)
If the ReadLineStatus parameter == TRUE then the result consists of 
the following pairs: << String, StringStatus >>, otherwise only read 
strings are returned.
Available values for the StringStatus include:
	SQL_ROW_SUCCESS
	
SQL_ROW_UPDATED
	
SQL_ROW_DELETED
	SQL_ROW_ADDED
	SQL_ROW_ERROR
Returns TRUE if succeeded, otherwise FALSE.
The following errors are possible:
	ERR_GET_DATA

OdbcStmt::Fetch(refer object SQLResult)

param Result;

Places the following cartridge into the Result object. 
(for more information see the Prepare and BindColumn methods description);
Returns TRUE if succeeded, otherwise FALSE.
The following errors are possible:
	ERR_GET_DATA

OdbcStmt::Fetch(void)

Returns the following cartridge as a vector.
(for more information see the Prepare and BindColumn methods description);
Returns EMPTY in case of null data.
The following errors are possible:
	ERR_GET_DATA

OdbcStmt::GetColAttributes(int)

param ColNumber;

Returns an object of the SQLColumnAttr class that describes the 
column specified via the ColNumber parameter in the result set.
The ERR_DESCRIBE_COL error is possible.

OdbcStmt::GetColAttributes(int, int)

param ColNumber, Attribute;

Returns the value of the attribute specified via the Attribute 
parameter in the column specified via the ColNumber parameter 
of the result set.
Available values for the Attribute parameter include:
	SQL_COLUMN_AUTO_INCREMENT 
	SQL_COLUMN_CASE_SENSITIVE
	SQL_COLUMN_COUNT
	SQL_COLUMN_DISPLAY_SIZE
	SQL_COLUMN_LABEL
	SQL_COLUMN_LENGTH
	SQL_COLUMN_MONEY
	SQL_COLUMN_NAME
	SQL_COLUMN_NULLABLE
	SQL_COLUMN_OWNER_NAME
	SQL_COLUMN_PRECISION
	SQL_COLUMN_QUALIFIER_NAME
	SQL_COLUMN_SCALE
	SQL_COLUMN_SEARCHABLE
	SQL_COLUMN_TABLE_NAME
	SQL_COLUMN_TYPE
	SQL_COLUMN_TYPE_NAME
	SQL_COLUMN_UNSIGNED
	SQL_COLUMN_UPDATABLE
The return function value depends on the type of the attribute 
specified via the Attribute parameter.
(for more information see the ODBC standard description)
The ERR_DESCRIBE_COL error is possible.

OdbcStmt::GetCursorName(void)

Returns the cursor name.
	
The ERR_CURSORNAME error is possible.

OdbcStmt::GetData(int)

param ColNumb;

Returns the following value from the unbound column specified via 
the ColNumb parameter. 
(for more information see the Prepare method description);
The following errors are possible:
	ERR_DESCRIBE_COL
	ERR_GET_DATA

OdbcStmt::GetOption(int)

param OptionsCode;

Returns options for the executed operation. 
Available values for the OptionsCode parameter include:
	SQL_ASYNC_ENABLE
	SQL_BIND_TYPE
	SQL_CONCURRENCY
	SQL_CURSOR_TYPE
	SQL_KEYSET_SIZE
	SQL_MAX_LENGTH
	SQL_MAX_ROWS
	SQL_NOSCAN
	SQL_QUERY_TIMEOUT
	SQL_RETRIEVE_DATA
	SQL_ROWSET_SIZE
	SQL_SIMULATE_CURSOR
	SQL_USE_BOOKMARKS
(for more information see the ODBC standard description)
The ERR_OPTION error is raised in case of failure.

OdbcStmt::GetUnSerializeFlg(void)

This method returns the UnserializeFlg flag.
If the UnserializeFlg flag == TRUE then automatic 
reconstruction of objects serialized to the fields 
of BINARY, VARBINARY, LONGVARBINARY types is performed.
Otherwise automatic reconstruction of objects is not 
performed and read field contains the serialized string.
(for more information see the 
OdbcStmt::SetUnSerialize(boolean) method)

OdbcStmt::IsSync(void)

Returns TRUE if the object works in the in-sync mode, otherwise FALSE.

OdbcStmt::NumResultCols(void)

Returns the number of string as the result of the SELECT operation.
The ERR_NUM_RES_COLUMNS error is possible.

OdbcStmt::OdbcStmt(copy)

param Src;

This constructor creates an object in order to perform operations with 
the Data Source. 
A pointer to an object of the OdbcDs class is taken from the Src 
parameter to provide connection with the Data Source. 
The ERR_OPEN_STMT is raised in case of failure.

OdbcStmt::OdbcStmt(refer object OdbcDs)

param DataSource;

This constructor creates an object in order to perform operations with 
the Data Source. 
The DataSource parameter provides connection with the Data Source. 
The ERR_OPEN_STMT is raised in case of failure.

OdbcStmt::Prepare(refer object String)

param SQL_Query;

Performs preparation and execution of the SQL operator specified via 
the SQL_Query parameter bud does not perform result fetching.
In order to fetch results it is necessary to call either the pair of the 
	BindColumn and Fetch/ExtendedFetch methods
	or the GetData method
	or all of them together.
(for more information see the ODBC standard description)
Returns TRUE if succeeded.
In order to complete operation you should execute the 
Fetch/ExtendedFetch operations.
The following errors are possible:
	ERR_SQL_PARAMETERS
	ERR_SQL_SINTAX
	ERR_CONNECTION_BUSY
	ERR_EXECUTE

OdbcStmt::Prepare(refer object String, refer object Vector)

param SQL_Query, Parameters;

Performs preparation and execution of the SQL operator specified via 
the SQL_Query parameter bud does not perform result fetching.
The Parameters parameter represents the vector which is considered to 
be a set of parameters that consists of vector elements.
In order to fetch results it is necessary to call either the pair of the 
	BindColumn and Fetch/ExtendedFetch methods
	or the GetData method
	or all of them together.
(for more information see the ODBC standard description)
Returns TRUE if succeeded.
In order to complete operation you should execute the 
Fetch/ExtendedFetch operations.
The following errors are possible:
	ERR_SQL_PARAMETERS
	ERR_SQL_SINTAX
	ERR_CONNECTION_BUSY
	ERR_EXECUTE

OdbcStmt::RowCount(void)

Returns the number of string touched by the executed SQL operation 
(if applicable).
The ERR_ROW_COUNT error is possible.

OdbcStmt::SetCursorName(refer object String)

param CursorName;

Sets the cursor name according to the CursorName parameter.
The ERR_CURSORNAME error is possible.

OdbcStmt::SetOption(int, int)

param OptionsCode, Value;

Sets options for the executed operation. 
Available values for the OptionsCode parameter include:
	SQL_ASYNC_ENABLE
	SQL_BIND_TYPE
	SQL_CONCURRENCY
	SQL_CURSOR_TYPE
	SQL_KEYSET_SIZE
	SQL_MAX_LENGTH
	SQL_MAX_ROWS
	SQL_NOSCAN
	SQL_QUERY_TIMEOUT
	SQL_RETRIEVE_DATA
	SQL_ROWSET_SIZE
	SQL_SIMULATE_CURSOR
Available values of the Value parameter depend on the set option.
(for more information see the ODBC standard description)
The ERR_OPTION error is raised in case of failure.

OdbcStmt::SetPos(int, int, int)

param Row, Option, Lock;

Sets the cursor position in the result set and records lock type.
(for more information see the ODBC standard description)
Available values for the Option parameter include:
		SQL_POSITION
		SQL_REFRESH
		SQL_UPDATE
		SQL_DELETE
		SQL_ADD
Available values for the Lock parameter include:
		SQL_LOCK_NO_CHANGE
		SQL_LOCK_EXCLUSIVE
		SQL_LOCK_UNLOCK
The ERR_SETPOS error is possible.

OdbcStmt::SetUnSerializeFlg(boolean)

param UnserializeFlg;

If the UnserializeFlg parameter == TRUE then automatic 
reconstruction of objects serialized to the fields 
of BINARY, VARBINARY, LONGVARBINARY types is performed.
Otherwise automatic reconstruction of objects is not 
performed and read field contains the serialized string.

OdbcStmt::~OdbcStmt(void)

Releases all resources related to the operations 
that were performed via the object.
The ERR_CLOSE_STMT is raised in case of failure.

Class SQLColumnAttr

#module root.system.database
The SQLColumnAttr class is returned by the OdbcStmt::GetColAttributes 
method and contains the column attributes description in the resultant 
collection prepared by the OdbcStmt::Prepare method.
Class fields:
	Label			- caption;
	Qualifier		- qualifier name;
	Owner			- owner name;
	Table			- table name;
	Name			- column name;
	TypeName		- data type (as text);
	Type			- data type as SQL_ constant;
	Length		- data length;
	Precision		- precision;
	Scale			- scale;
	AutoIncrement	- specifies whether the field is an automatic 
				counter;
	CaseSensitive	- specifies whether information depends on 
letters size when compared;
	DisplaySize		- filed size on the screen necessary for 
information displaying;
	Money			- money sign;
	Nullable		- zeroing capability sign;
	Searchable		- ;
	Unsigned		- ;
	Updatable		- ;

Class SQLColumnDescr

#module root.system.database
The SQLColumnDescr class is returned by the OdbcStmt::DescribeCol 
method and contains the column description in the resultant 
collection prepared by the OdbcStmt::Prepare method.
Class fields:
		Name		- column name;
		DataType	- data type;
		Precision	- precision;
		Scale		- ;
		Nullable	- specifies whether not-initiated data is 
				allowed;

Class SQLColumnSpec : SQLColumnDescr

#module root.system.database
The SQLColumnSpec class is returned by the OdbcDs::GetColumns method 
and contains the description of the table column attributes.
Class fields:
		Name		- column name;
		DataType	- data type;
		Precision	- precision;
		Scale		- ;
		Nullable	- specifies whether not-initiated data is 
				allowed;
		TypeName	- data type in text representation;
		Length	- data length;
		Radix		- ;
		Remarks	- remarks;

Methods:

SQLColumnSpec::GetSQLDataType(void)

#rus Возвращает текст описания типа колонки таблицы

Class SQLIndex

#module root.system.database
The SQLIndex class is returned by the OdbcDs::GetIndexList method 
and contains the table indexes description.

Class SQLResult : Vector

#module root.system.database
The SQLResult class is designed for obtaining the result of the SELECT 
type SQL query.

Methods:

SQLResult::()(refer object String)

param ColName;

Returns index of the column whose name is specified via the ColName parameter.
Returns -1 if column is not found.

SQLResult::()(refer object String, int)

param ColName, Row;

Returns a pointer to the element which is located in the row specified 
via the Row parameter and in the column whose name is specified via 
the ColName parameter.

SQLResult::Cast(refer any, int)

param Data, index;

	Converts value contained in the Data parameter to the type that 
the SQLResult object in the field whose index is specified via the 
Index parameter has.

SQLResult::Cast(refer any, int, boolean)

param Data, index, Serialize;

	Converts value contained in the Data parameter to the type that 
the SQLResult object in the field whose index is specified via the 
Index parameter has.
If the Serialize parameter == TRUE then this method reserializes the 
serialized binary objects.

SQLResult::Cast(refer object Vector)

param Data;

	Converts values contained in the vector specified via the 
Data parameter to the type that the appropriate fields of the 
SQLResult object have.
The length of the vector specified via the Data parameter must be 
equal to the length of the ColName field.

SQLResult::Cast(refer object Vector, boolean)

param Data, Serialize;

	Converts values contained in the vector specified via the 
Data parameter to the type that the appropriate fields of the 
SQLResult object have.
The length of the vector specified via the Data parameter must be 
equal to the length of the ColName field.
If the Serialize parameter == TRUE then this method reserializes the 
serialized binary objects.

SQLResult::GetType(refer object String)

param ColName;

Returns type of the column whose name is specified via the ColName parameter.
	The type represents a constant from the following group:
		SQL_CHAR
		SQL_NUMERIC
		SQL_DECIMAL
		SQL_INTEGER
		SQL_SMALLINT
		SQL_FLOAT
		SQL_REAL
		SQL_DOUBLE
		SQL_DATE
		SQL_TIME
		SQL_TIMESTAMP
		SQL_VARCHAR
		SQL_LONGVARCHAR
		SQL_BINARY
		SQL_VARBINARY
		SQL_LONGVARBINARY
		SQL_BIGINT
		SQL_TINYINT
		SQL_BIT

SQLResult::InsertInToTable(refer object String, refer object OdbcDs, ...)

param TableName, Ds, [UseProgress];

Inserts the object contents to the table specified via the TableName 
parameter together with invoking the GProgressWnd dialog if the 
UseProgress parameter is omitted or != FALSE

SQLResult::PrintField(int, int)

param ColumnIndex, RowIndex;

	Returns the field contents in the printed type.

SQLResult::PrintField(refer object String, int)

param ColumnName, RowIndex;

	Returns the field contents in the printed type.

SQLResult::SQLResult(int)

param Numb;

This constructor creates the SQLResult object for the number of 
columns specified via the Numb parameter.

SQLResult::UpdateTable(refer object String, refer object OdbcDs, refer object Vector, ...)

param TableName, Ds, KeyClnNames, [UseProgress];

Updates data in the table specified via the TableName parameter using 
the object contents together with invoking the GProgressWnd dialog if 
the UseProgress parameter is omitted or != FALSE
The KeyClnNames vector contains the list of names which is used to 
determine which table rows should be updated.

SQLResult::_InsertInToTable(refer object String, refer object OdbcDs)

param TableName, Ds;

Inserts the object contents to the table specified via the TableName 
parameter

SQLResult::_UpdateTable(refer object String, refer object OdbcDs, refer object Vector, ...)

param TableName, Ds, KeyClnNames, [UseProgress];

Updates data in the table specified via the TableName parameter using 
the object contents together with invoking the GProgressWnd dialog if 
the UseProgress parameter is omitted or != FALSE
The KeyClnNames vector contains the list of names which is used to 
determine which table rows should be updated.

Class SQLSpecColumn

#module root.system.database
The SQLSpecColumn class is returned by the OdbcDs::GetSpecialColumns method
and contains the description of table system columns.
Class fields:
	Scope;
	ColumnName		- column name;
	DataType		- data type;
	TypeName		- data type name;
	Precision		- precision;
	Length		- data length;
	Scale;
	PseudoColumn;

Class SQLStatistic

#module root.system.database
The SQLStatistic class is returned by the OdbcDs::GetStatistic method 
and contains the table statistics description.
Class fields:
	TableQualifier;
	TableOwner;
	TableName;
	NonUnique;
	IndexQualifier;
	IndexName;
	Type;
	SeqInIndex;
	ColumnName;
	Collation;
	Cardinality;
	Pages;
	FilterCondition;

Class SQLTableForeignKeys

#module root.system.database
The SQLTableForeignKeys class is returned by the 
OdbcDs::GetForeignKeys method and contains 
the table external keys description.
Class fields:
	PkQualifier	- qualifier name of the table to which the reference 
			is performed;
	PkOwner	- owner name of the table to which the reference 
			is performed;
	PkName	- name of the table to which the reference 
			is performed;
	PkColumnName- name of the column to which the reference 
			is performed;
	FkQualifier	- table qualifier name;
	FkOwner	- table owner name;
	FkName	- table name;
	FkColumnName- column name;
	ColumnSeq;
	UpdateRule	- key update rule;
	DeleteRule	- bound records deletion rule;
	PkKeyName	- key name in the table to which the reference 
			is performed;
	FkKeyName	- external key name;

Class SQLTablePrimaryKeys

#module root.system.database
The SQLTablePrimaryKeys class is returned by the 
OdbcDs::GetPrimaryKeys methods and contains 
the table primary keys description.
Class fields:
	Qualifier 	- qualifier name;
	Owner 	- owner name;
	Name 		- table name;
	ColumnName	- column name;
	ColumnSeq	- ;
	KeyName	- key name;

Class SQLTablePrivelege

#module root.system.database
The SQLTablePrivelege class is returned by the 
OdbcDs::GetTablePrivelegesList method and contains 
the table privilege description.
Class fields:
	Qualifier 	- qualifier name;
	Owner 	- owner name;
	Name 		- table name;
	Grantor	- name of the privilege granter;
	Grantee	- name of the privilege grantee;
	Privileges	- privilege name;
	IsGrantable	- specifies whether this privilege can be granted to 
the third side;

Class SQLTableSpec

#module root.system.database
The SQLTableSpec class is returned by the OdbcDs::GetTablesList method 
and contains the table description.
Class fields:
	Qualifier 	- qualifier name;
	Owner 	- owner name;
	Name 		- table name;
	Type		- table type;
	Remarks	- remarks;
	ColumnList	- vector of specifications of the SQLColumnSpec 
class columns;

Class SQLTypeSpec

#module root.system.database
The SQLTypeSpec class is returned by the OdbcDs::GetTypeInfo method
and contains the description of the implementation of the appropriate 
SQL_ type by a specific data source.
Class fields:
	TypeName		- data type name (string);
	DataType		- data type (number);
	Precision		- precision;
	LiteralPrefix;
	LiteralSuffix;
	CreateParams;
	Nullable;
	CaseSensitive;
	Searchable;
	UnsignedArribute;
	Money;
	AutoIncriment;
	LocalTypeName;
	MiminumScale;
	MaximumScale;

SQLCast(int, refer any, ...)

param Type, Data, [Serialize];

Converts value contained in the Data parameter to the type specified 
via the Type parameter.
If the Serialize parameter == TRUE then this method reserializes the 
serialized binary objects.

SQLCastVector(refer object Vector, refer object Vector, ...)

param Types, Data, [Serialize];

	Converts values contained in the vector specified via the 
Data parameter to the type that the appropriate fields of the vector 
specified via the Types parameter have.
The length of the vector specified via the Data parameter must be 
equal to the length of the vector specified via the Types parameter.
If the Serialize parameter == TRUE then this method reserializes the 
serialized binary objects.

Index: