Unit odbcsqldyn

Description

Classes, Interfaces, Objects and Records

Functions and Procedures

Types

Constants

Variables

Description

This item has no description.

Overview

Classes, Interfaces, Objects and Records

Name	Description
Packed Record `SQL_DATE_STRUCT`
Packed Record `SQL_TIME_STRUCT`
Packed Record `SQL_TIMESTAMP_STRUCT`

Functions and Procedures

procedure initializeodbc(const sonames: array of filenamety);

procedure releaseodbc;

function DateStructToDateTime( b:PSQL_DATE_STRUCT):TDateTime;

function DateTimeToDateStruct( b:TDateTime):SQL_DATE_STRUCT;

procedure DateTime2TimeStampStruct( var Value:SQL_TIMESTAMP_STRUCT; b:TDateTime);

Function TimeStampStructToDateTime( B : PSQL_TIMESTAMP_STRUCT) : TDateTime;

Function TimeStructToDateTime(B : PSQL_TIME_STRUCT) : TDateTime;

Types

SQLCHAR = char;

SQLSMALLINT = csshort;

SQLUSMALLINT = cushort;

SQLRETURN = SQLSMALLINT;

SQLHANDLE = pointer;

SQLHENV = SQLHANDLE;

SQLHDBC = SQLHANDLE;

SQLHSTMT = SQLHANDLE;

SQLHDESC = SQLHANDLE;

SQLINTEGER = clong;

SQLUINTEGER = culong;

SQLLEN = ptrint;

SQLULEN = ptruint;

SQLSETPOSIROW = SQLUSMALLINT;

SQLPOINTER = pointer;

SQLREAL = cfloat;

SQLDOUBLE = cdouble;

SQLFLOAT = cdouble;

SQLHWND = pointer;

PSQLCHAR = PChar;

PSQLINTEGER = ˆSQLINTEGER;

PSQLUINTEGER = ˆSQLUINTEGER;

PSQLLEN = ˆSQLLEN;

PSQLULEN = ˆSQLULEN;

PSQLSMALLINT = ˆSQLSMALLINT;

PSQLUSMALLINT = ˆSQLUSMALLINT;

PSQLREAL = ˆSQLREAL;

PSQLDOUBLE = ˆSQLDOUBLE;

PSQLFLOAT = ˆSQLFLOAT;

PSQLHANDLE = ˆSQLHANDLE;

PSQL_DATE_STRUCT = ˆSQL_DATE_STRUCT;

PSQL_TIME_STRUCT = ˆSQL_TIME_STRUCT;

PSQL_TIMESTAMP_STRUCT = ˆSQL_TIMESTAMP_STRUCT;

Constants

odbclib: array[0..2] of filenamety = ('libodbc.so.2','libodbc.so.1',
                                                               'libodbc.so');

SQL_UNKNOWN_TYPE = 0;

SQL_LONGVARCHAR =(-1);

SQL_BINARY =(-2);

SQL_VARBINARY =(-3);

SQL_LONGVARBINARY =(-4);

SQL_BIGINT =(-5);

SQL_TINYINT =(-6);

SQL_BIT =(-7);

SQL_WCHAR =(-8);

SQL_WVARCHAR =(-9);

SQL_WLONGVARCHAR =(-10);

SQL_CHAR = 1;

SQL_NUMERIC = 2;

SQL_DECIMAL = 3;

SQL_INTEGER = 4;

SQL_SMALLINT = 5;

SQL_FLOAT = 6;

SQL_REAL = 7;

SQL_DOUBLE = 8;

SQL_DATETIME = 9;

SQL_VARCHAR = 12;

SQL_TYPE_DATE = 91;

SQL_TYPE_TIME = 92;

SQL_TYPE_TIMESTAMP= 93;

SQL_DATE = 9;

SQL_TIME = 10;

SQL_TIMESTAMP = 11;

SQL_INTERVAL = 10;

SQL_GUID = -11;

SQL_CODE_YEAR = 1;

SQL_CODE_MONTH = 2;

SQL_CODE_DAY = 3;

SQL_CODE_HOUR = 4;

SQL_CODE_MINUTE = 5;

SQL_CODE_SECOND = 6;

SQL_CODE_YEAR_TO_MONTH = 7;

SQL_CODE_DAY_TO_HOUR = 8;

SQL_CODE_DAY_TO_MINUTE = 9;

SQL_CODE_DAY_TO_SECOND = 10;

SQL_CODE_HOUR_TO_MINUTE = 11;

SQL_CODE_HOUR_TO_SECOND = 12;

SQL_CODE_MINUTE_TO_SECOND = 13;

SQL_INTERVAL_YEAR = 100 + SQL_CODE_YEAR;

SQL_INTERVAL_MONTH = 100 + SQL_CODE_MONTH;

SQL_INTERVAL_DAY = 100 + SQL_CODE_DAY;

SQL_INTERVAL_HOUR = 100 + SQL_CODE_HOUR;

SQL_INTERVAL_MINUTE = 100 + SQL_CODE_MINUTE;

SQL_INTERVAL_SECOND = 100 + SQL_CODE_SECOND;

SQL_INTERVAL_YEAR_TO_MONTH = 100 + SQL_CODE_YEAR_TO_MONTH;

SQL_INTERVAL_DAY_TO_HOUR = 100 + SQL_CODE_DAY_TO_HOUR;

SQL_INTERVAL_DAY_TO_MINUTE = 100 + SQL_CODE_DAY_TO_MINUTE;

SQL_INTERVAL_DAY_TO_SECOND = 100 + SQL_CODE_DAY_TO_SECOND;

SQL_INTERVAL_HOUR_TO_MINUTE = 100 + SQL_CODE_HOUR_TO_MINUTE;

SQL_INTERVAL_HOUR_TO_SECOND = 100 + SQL_CODE_HOUR_TO_SECOND;

SQL_INTERVAL_MINUTE_TO_SECOND = 100 + SQL_CODE_MINUTE_TO_SECOND;

SQL_UNICODE = SQL_WCHAR;

SQL_UNICODE_VARCHAR = SQL_WVARCHAR;

SQL_UNICODE_LONGVARCHAR = SQL_WLONGVARCHAR;

SQL_UNICODE_CHAR = SQL_WCHAR;

SQL_C_CHAR = SQL_CHAR;

SQL_C_WCHAR = SQL_WCHAR;

SQL_C_LONG = SQL_INTEGER;

SQL_C_SHORT = SQL_SMALLINT;

SQL_C_FLOAT = SQL_REAL;

SQL_C_DOUBLE = SQL_DOUBLE;

SQL_C_NUMERIC = SQL_NUMERIC;

SQL_C_DEFAULT = 99;

SQL_SIGNED_OFFSET = -20;

SQL_UNSIGNED_OFFSET = -22;

SQL_C_DATE = SQL_DATE;

SQL_C_TIME = SQL_TIME;

SQL_C_TIMESTAMP = SQL_TIMESTAMP;

SQL_C_TYPE_DATE = SQL_TYPE_DATE;

SQL_C_TYPE_TIME = SQL_TYPE_TIME;

SQL_C_TYPE_TIMESTAMP = SQL_TYPE_TIMESTAMP;

SQL_C_INTERVAL_YEAR = SQL_INTERVAL_YEAR;

SQL_C_INTERVAL_MONTH = SQL_INTERVAL_MONTH;

SQL_C_INTERVAL_DAY = SQL_INTERVAL_DAY;

SQL_C_INTERVAL_HOUR = SQL_INTERVAL_HOUR;

SQL_C_INTERVAL_MINUTE = SQL_INTERVAL_MINUTE;

SQL_C_INTERVAL_SECOND = SQL_INTERVAL_SECOND;

SQL_C_INTERVAL_YEAR_TO_MONTH = SQL_INTERVAL_YEAR_TO_MONTH;

SQL_C_INTERVAL_DAY_TO_HOUR = SQL_INTERVAL_DAY_TO_HOUR;

SQL_C_INTERVAL_DAY_TO_MINUTE = SQL_INTERVAL_DAY_TO_MINUTE;

SQL_C_INTERVAL_DAY_TO_SECOND = SQL_INTERVAL_DAY_TO_SECOND;

SQL_C_INTERVAL_HOUR_TO_MINUTE = SQL_INTERVAL_HOUR_TO_MINUTE;

SQL_C_INTERVAL_HOUR_TO_SECOND = SQL_INTERVAL_HOUR_TO_SECOND;

SQL_C_INTERVAL_MINUTE_TO_SECOND = SQL_INTERVAL_MINUTE_TO_SECOND;

SQL_C_BINARY = SQL_BINARY;

SQL_C_BIT = SQL_BIT;

SQL_C_SBIGINT = SQL_BIGINT+SQL_SIGNED_OFFSET;

SQL_C_UBIGINT = SQL_BIGINT+SQL_UNSIGNED_OFFSET;

SQL_C_TINYINT = SQL_TINYINT;

SQL_C_SLONG = SQL_C_LONG +SQL_SIGNED_OFFSET;

SQL_C_SSHORT = SQL_C_SHORT+SQL_SIGNED_OFFSET;

SQL_C_STINYINT = SQL_TINYINT+SQL_SIGNED_OFFSET;

SQL_C_ULONG = SQL_C_LONG +SQL_UNSIGNED_OFFSET;

SQL_C_USHORT = SQL_C_SHORT+SQL_UNSIGNED_OFFSET;

SQL_C_UTINYINT = SQL_TINYINT+SQL_UNSIGNED_OFFSET;

SQL_C_BOOKMARK = SQL_C_ULONG;

SQL_C_GUID = SQL_GUID;

SQL_TYPE_NULL = 0;

SQL_C_VARBOOKMARK = SQL_C_BINARY;

SQL_API_SQLDESCRIBEPARAM=58;

SQL_NO_TOTAL = -4;

SQL_NAME_LEN = 128;

SQL_OV_ODBC3 = 3;

SQL_OV_ODBC2 = 2;

SQL_ATTR_ODBC_VERSION = 200;

SQL_DRIVER_NOPROMPT = 0;

SQL_DRIVER_COMPLETE = 1;

SQL_DRIVER_PROMPT = 2;

SQL_DRIVER_COMPLETE_REQUIRED = 3;

SQL_IS_POINTER = (-4);

SQL_IS_UINTEGER = (-5);

SQL_IS_INTEGER = (-6);

SQL_IS_USMALLINT = (-7);

SQL_IS_SMALLINT = (-8);

SQL_FETCH_BOOKMARK = 8;

SQL_SCROLL_OPTIONS = 44;

SQL_UB_OFF = 0;

SQL_UB_ON = 1;

SQL_UB_DEFAULT = SQL_UB_OFF;

SQL_UB_FIXED = SQL_UB_ON;

SQL_UB_VARIABLE = 2;

SQL_SO_FORWARD_ONLY = $01;

SQL_SO_KEYSET_DRIVEN = $02;

SQL_SO_DYNAMIC = $04;

SQL_SO_MIXED = $08;

SQL_SO_STATIC = $10;

SQL_BOOKMARK_PERSISTENCE = 82;

SQL_STATIC_SENSITIVITY = 83;

SQL_BP_CLOSE = $01;

SQL_BP_DELETE = $02;

SQL_BP_DROP = $04;

SQL_BP_TRANSACTION = $08;

SQL_BP_UPDATE = $10;

SQL_BP_OTHER_HSTMT = $20;

SQL_BP_SCROLL = $40;

SQL_DYNAMIC_CURSOR_ATTRIBUTES1 = 144;

SQL_DYNAMIC_CURSOR_ATTRIBUTES2 = 145;

SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 = 146;

SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 = 147;

SQL_INDEX_KEYWORDS = 148;

SQL_INFO_SCHEMA_VIEWS = 149;

SQL_KEYSET_CURSOR_ATTRIBUTES1 = 150;

SQL_KEYSET_CURSOR_ATTRIBUTES2 = 151;

SQL_STATIC_CURSOR_ATTRIBUTES1 = 167;

SQL_STATIC_CURSOR_ATTRIBUTES2 = 168;

SQL_CA1_NEXT = 1;

SQL_CA1_ABSOLUTE = 2;

SQL_CA1_RELATIVE = 4;

SQL_CA1_BOOKMARK = 8;

SQL_CA1_LOCK_NO_CHANGE= $40;

SQL_CA1_LOCK_EXCLUSIVE= $80;

SQL_CA1_LOCK_UNLOCK =$100;

SQL_CA1_POS_POSITION = $200;

SQL_CA1_POS_UPDATE = $400;

SQL_CA1_POS_DELETE = $800;

SQL_CA1_POS_REFRESH =$1000;

SQL_CA1_POSITIONED_UPDATE=$2000;

SQL_CA1_POSITIONED_DELETE=$4000;

SQL_CA1_SELECT_FOR_UPDATE=$8000;

SQL_CA1_BULK_ADD =$10000;

SQL_CA1_BULK_UPDATE_BY_BOOKMARK =$20000;

SQL_CA1_BULK_DELETE_BY_BOOKMARK =$40000;

SQL_CA1_BULK_FETCH_BY_BOOKMARK =$80000;

SQL_CA2_READ_ONLY_CONCURRENCY = 1;

SQL_CA2_LOCK_CONCURRENCY = 2;

SQL_CA2_OPT_ROWVER_CONCURRENCY= 4;

SQL_CA2_OPT_VALUES_CONCURRENCY= 8;

SQL_CA2_SENSITIVITY_ADDITIONS =$10;

SQL_CA2_SENSITIVITY_DELETIONS =$20;

SQL_CA2_SENSITIVITY_UPDATES =$40;

SQL_CA2_MAX_ROWS_SELECT = $80;

SQL_CA2_MAX_ROWS_INSERT =$100;

SQL_CA2_MAX_ROWS_DELETE =$200;

SQL_CA2_MAX_ROWS_UPDATE =$400;

SQL_CA2_MAX_ROWS_CATALOG =$800;

SQL_CA2_MAX_ROWS_AFFECTS_ALL  =(SQL_CA2_MAX_ROWS_SELECT or
                                        SQL_CA2_MAX_ROWS_INSERT or SQL_CA2_MAX_ROWS_DELETE or
                                        SQL_CA2_MAX_ROWS_UPDATE or SQL_CA2_MAX_ROWS_CATALOG);

SQL_CA2_CRC_EXACT = $1000;

SQL_CA2_CRC_APPROXIMATE = $2000;

SQL_CA2_SIMULATE_NON_UNIQUE = $4000;

SQL_CA2_SIMULATE_TRY_UNIQUE = $8000;

SQL_CA2_SIMULATE_UNIQUE =$10000;

SQL_ADD = 4;

SQL_SETPOS_MAX_OPTION_VALUE = SQL_ADD;

SQL_UPDATE_BY_BOOKMARK = 5;

SQL_DELETE_BY_BOOKMARK = 6;

SQL_FETCH_BY_BOOKMARK = 7;

SQL_POSITION = 0;

SQL_REFRESH = 1;

SQL_UPDATE = 2;

SQL_DELETE = 3;

SQL_LOCK_NO_CHANGE = 0;

SQL_LOCK_EXCLUSIVE = 1;

SQL_LOCK_UNLOCK = 2;

SQL_ROW_SUCCESS = 0;

SQL_ROW_DELETED = 1;

SQL_ROW_UPDATED = 2;

SQL_ROW_NOROW = 3;

SQL_ROW_ADDED = 4;

SQL_ROW_ERROR = 5;

SQL_ROW_SUCCESS_WITH_INFO = 6;

SQL_ROW_PROCEED = 0;

SQL_ROW_IGNORE = 1;

SQL_MAX_DSN_LENGTH = 32;

SQL_MAX_OPTION_STRING_LENGTH = 256;

SQL_ODBC_CURSORS = 110;

SQL_ATTR_ODBC_CURSORS = SQL_ODBC_CURSORS;

SQL_CUR_USE_IF_NEEDED = 0;

SQL_CUR_USE_ODBC = 1;

SQL_CUR_USE_DRIVER = 2;

SQL_CUR_DEFAULT = SQL_CUR_USE_DRIVER;

SQL_PARAM_TYPE_UNKNOWN = 0;

SQL_PARAM_INPUT = 1;

SQL_PARAM_INPUT_OUTPUT = 2;

SQL_RESULT_COL = 3;

SQL_PARAM_OUTPUT = 4;

SQL_RETURN_VALUE = 5;

SQL_NULL_DATA = (-1);

SQL_DATA_AT_EXEC = (-2);

SQL_SUCCESS = 0;

SQL_SUCCESS_WITH_INFO = 1;

SQL_NO_DATA = 100;

SQL_ERROR = (-1);

SQL_INVALID_HANDLE = (-2);

SQL_STILL_EXECUTING = 2;

SQL_NEED_DATA = 99;

SQL_NTS = (-3);

SQL_MAX_MESSAGE_LENGTH = 512;

SQL_DATE_LEN = 10;

SQL_TIME_LEN = 8;

SQL_TIMESTAMP_LEN = 19;

SQL_HANDLE_ENV = 1;

SQL_HANDLE_DBC = 2;

SQL_HANDLE_STMT = 3;

SQL_HANDLE_DESC = 4;

SQL_ATTR_OUTPUT_NTS = 10001;

SQL_ATTR_AUTO_IPD = 10001;

SQL_ATTR_METADATA_ID = 10014;

SQL_ATTR_APP_ROW_DESC = 10010;

SQL_ATTR_APP_PARAM_DESC = 10011;

SQL_ATTR_IMP_ROW_DESC = 10012;

SQL_ATTR_IMP_PARAM_DESC = 10013;

SQL_ATTR_CURSOR_SCROLLABLE = (-1);

SQL_ATTR_CURSOR_SENSITIVITY = (-2);

SQL_QUERY_TIMEOUT =0;

SQL_MAX_ROWS =1;

SQL_NOSCAN =2;

SQL_MAX_LENGTH =3;

SQL_ASYNC_ENABLE =4;

SQL_BIND_TYPE =5;

SQL_CURSOR_TYPE = 6;

SQL_CONCURRENCY = 7;

SQL_KEYSET_SIZE =8;

SQL_ROWSET_SIZE =9;

SQL_SIMULATE_CURSOR =10;

SQL_RETRIEVE_DATA =11;

SQL_USE_BOOKMARKS =12;

SQL_GET_BOOKMARK =13;

SQL_ROW_NUMBER = 14;

SQL_ATTR_CURSOR_TYPE = SQL_CURSOR_TYPE;

SQL_ATTR_CONCURRENCY = SQL_CONCURRENCY;

SQL_ATTR_FETCH_BOOKMARK_PTR = 16;

SQL_ATTR_ROW_STATUS_PTR = 25;

SQL_ATTR_ROWS_FETCHED_PTR = 26;

SQL_AUTOCOMMIT = 102;

SQL_ATTR_AUTOCOMMIT = SQL_AUTOCOMMIT;

SQL_ATTR_ROW_NUMBER = SQL_ROW_NUMBER;

SQL_TXN_ISOLATION = 108;

SQL_ATTR_TXN_ISOLATION = SQL_TXN_ISOLATION;

SQL_ATTR_MAX_ROWS = SQL_MAX_ROWS;

SQL_ATTR_USE_BOOKMARKS = SQL_USE_BOOKMARKS;

SQL_ACCESS_MODE =101;

SQL_LOGIN_TIMEOUT =103;

SQL_OPT_TRACE =104;

SQL_OPT_TRACEFILE =105;

SQL_TRANSLATE_DLL =106;

SQL_TRANSLATE_OPTION =107;

SQL_CURRENT_QUALIFIER =109;

SQL_QUIET_MODE =111;

SQL_PACKET_SIZE =112;

SQL_ATTR_ACCESS_MODE =SQL_ACCESS_MODE;

SQL_ATTR_CONNECTION_DEAD =1209;

SQL_ATTR_CONNECTION_TIMEOUT =113;

SQL_ATTR_CURRENT_CATALOG =SQL_CURRENT_QUALIFIER;

SQL_ATTR_DISCONNECT_BEHAVIOR=114;

SQL_ATTR_ENLIST_IN_DTC =1207;

SQL_ATTR_ENLIST_IN_XA =1208;

SQL_ATTR_LOGIN_TIMEOUT =SQL_LOGIN_TIMEOUT;

SQL_ATTR_PACKET_SIZE =SQL_PACKET_SIZE;

SQL_ATTR_QUIET_MODE =SQL_QUIET_MODE;

SQL_ATTR_TRACE =SQL_OPT_TRACE;

SQL_ATTR_TRACEFILE =SQL_OPT_TRACEFILE;

SQL_ATTR_TRANSLATE_LIB =SQL_TRANSLATE_DLL;

SQL_ATTR_TRANSLATE_OPTION =SQL_TRANSLATE_OPTION;

SQL_MODE_READ_WRITE =0;

SQL_MODE_READ_ONLY =1;

SQL_MODE_DEFAULT =SQL_MODE_READ_WRITE;

SQL_AUTOCOMMIT_OFF = 0;

SQL_AUTOCOMMIT_ON = 1;

SQL_AUTOCOMMIT_DEFAULT = SQL_AUTOCOMMIT_ON;

SQL_NONSCROLLABLE = 0;

SQL_SCROLLABLE = 1;

SQL_CURSOR_FORWARD_ONLY = 0;

SQL_CURSOR_KEYSET_DRIVEN = 1;

SQL_CURSOR_DYNAMIC = 2;

SQL_CURSOR_STATIC = 3;

SQL_CURSOR_TYPE_DEFAULT = SQL_CURSOR_FORWARD_ONLY;

SQL_CONCUR_READ_ONLY = 1;

SQL_CONCUR_LOCK = 2;

SQL_CONCUR_ROWVER = 3;

SQL_CONCUR_VALUES = 4;

SQL_CONCUR_DEFAULT = SQL_CONCUR_READ_ONLY;

SQL_DESC_COUNT = 1001;

SQL_DESC_TYPE = 1002;

SQL_DESC_LENGTH = 1003;

SQL_DESC_OCTET_LENGTH_PTR = 1004;

SQL_DESC_PRECISION = 1005;

SQL_DESC_SCALE = 1006;

SQL_DESC_DATETIME_INTERVAL_CODE = 1007;

SQL_DESC_NULLABLE = 1008;

SQL_DESC_INDICATOR_PTR = 1009;

SQL_DESC_DATA_PTR = 1010;

SQL_DESC_NAME = 1011;

SQL_DESC_UNNAMED = 1012;

SQL_DESC_OCTET_LENGTH = 1013;

SQL_DESC_ALLOC_TYPE = 1099;

SQL_DIAG_RETURNCODE = 1;

SQL_DIAG_NUMBER = 2;

SQL_DIAG_ROW_COUNT = 3;

SQL_DIAG_SQLSTATE = 4;

SQL_DIAG_NATIVE = 5;

SQL_DIAG_MESSAGE_TEXT = 6;

SQL_DIAG_DYNAMIC_FUNCTION = 7;

SQL_DIAG_CLASS_ORIGIN = 8;

SQL_DIAG_SUBCLASS_ORIGIN = 9;

SQL_DIAG_CONNECTION_NAME = 10;

SQL_DIAG_SERVER_NAME = 11;

SQL_DIAG_DYNAMIC_FUNCTION_CODE = 12;

SQL_DIAG_ALTER_TABLE = 4;

SQL_DIAG_CREATE_INDEX = (-1);

SQL_DIAG_CREATE_TABLE = 77;

SQL_DIAG_CREATE_VIEW = 84;

SQL_DIAG_DELETE_WHERE = 19;

SQL_DIAG_DROP_INDEX = (-2);

SQL_DIAG_DROP_TABLE = 32;

SQL_DIAG_DROP_VIEW = 36;

SQL_DIAG_DYNAMIC_DELETE_CURSOR = 38;

SQL_DIAG_DYNAMIC_UPDATE_CURSOR = 81;

SQL_DIAG_GRANT = 48;

SQL_DIAG_INSERT = 50;

SQL_DIAG_REVOKE = 59;

SQL_DIAG_SELECT_CURSOR = 85;

SQL_DIAG_UNKNOWN_STATEMENT = 0;

SQL_DIAG_UPDATE_WHERE = 82;

SQL_DIAG_CURSOR_ROW_COUNT = -1249;

SQL_UNSPECIFIED = 0;

SQL_INSENSITIVE = 1;

SQL_SENSITIVE = 2;

SQL_ALL_TYPES = 0;

SQL_DEFAULT = 99;

SQL_ARD_TYPE = (-99);

SQL_CODE_DATE = 1;

SQL_CODE_TIME = 2;

SQL_CODE_TIMESTAMP = 3;

SQL_FALSE = 0;

SQL_TRUE = 1;

SQL_NO_NULLS = 0;

SQL_NULLABLE = 1;

SQL_NULLABLE_UNKNOWN = 2;

SQL_CLOSE = 0;

SQL_DROP = 1;

SQL_UNBIND = 2;

SQL_RESET_PARAMS = 3;

SQL_FETCH_NEXT = 1;

SQL_FETCH_FIRST = 2;

SQL_FETCH_FIRST_USER = 31;

SQL_FETCH_FIRST_SYSTEM = 32;

SQL_FETCH_LAST = 3;

SQL_FETCH_PRIOR = 4;

SQL_FETCH_ABSOLUTE = 5;

SQL_FETCH_RELATIVE = 6;

SQL_NULL_HENV = SQLHENV(0);

SQL_NULL_HDBC = SQLHDBC(0);

SQL_NULL_HSTMT = SQLHSTMT(0);

SQL_NULL_HDESC = SQLHDESC(0);

SQL_NULL_HANDLE = SQLHANDLE(0);

SQL_SCOPE_CURROW = 0;

SQL_SCOPE_TRANSACTION = 1;

SQL_SCOPE_SESSION = 2;

SQL_BEST_ROWID = 1;

SQL_ROWVER = 2;

SQL_ROW_IDENTIFIER = 1;

SQL_INDEX_UNIQUE = 0;

SQL_INDEX_ALL = 1;

SQL_QUICK = 0;

SQL_ENSURE = 1;

SQL_TABLE_STAT = 0;

SQL_INDEX_CLUSTERED = 1;

SQL_INDEX_HASHED = 2;

SQL_INDEX_OTHER = 3;

SQL_SCROLL_CONCURRENCY = 43;

SQL_TXN_CAPABLE = 46;

SQL_TRANSACTION_CAPABLE = SQL_TXN_CAPABLE;

SQL_USER_NAME = 47;

SQL_TXN_ISOLATION_OPTION = 72;

SQL_TRANSACTION_ISOLATION_OPTION = SQL_TXN_ISOLATION_OPTION;

SQL_OJ_CAPABILITIES = 115;

SQL_OUTER_JOIN_CAPABILITIES = SQL_OJ_CAPABILITIES;

SQL_XOPEN_CLI_YEAR = 10000;

SQL_CURSOR_SENSITIVITY = 10001;

SQL_DESCRIBE_PARAMETER = 10002;

SQL_CATALOG_NAME = 10003;

SQL_COLLATION_SEQ = 10004;

SQL_MAX_IDENTIFIER_LEN = 10005;

SQL_MAXIMUM_IDENTIFIER_LENGTH = SQL_MAX_IDENTIFIER_LEN;

SQL_SCCO_READ_ONLY = 1;

SQL_SCCO_LOCK = 2;

SQL_SCCO_OPT_ROWVER = 4;

SQL_SCCO_OPT_VALUES = 8;

SQL_TC_NONE = 0;

SQL_TC_DML = 1;

SQL_TC_ALL = 2;

SQL_TC_DDL_COMMIT = 3;

SQL_TC_DDL_IGNORE = 4;

SQL_TXN_READ_UNCOMMITTED = 1;

SQL_TRANSACTION_READ_UNCOMMITTED = SQL_TXN_READ_UNCOMMITTED;

SQL_TXN_READ_COMMITTED = 2;

SQL_TRANSACTION_READ_COMMITTED = SQL_TXN_READ_COMMITTED;

SQL_TXN_REPEATABLE_READ = 4;

SQL_TRANSACTION_REPEATABLE_READ = SQL_TXN_REPEATABLE_READ;

SQL_TXN_SERIALIZABLE = 8;

SQL_TRANSACTION_SERIALIZABLE = SQL_TXN_SERIALIZABLE;

SQL_SS_ADDITIONS = 1;

SQL_SS_DELETIONS = 2;

SQL_SS_UPDATES = 4;

SQL_COLUMN_COUNT = 0;

SQL_COLUMN_NAME = 1;

SQL_COLUMN_TYPE = 2;

SQL_COLUMN_LENGTH = 3;

SQL_COLUMN_PRECISION = 4;

SQL_COLUMN_SCALE = 5;

SQL_COLUMN_DISPLAY_SIZE = 6;

SQL_COLUMN_NULLABLE = 7;

SQL_COLUMN_UNSIGNED = 8;

SQL_COLUMN_MONEY = 9;

SQL_COLUMN_UPDATABLE = 10;

SQL_COLUMN_AUTO_INCREMENT = 11;

SQL_COLUMN_CASE_SENSITIVE = 12;

SQL_COLUMN_SEARCHABLE = 13;

SQL_COLUMN_TYPE_NAME = 14;

SQL_COLUMN_TABLE_NAME = 15;

SQL_COLUMN_OWNER_NAME = 16;

SQL_COLUMN_QUALIFIER_NAME = 17;

SQL_COLUMN_LABEL = 18;

SQL_COLATT_OPT_MAX = SQL_COLUMN_LABEL;

SQL_COLUMN_DRIVER_START = 1000;

SQL_DESC_ARRAY_SIZE = 20;

SQL_DESC_ARRAY_STATUS_PTR = 21;

SQL_DESC_AUTO_UNIQUE_VALUE = SQL_COLUMN_AUTO_INCREMENT;

SQL_DESC_BASE_COLUMN_NAME = 22;

SQL_DESC_BASE_TABLE_NAME = 23;

SQL_DESC_BIND_OFFSET_PTR = 24;

SQL_DESC_BIND_TYPE = 25;

SQL_DESC_CASE_SENSITIVE = SQL_COLUMN_CASE_SENSITIVE;

SQL_DESC_CATALOG_NAME = SQL_COLUMN_QUALIFIER_NAME;

SQL_DESC_CONCISE_TYPE = SQL_COLUMN_TYPE;

SQL_DESC_DATETIME_INTERVAL_PRECISION = 26;

SQL_DESC_DISPLAY_SIZE = SQL_COLUMN_DISPLAY_SIZE;

SQL_DESC_FIXED_PREC_SCALE = SQL_COLUMN_MONEY;

SQL_DESC_LABEL = SQL_COLUMN_LABEL;

SQL_DESC_LITERAL_PREFIX = 27;

SQL_DESC_LITERAL_SUFFIX = 28;

SQL_DESC_LOCAL_TYPE_NAME = 29;

SQL_DESC_MAXIMUM_SCALE = 30;

SQL_DESC_MINIMUM_SCALE = 31;

SQL_DESC_NUM_PREC_RADIX = 32;

SQL_DESC_PARAMETER_TYPE = 33;

SQL_DESC_ROWS_PROCESSED_PTR = 34;

SQL_DESC_SCHEMA_NAME = SQL_COLUMN_OWNER_NAME;

SQL_DESC_SEARCHABLE = SQL_COLUMN_SEARCHABLE;

SQL_DESC_TYPE_NAME = SQL_COLUMN_TYPE_NAME;

SQL_DESC_TABLE_NAME = SQL_COLUMN_TABLE_NAME;

SQL_DESC_UNSIGNED = SQL_COLUMN_UNSIGNED;

SQL_DESC_UPDATABLE = SQL_COLUMN_UPDATABLE;

SQL_COMMIT = 0;

SQL_ROLLBACK = 1;

SQL_ATTR_ROW_ARRAY_SIZE = 27;

ODBC_ADD_DSN = 1;

ODBC_CONFIG_DSN = 2;

ODBC_REMOVE_DSN = 3;

ODBC_ADD_SYS_DSN = 4;

ODBC_CONFIG_SYS_DSN = 5;

ODBC_REMOVE_SYS_DSN = 6;

Variables

SQLAllocHandle: function(HandleType: SQLSMALLINT; InputHandle:SQLHANDLE; Var OutputHandlePtr: SQLHANDLE): SQLRETURN; stdcall;

SQLSetEnvAttr: function(EnvironmentHandle:SQLHENV; Attribute:SQLINTEGER;Value:SQLPOINTER; StringLength:SQLINTEGER):SQLRETURN; stdcall;

SQLFreeHandle: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE):SQLRETURN; stdcall;

SQLGetDiagRec: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE;RecNumber:SQLSMALLINT; Sqlstate:PSQLCHAR;var NativeError:SQLINTEGER; MessageText:PSQLCHAR;BufferLength:SQLSMALLINT; var TextLength:SQLSMALLINT ):SQLRETURN; stdcall;

SQLGetDiagField: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE;RecNumber:SQLSMALLINT; DiagIdentifier:SQLSMALLINT;DiagInfoPtr:SQLPOINTER; BufferLength:SQLSMALLINT;var StringLengthPtr:SQLSMALLINT):SQLRETURN; stdcall;

SQLConnect: function(ConnectionHandle:SQLHDBC; ServerName:PSQLCHAR;NameLength1:SQLSMALLINT; UserName:PSQLCHAR;NameLength2:SQLSMALLINT; Authentication:PSQLCHAR;NameLength3:SQLSMALLINT):SQLRETURN; stdcall;

SQLDisconnect: function(ConnectionHandle:SQLHDBC):SQLRETURN; stdcall;

SQLDriverConnect: function(hdbc: SQLHDBC; hwnd: SQLHWND;szCsin: PChar; szCLen: SQLSMALLINT;szCsout: PChar; cbCSMax: SQLSMALLINT;Var cbCsOut: SQLSMALLINT; f: SQLUSMALLINT):SQLRETURN; stdcall;

SQLExecDirect: function(StatementHandle:SQLHSTMT; StatementText:PSQLCHAR;TextLength:SQLINTEGER):SQLRETURN; stdcall;

SQLPrepare: function(StatementHandle:SQLHSTMT; StatementText:PSQLCHAR;TextLength:SQLINTEGER):SQLRETURN; stdcall;

SQLCloseCursor: function(StatementHandle:SQLHSTMT):SQLRETURN; stdcall;

SQLExecute: function(StatementHandle:SQLHSTMT):SQLRETURN; stdcall;

SQLFetch: function(StatementHandle:SQLHSTMT):SQLRETURN; stdcall;

SQLNumResultCols: function(StatementHandle:SQLHSTMT; var ColumnCount:SQLSMALLINT):SQLRETURN; stdcall;

SQLDescribeCol: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;ColumnName:PSQLCHAR; BufferLength:SQLSMALLINT;var NameLength:SQLSMALLINT; var DataType:SQLSMALLINT;var ColumnSize:SQLULEN; var DecimalDigits:SQLSMALLINT;var Nullable:SQLSMALLINT):SQLRETURN; stdcall;

SQLFetchScroll: function(StatementHandle:SQLHSTMT; FetchOrientation:SQLSMALLINT;FetchOffset:SQLLEN):SQLRETURN; stdcall;

SQLExtendedFetch: function(hstmt:SQLHSTMT; fFetchType:SQLUSMALLINT;irow:SQLLEN; pcrow:PSQLULEN;rgfRowStatus:PSQLUSMALLINT):SQLRETURN; stdcall;

SQLGetData: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;TargetType:SQLSMALLINT; TargetValue:SQLPOINTER;BufferLength:SQLLEN; StrLen_or_Ind:PSQLLEN):SQLRETURN; stdcall;

SQLSetStmtAttr: function(StatementHandle:SQLHSTMT; Attribute:SQLINTEGER;Value:SQLPOINTER; StringLength:SQLINTEGER):SQLRETURN; stdcall;

SQLGetStmtAttr: function(StatementHandle:SQLHSTMT; Attribute:SQLINTEGER;Value:SQLPOINTER; BufferLength:SQLINTEGER;StringLength:PSQLINTEGER):SQLRETURN; stdcall;

SQLGetInfo: function(ConnectionHandle:SQLHDBC; InfoType:SQLUSMALLINT;InfoValue:SQLPOINTER; BufferLength:SQLSMALLINT;StringLength:PSQLSMALLINT):SQLRETURN; stdcall;

SQLBulkOperations: function(StatementHandle: SQLHSTMT; Operation:SQLSMALLINT):SQLRETURN; stdcall;

SQLPutData: function(StatementHandle:SQLHSTMT; Data:SQLPOINTER;StrLen_or_Ind:SQLLEN):SQLRETURN; stdcall;

SQLBindCol: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;TargetType:SQLSMALLINT; TargetValue:SQLPOINTER;BufferLength:SQLLEN; StrLen_or_Ind:PSQLLEN):SQLRETURN; stdcall;

SQLSetPos: function(hstmt:SQLHSTMT; irow:SQLSETPOSIROW;fOption:SQLUSMALLINT; fLock:SQLUSMALLINT):SQLRETURN; stdcall;

SQLDataSources: function(EnvironmentHandle:SQLHENV; Direction:SQLUSMALLINT;ServerName:PSQLCHAR; BufferLength1:SQLSMALLINT;NameLength1:PSQLSMALLINT; Description:PSQLCHAR;BufferLength2:SQLSMALLINT; NameLength2:PSQLSMALLINT):SQLRETURN; stdcall;

SQLDrivers: function(EnvironmentHandle:SQLHENV; Direction:SQLUSMALLINT;DriverDescription:PSQLCHAR; BufferLength1:SQLSMALLINT;DescriptionLength1:PSQLSMALLINT; DriverAttributes:PSQLCHAR;BufferLength2:SQLSMALLINT; AttributesLength2:PSQLSMALLINT):SQLRETURN; stdcall;

SQLSetConnectAttr: function(ConnectionHandle:SQLHDBC; Attribute:SQLINTEGER; Value:SQLPOINTER; StringLength:SQLINTEGER):SQLRETURN; stdcall;

SQLGetCursorName: function(StatementHandle:SQLHSTMT; CursorName:PSQLCHAR; BufferLength:SQLSMALLINT; NameLength:PSQLSMALLINT):SQLRETURN; stdcall;

SQLSetCursorName: function(StatementHandle:SQLHSTMT; CursorName:PSQLCHAR; NameLength:SQLSMALLINT):SQLRETURN; stdcall;

SQLRowCount: function(StatementHandle:SQLHSTMT; Var RowCount:SQLLEN):SQLRETURN; stdcall;

SQLBindParameter: function(hstmt:SQLHSTMT; ipar:SQLUSMALLINT;fParamType:SQLSMALLINT; fCType:SQLSMALLINT;fSqlType:SQLSMALLINT; cbColDef:SQLULEN;ibScale:SQLSMALLINT; rgbValue:SQLPOINTER;cbValueMax:SQLLEN; pcbValue:PSQLLEN):SQLRETURN; stdcall;

SQLFreeStmt: function(StatementHandle:SQLHSTMT; Option:SQLUSMALLINT):SQLRETURN; stdcall;

SQLColAttribute: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;FieldIdentifier:SQLUSMALLINT; CharacterAttribute:PSQLCHAR;BufferLength:SQLSMALLINT; StringLength:PSQLSMALLINT;NumericAttribute:PSQLLEN):SQLRETURN; stdcall;

SQLEndTran: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE;CompletionType:SQLSMALLINT):SQLRETURN; stdcall;

SQLTables: function( hstmt : SQLHSTMT; szTableQualifier : PSQLCHAR;cbTableQualifier : SQLSMALLINT; szTableOwner : PSQLCHAR;cbTableOwner : SQLSMALLINT; szTableName : PSQLCHAR;cbTableName : SQLSMALLINT; szTableType : PSQLCHAR;cbTableType : SQLSMALLINT ) : SQLRETURN; stdcall;

SQLColumns: function( hstmt : SQLHSTMT; szTableQualifier : PSQLCHAR;cbTableQualifier : SQLSMALLINT; szTableOwner : PSQLCHAR;cbTableOwner : SQLSMALLINT; szTableName : PSQLCHAR;cbTableName : SQLSMALLINT; szColumnName : PSQLCHAR;cbColumnName : SQLSMALLINT ) : SQLRETURN; stdcall;

SQLSpecialColumns: function(StatementHandle:SQLHSTMT; IdentifierType:SQLUSMALLINT;CatalogName:PSQLCHAR; NameLength1:SQLSMALLINT;SchemaName:PSQLCHAR; NameLength2:SQLSMALLINT;TableName:PSQLCHAR; NameLength3:SQLSMALLINT;Scope:SQLUSMALLINT; Nullable:SQLUSMALLINT) : SQLRETURN; stdcall;

SQLProcedures: function( hstmt : SQLHSTMT; szTableQualifier : PSQLCHAR;cbTableQualifier : SQLSMALLINT; szTableOwner : PSQLCHAR;cbTableOwner : SQLSMALLINT; szTableName : PSQLCHAR;cbTableName : SQLSMALLINT ) : SQLRETURN; stdcall;

SQLPrimaryKeys: function(hstmt : SQLHSTMT; CatalogName:PSQLCHAR;NameLength1:SQLSMALLINT; SchemaName:PSQLCHAR;NameLength2:SQLSMALLINT; TableName:PSQLCHAR;NameLength3:SQLSMALLINT ):SQLRETURN; stdcall;

SQLProcedureColumns:  function(hstmt: SQLHSTMT; CatalogName: PSQLCHAR; NameLength1: SQLSMALLINT; SchemaName: PSQLCHAR; NameLength2: SQLSMALLINT; ProcName: PSQLCHAR; NameLength3: SQLSMALLINT; ColumnName: PSQLCHAR; NameLength4: SQLSMALLINT): SQLRETURN; stdcall;

SQLStatistics: function(hstmt: SQLHSTMT; CatalogName:PSQLCHAR; NameLength1:SQLSMALLINT; SchemaName:PSQLCHAR; NameLength2:SQLSMALLINT; TableName:PSQLCHAR; NameLength3:SQLSMALLINT; Unique:SQLUSMALLINT; Reserved:SQLUSMALLINT): SQLRETURN; stdcall;

Description

Functions and Procedures

procedure initializeodbc(const sonames: array of filenamety);

This item has no description.

procedure releaseodbc;

This item has no description.

function DateStructToDateTime( b:PSQL_DATE_STRUCT):TDateTime;

This item has no description.

function DateTimeToDateStruct( b:TDateTime):SQL_DATE_STRUCT;

This item has no description.

procedure DateTime2TimeStampStruct( var Value:SQL_TIMESTAMP_STRUCT; b:TDateTime);

This item has no description.

Function TimeStampStructToDateTime( B : PSQL_TIMESTAMP_STRUCT) : TDateTime;

This item has no description.

Function TimeStructToDateTime(B : PSQL_TIME_STRUCT) : TDateTime;

This item has no description.

Types

SQLCHAR = char;

This item has no description.

SQLSMALLINT = csshort;

This item has no description.

SQLUSMALLINT = cushort;

This item has no description.

SQLRETURN = SQLSMALLINT;

This item has no description.

SQLHANDLE = pointer;

This item has no description.

SQLHENV = SQLHANDLE;

This item has no description.

SQLHDBC = SQLHANDLE;

This item has no description.

SQLHSTMT = SQLHANDLE;

This item has no description.

SQLHDESC = SQLHANDLE;

This item has no description.

SQLINTEGER = clong;

This item has no description.

SQLUINTEGER = culong;

This item has no description.

SQLLEN = ptrint;

This item has no description.

SQLULEN = ptruint;

This item has no description.

SQLSETPOSIROW = SQLUSMALLINT;

This item has no description.

SQLPOINTER = pointer;

This item has no description.

SQLREAL = cfloat;

This item has no description.

SQLDOUBLE = cdouble;

This item has no description.

SQLFLOAT = cdouble;

This item has no description.

SQLHWND = pointer;

This item has no description.

PSQLCHAR = PChar;

This item has no description.

PSQLINTEGER = ˆSQLINTEGER;

This item has no description.

PSQLUINTEGER = ˆSQLUINTEGER;

This item has no description.

PSQLLEN = ˆSQLLEN;

This item has no description.

PSQLULEN = ˆSQLULEN;

This item has no description.

PSQLSMALLINT = ˆSQLSMALLINT;

This item has no description.

PSQLUSMALLINT = ˆSQLUSMALLINT;

This item has no description.

PSQLREAL = ˆSQLREAL;

This item has no description.

PSQLDOUBLE = ˆSQLDOUBLE;

This item has no description.

PSQLFLOAT = ˆSQLFLOAT;

This item has no description.

PSQLHANDLE = ˆSQLHANDLE;

This item has no description.

PSQL_DATE_STRUCT = ˆSQL_DATE_STRUCT;

This item has no description.

PSQL_TIME_STRUCT = ˆSQL_TIME_STRUCT;

This item has no description.

PSQL_TIMESTAMP_STRUCT = ˆSQL_TIMESTAMP_STRUCT;

This item has no description.

Constants

odbclib: array[0..2] of filenamety = ('libodbc.so.2','libodbc.so.1',
                                                               'libodbc.so');

This item has no description.

SQL_UNKNOWN_TYPE = 0;

This item has no description.

SQL_LONGVARCHAR =(-1);

This item has no description.

SQL_BINARY =(-2);

This item has no description.

SQL_VARBINARY =(-3);

This item has no description.

SQL_LONGVARBINARY =(-4);

This item has no description.

SQL_BIGINT =(-5);

This item has no description.

SQL_TINYINT =(-6);

This item has no description.

SQL_BIT =(-7);

This item has no description.

SQL_WCHAR =(-8);

This item has no description.

SQL_WVARCHAR =(-9);

This item has no description.

SQL_WLONGVARCHAR =(-10);

This item has no description.

SQL_CHAR = 1;

This item has no description.

SQL_NUMERIC = 2;

This item has no description.

SQL_DECIMAL = 3;

This item has no description.

SQL_INTEGER = 4;

This item has no description.

SQL_SMALLINT = 5;

This item has no description.

SQL_FLOAT = 6;

This item has no description.

SQL_REAL = 7;

This item has no description.

SQL_DOUBLE = 8;

This item has no description.

SQL_DATETIME = 9;

This item has no description.

SQL_VARCHAR = 12;

This item has no description.

SQL_TYPE_DATE = 91;

This item has no description.

SQL_TYPE_TIME = 92;

This item has no description.

SQL_TYPE_TIMESTAMP= 93;

This item has no description.

SQL_DATE = 9;

This item has no description.

SQL_TIME = 10;

This item has no description.

SQL_TIMESTAMP = 11;

This item has no description.

SQL_INTERVAL = 10;

This item has no description.

SQL_GUID = -11;

This item has no description.

SQL_CODE_YEAR = 1;

This item has no description.

SQL_CODE_MONTH = 2;

This item has no description.

SQL_CODE_DAY = 3;

This item has no description.

SQL_CODE_HOUR = 4;

This item has no description.

SQL_CODE_MINUTE = 5;

This item has no description.

SQL_CODE_SECOND = 6;

This item has no description.

SQL_CODE_YEAR_TO_MONTH = 7;

This item has no description.

SQL_CODE_DAY_TO_HOUR = 8;

This item has no description.

SQL_CODE_DAY_TO_MINUTE = 9;

This item has no description.

SQL_CODE_DAY_TO_SECOND = 10;

This item has no description.

SQL_CODE_HOUR_TO_MINUTE = 11;

This item has no description.

SQL_CODE_HOUR_TO_SECOND = 12;

This item has no description.

SQL_CODE_MINUTE_TO_SECOND = 13;

This item has no description.

SQL_INTERVAL_YEAR = 100 + SQL_CODE_YEAR;

This item has no description.

SQL_INTERVAL_MONTH = 100 + SQL_CODE_MONTH;

This item has no description.

SQL_INTERVAL_DAY = 100 + SQL_CODE_DAY;

This item has no description.

SQL_INTERVAL_HOUR = 100 + SQL_CODE_HOUR;

This item has no description.

SQL_INTERVAL_MINUTE = 100 + SQL_CODE_MINUTE;

This item has no description.

SQL_INTERVAL_SECOND = 100 + SQL_CODE_SECOND;

This item has no description.

SQL_INTERVAL_YEAR_TO_MONTH = 100 + SQL_CODE_YEAR_TO_MONTH;

This item has no description.

SQL_INTERVAL_DAY_TO_HOUR = 100 + SQL_CODE_DAY_TO_HOUR;

This item has no description.

SQL_INTERVAL_DAY_TO_MINUTE = 100 + SQL_CODE_DAY_TO_MINUTE;

This item has no description.

SQL_INTERVAL_DAY_TO_SECOND = 100 + SQL_CODE_DAY_TO_SECOND;

This item has no description.

SQL_INTERVAL_HOUR_TO_MINUTE = 100 + SQL_CODE_HOUR_TO_MINUTE;

This item has no description.

SQL_INTERVAL_HOUR_TO_SECOND = 100 + SQL_CODE_HOUR_TO_SECOND;

This item has no description.

SQL_INTERVAL_MINUTE_TO_SECOND = 100 + SQL_CODE_MINUTE_TO_SECOND;

This item has no description.

SQL_UNICODE = SQL_WCHAR;

This item has no description.

SQL_UNICODE_VARCHAR = SQL_WVARCHAR;

This item has no description.

SQL_UNICODE_LONGVARCHAR = SQL_WLONGVARCHAR;

This item has no description.

SQL_UNICODE_CHAR = SQL_WCHAR;

This item has no description.

SQL_C_CHAR = SQL_CHAR;

This item has no description.

SQL_C_WCHAR = SQL_WCHAR;

This item has no description.

SQL_C_LONG = SQL_INTEGER;

This item has no description.

SQL_C_SHORT = SQL_SMALLINT;

This item has no description.

SQL_C_FLOAT = SQL_REAL;

This item has no description.

SQL_C_DOUBLE = SQL_DOUBLE;

This item has no description.

SQL_C_NUMERIC = SQL_NUMERIC;

This item has no description.

SQL_C_DEFAULT = 99;

This item has no description.

SQL_SIGNED_OFFSET = -20;

This item has no description.

SQL_UNSIGNED_OFFSET = -22;

This item has no description.

SQL_C_DATE = SQL_DATE;

This item has no description.

SQL_C_TIME = SQL_TIME;

This item has no description.

SQL_C_TIMESTAMP = SQL_TIMESTAMP;

This item has no description.

SQL_C_TYPE_DATE = SQL_TYPE_DATE;

This item has no description.

SQL_C_TYPE_TIME = SQL_TYPE_TIME;

This item has no description.

SQL_C_TYPE_TIMESTAMP = SQL_TYPE_TIMESTAMP;

This item has no description.

SQL_C_INTERVAL_YEAR = SQL_INTERVAL_YEAR;

This item has no description.

SQL_C_INTERVAL_MONTH = SQL_INTERVAL_MONTH;

This item has no description.

SQL_C_INTERVAL_DAY = SQL_INTERVAL_DAY;

This item has no description.

SQL_C_INTERVAL_HOUR = SQL_INTERVAL_HOUR;

This item has no description.

SQL_C_INTERVAL_MINUTE = SQL_INTERVAL_MINUTE;

This item has no description.

SQL_C_INTERVAL_SECOND = SQL_INTERVAL_SECOND;

This item has no description.

SQL_C_INTERVAL_YEAR_TO_MONTH = SQL_INTERVAL_YEAR_TO_MONTH;

This item has no description.

SQL_C_INTERVAL_DAY_TO_HOUR = SQL_INTERVAL_DAY_TO_HOUR;

This item has no description.

SQL_C_INTERVAL_DAY_TO_MINUTE = SQL_INTERVAL_DAY_TO_MINUTE;

This item has no description.

SQL_C_INTERVAL_DAY_TO_SECOND = SQL_INTERVAL_DAY_TO_SECOND;

This item has no description.

SQL_C_INTERVAL_HOUR_TO_MINUTE = SQL_INTERVAL_HOUR_TO_MINUTE;

This item has no description.

SQL_C_INTERVAL_HOUR_TO_SECOND = SQL_INTERVAL_HOUR_TO_SECOND;

This item has no description.

SQL_C_INTERVAL_MINUTE_TO_SECOND = SQL_INTERVAL_MINUTE_TO_SECOND;

This item has no description.

SQL_C_BINARY = SQL_BINARY;

This item has no description.

SQL_C_BIT = SQL_BIT;

This item has no description.

SQL_C_SBIGINT = SQL_BIGINT+SQL_SIGNED_OFFSET;

This item has no description.

SQL_C_UBIGINT = SQL_BIGINT+SQL_UNSIGNED_OFFSET;

This item has no description.

SQL_C_TINYINT = SQL_TINYINT;

This item has no description.

SQL_C_SLONG = SQL_C_LONG +SQL_SIGNED_OFFSET;

This item has no description.

SQL_C_SSHORT = SQL_C_SHORT+SQL_SIGNED_OFFSET;

This item has no description.

SQL_C_STINYINT = SQL_TINYINT+SQL_SIGNED_OFFSET;

This item has no description.

SQL_C_ULONG = SQL_C_LONG +SQL_UNSIGNED_OFFSET;

This item has no description.

SQL_C_USHORT = SQL_C_SHORT+SQL_UNSIGNED_OFFSET;

This item has no description.

SQL_C_UTINYINT = SQL_TINYINT+SQL_UNSIGNED_OFFSET;

This item has no description.

SQL_C_BOOKMARK = SQL_C_ULONG;

This item has no description.

SQL_C_GUID = SQL_GUID;

This item has no description.

SQL_TYPE_NULL = 0;

This item has no description.

SQL_C_VARBOOKMARK = SQL_C_BINARY;

This item has no description.

SQL_API_SQLDESCRIBEPARAM=58;

This item has no description.

SQL_NO_TOTAL = -4;

This item has no description.

SQL_NAME_LEN = 128;

This item has no description.

SQL_OV_ODBC3 = 3;

This item has no description.

SQL_OV_ODBC2 = 2;

This item has no description.

SQL_ATTR_ODBC_VERSION = 200;

This item has no description.

SQL_DRIVER_NOPROMPT = 0;

This item has no description.

SQL_DRIVER_COMPLETE = 1;

This item has no description.

SQL_DRIVER_PROMPT = 2;

This item has no description.

SQL_DRIVER_COMPLETE_REQUIRED = 3;

This item has no description.

SQL_IS_POINTER = (-4);

This item has no description.

SQL_IS_UINTEGER = (-5);

This item has no description.

SQL_IS_INTEGER = (-6);

This item has no description.

SQL_IS_USMALLINT = (-7);

This item has no description.

SQL_IS_SMALLINT = (-8);

This item has no description.

SQL_FETCH_BOOKMARK = 8;

This item has no description.

SQL_SCROLL_OPTIONS = 44;

This item has no description.

SQL_UB_OFF = 0;

This item has no description.

SQL_UB_ON = 1;

This item has no description.

SQL_UB_DEFAULT = SQL_UB_OFF;

This item has no description.

SQL_UB_FIXED = SQL_UB_ON;

This item has no description.

SQL_UB_VARIABLE = 2;

This item has no description.

SQL_SO_FORWARD_ONLY = $01;

This item has no description.

SQL_SO_KEYSET_DRIVEN = $02;

This item has no description.

SQL_SO_DYNAMIC = $04;

This item has no description.

SQL_SO_MIXED = $08;

This item has no description.

SQL_SO_STATIC = $10;

This item has no description.

SQL_BOOKMARK_PERSISTENCE = 82;

This item has no description.

SQL_STATIC_SENSITIVITY = 83;

This item has no description.

SQL_BP_CLOSE = $01;

This item has no description.

SQL_BP_DELETE = $02;

This item has no description.

SQL_BP_DROP = $04;

This item has no description.

SQL_BP_TRANSACTION = $08;

This item has no description.

SQL_BP_UPDATE = $10;

This item has no description.

SQL_BP_OTHER_HSTMT = $20;

This item has no description.

SQL_BP_SCROLL = $40;

This item has no description.

SQL_DYNAMIC_CURSOR_ATTRIBUTES1 = 144;

This item has no description.

SQL_DYNAMIC_CURSOR_ATTRIBUTES2 = 145;

This item has no description.

SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 = 146;

This item has no description.

SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 = 147;

This item has no description.

SQL_INDEX_KEYWORDS = 148;

This item has no description.

SQL_INFO_SCHEMA_VIEWS = 149;

This item has no description.

SQL_KEYSET_CURSOR_ATTRIBUTES1 = 150;

This item has no description.

SQL_KEYSET_CURSOR_ATTRIBUTES2 = 151;

This item has no description.

SQL_STATIC_CURSOR_ATTRIBUTES1 = 167;

This item has no description.

SQL_STATIC_CURSOR_ATTRIBUTES2 = 168;

This item has no description.

SQL_CA1_NEXT = 1;

This item has no description.

SQL_CA1_ABSOLUTE = 2;

This item has no description.

SQL_CA1_RELATIVE = 4;

This item has no description.

SQL_CA1_BOOKMARK = 8;

This item has no description.

SQL_CA1_LOCK_NO_CHANGE= $40;

This item has no description.

SQL_CA1_LOCK_EXCLUSIVE= $80;

This item has no description.

SQL_CA1_LOCK_UNLOCK =$100;

This item has no description.

SQL_CA1_POS_POSITION = $200;

This item has no description.

SQL_CA1_POS_UPDATE = $400;

This item has no description.

SQL_CA1_POS_DELETE = $800;

This item has no description.

SQL_CA1_POS_REFRESH =$1000;

This item has no description.

SQL_CA1_POSITIONED_UPDATE=$2000;

This item has no description.

SQL_CA1_POSITIONED_DELETE=$4000;

This item has no description.

SQL_CA1_SELECT_FOR_UPDATE=$8000;

This item has no description.

SQL_CA1_BULK_ADD =$10000;

This item has no description.

SQL_CA1_BULK_UPDATE_BY_BOOKMARK =$20000;

This item has no description.

SQL_CA1_BULK_DELETE_BY_BOOKMARK =$40000;

This item has no description.

SQL_CA1_BULK_FETCH_BY_BOOKMARK =$80000;

This item has no description.

SQL_CA2_READ_ONLY_CONCURRENCY = 1;

This item has no description.

SQL_CA2_LOCK_CONCURRENCY = 2;

This item has no description.

SQL_CA2_OPT_ROWVER_CONCURRENCY= 4;

This item has no description.

SQL_CA2_OPT_VALUES_CONCURRENCY= 8;

This item has no description.

SQL_CA2_SENSITIVITY_ADDITIONS =$10;

This item has no description.

SQL_CA2_SENSITIVITY_DELETIONS =$20;

This item has no description.

SQL_CA2_SENSITIVITY_UPDATES =$40;

This item has no description.

SQL_CA2_MAX_ROWS_SELECT = $80;

This item has no description.

SQL_CA2_MAX_ROWS_INSERT =$100;

This item has no description.

SQL_CA2_MAX_ROWS_DELETE =$200;

This item has no description.

SQL_CA2_MAX_ROWS_UPDATE =$400;

This item has no description.

SQL_CA2_MAX_ROWS_CATALOG =$800;

This item has no description.

SQL_CA2_MAX_ROWS_AFFECTS_ALL  =(SQL_CA2_MAX_ROWS_SELECT or
                                        SQL_CA2_MAX_ROWS_INSERT or SQL_CA2_MAX_ROWS_DELETE or
                                        SQL_CA2_MAX_ROWS_UPDATE or SQL_CA2_MAX_ROWS_CATALOG);

This item has no description.

SQL_CA2_CRC_EXACT = $1000;

This item has no description.

SQL_CA2_CRC_APPROXIMATE = $2000;

This item has no description.

SQL_CA2_SIMULATE_NON_UNIQUE = $4000;

This item has no description.

SQL_CA2_SIMULATE_TRY_UNIQUE = $8000;

This item has no description.

SQL_CA2_SIMULATE_UNIQUE =$10000;

This item has no description.

SQL_ADD = 4;

This item has no description.

SQL_SETPOS_MAX_OPTION_VALUE = SQL_ADD;

This item has no description.

SQL_UPDATE_BY_BOOKMARK = 5;

This item has no description.

SQL_DELETE_BY_BOOKMARK = 6;

This item has no description.

SQL_FETCH_BY_BOOKMARK = 7;

This item has no description.

SQL_POSITION = 0;

This item has no description.

SQL_REFRESH = 1;

This item has no description.

SQL_UPDATE = 2;

This item has no description.

SQL_DELETE = 3;

This item has no description.

SQL_LOCK_NO_CHANGE = 0;

This item has no description.

SQL_LOCK_EXCLUSIVE = 1;

This item has no description.

SQL_LOCK_UNLOCK = 2;

This item has no description.

SQL_ROW_SUCCESS = 0;

This item has no description.

SQL_ROW_DELETED = 1;

This item has no description.

SQL_ROW_UPDATED = 2;

This item has no description.

SQL_ROW_NOROW = 3;

This item has no description.

SQL_ROW_ADDED = 4;

This item has no description.

SQL_ROW_ERROR = 5;

This item has no description.

SQL_ROW_SUCCESS_WITH_INFO = 6;

This item has no description.

SQL_ROW_PROCEED = 0;

This item has no description.

SQL_ROW_IGNORE = 1;

This item has no description.

SQL_MAX_DSN_LENGTH = 32;

This item has no description.

SQL_MAX_OPTION_STRING_LENGTH = 256;

This item has no description.

SQL_ODBC_CURSORS = 110;

This item has no description.

SQL_ATTR_ODBC_CURSORS = SQL_ODBC_CURSORS;

This item has no description.

SQL_CUR_USE_IF_NEEDED = 0;

This item has no description.

SQL_CUR_USE_ODBC = 1;

This item has no description.

SQL_CUR_USE_DRIVER = 2;

This item has no description.

SQL_CUR_DEFAULT = SQL_CUR_USE_DRIVER;

This item has no description.

SQL_PARAM_TYPE_UNKNOWN = 0;

This item has no description.

SQL_PARAM_INPUT = 1;

This item has no description.

SQL_PARAM_INPUT_OUTPUT = 2;

This item has no description.

SQL_RESULT_COL = 3;

This item has no description.

SQL_PARAM_OUTPUT = 4;

This item has no description.

SQL_RETURN_VALUE = 5;

This item has no description.

SQL_NULL_DATA = (-1);

This item has no description.

SQL_DATA_AT_EXEC = (-2);

This item has no description.

SQL_SUCCESS = 0;

This item has no description.

SQL_SUCCESS_WITH_INFO = 1;

This item has no description.

SQL_NO_DATA = 100;

This item has no description.

SQL_ERROR = (-1);

This item has no description.

SQL_INVALID_HANDLE = (-2);

This item has no description.

SQL_STILL_EXECUTING = 2;

This item has no description.

SQL_NEED_DATA = 99;

This item has no description.

SQL_NTS = (-3);

This item has no description.

SQL_MAX_MESSAGE_LENGTH = 512;

This item has no description.

SQL_DATE_LEN = 10;

This item has no description.

SQL_TIME_LEN = 8;

This item has no description.

SQL_TIMESTAMP_LEN = 19;

This item has no description.

SQL_HANDLE_ENV = 1;

This item has no description.

SQL_HANDLE_DBC = 2;

This item has no description.

SQL_HANDLE_STMT = 3;

This item has no description.

SQL_HANDLE_DESC = 4;

This item has no description.

SQL_ATTR_OUTPUT_NTS = 10001;

This item has no description.

SQL_ATTR_AUTO_IPD = 10001;

This item has no description.

SQL_ATTR_METADATA_ID = 10014;

This item has no description.

SQL_ATTR_APP_ROW_DESC = 10010;

This item has no description.

SQL_ATTR_APP_PARAM_DESC = 10011;

This item has no description.

SQL_ATTR_IMP_ROW_DESC = 10012;

This item has no description.

SQL_ATTR_IMP_PARAM_DESC = 10013;

This item has no description.

SQL_ATTR_CURSOR_SCROLLABLE = (-1);

This item has no description.

SQL_ATTR_CURSOR_SENSITIVITY = (-2);

This item has no description.

SQL_QUERY_TIMEOUT =0;

This item has no description.

SQL_MAX_ROWS =1;

This item has no description.

SQL_NOSCAN =2;

This item has no description.

SQL_MAX_LENGTH =3;

This item has no description.

SQL_ASYNC_ENABLE =4;

This item has no description.

SQL_BIND_TYPE =5;

This item has no description.

SQL_CURSOR_TYPE = 6;

This item has no description.

SQL_CONCURRENCY = 7;

This item has no description.

SQL_KEYSET_SIZE =8;

This item has no description.

SQL_ROWSET_SIZE =9;

This item has no description.

SQL_SIMULATE_CURSOR =10;

This item has no description.

SQL_RETRIEVE_DATA =11;

This item has no description.

SQL_USE_BOOKMARKS =12;

This item has no description.

SQL_GET_BOOKMARK =13;

This item has no description.

SQL_ROW_NUMBER = 14;

This item has no description.

SQL_ATTR_CURSOR_TYPE = SQL_CURSOR_TYPE;

This item has no description.

SQL_ATTR_CONCURRENCY = SQL_CONCURRENCY;

This item has no description.

SQL_ATTR_FETCH_BOOKMARK_PTR = 16;

This item has no description.

SQL_ATTR_ROW_STATUS_PTR = 25;

This item has no description.

SQL_ATTR_ROWS_FETCHED_PTR = 26;

This item has no description.

SQL_AUTOCOMMIT = 102;

This item has no description.

SQL_ATTR_AUTOCOMMIT = SQL_AUTOCOMMIT;

This item has no description.

SQL_ATTR_ROW_NUMBER = SQL_ROW_NUMBER;

This item has no description.

SQL_TXN_ISOLATION = 108;

This item has no description.

SQL_ATTR_TXN_ISOLATION = SQL_TXN_ISOLATION;

This item has no description.

SQL_ATTR_MAX_ROWS = SQL_MAX_ROWS;

This item has no description.

SQL_ATTR_USE_BOOKMARKS = SQL_USE_BOOKMARKS;

This item has no description.

SQL_ACCESS_MODE =101;

This item has no description.

SQL_LOGIN_TIMEOUT =103;

This item has no description.

SQL_OPT_TRACE =104;

This item has no description.

SQL_OPT_TRACEFILE =105;

This item has no description.

SQL_TRANSLATE_DLL =106;

This item has no description.

SQL_TRANSLATE_OPTION =107;

This item has no description.

SQL_CURRENT_QUALIFIER =109;

This item has no description.

SQL_QUIET_MODE =111;

This item has no description.

SQL_PACKET_SIZE =112;

This item has no description.

SQL_ATTR_ACCESS_MODE =SQL_ACCESS_MODE;

This item has no description.

SQL_ATTR_CONNECTION_DEAD =1209;

This item has no description.

SQL_ATTR_CONNECTION_TIMEOUT =113;

This item has no description.

SQL_ATTR_CURRENT_CATALOG =SQL_CURRENT_QUALIFIER;

This item has no description.

SQL_ATTR_DISCONNECT_BEHAVIOR=114;

This item has no description.

SQL_ATTR_ENLIST_IN_DTC =1207;

This item has no description.

SQL_ATTR_ENLIST_IN_XA =1208;

This item has no description.

SQL_ATTR_LOGIN_TIMEOUT =SQL_LOGIN_TIMEOUT;

This item has no description.

SQL_ATTR_PACKET_SIZE =SQL_PACKET_SIZE;

This item has no description.

SQL_ATTR_QUIET_MODE =SQL_QUIET_MODE;

This item has no description.

SQL_ATTR_TRACE =SQL_OPT_TRACE;

This item has no description.

SQL_ATTR_TRACEFILE =SQL_OPT_TRACEFILE;

This item has no description.

SQL_ATTR_TRANSLATE_LIB =SQL_TRANSLATE_DLL;

This item has no description.

SQL_ATTR_TRANSLATE_OPTION =SQL_TRANSLATE_OPTION;

This item has no description.

SQL_MODE_READ_WRITE =0;

This item has no description.

SQL_MODE_READ_ONLY =1;

This item has no description.

SQL_MODE_DEFAULT =SQL_MODE_READ_WRITE;

This item has no description.

SQL_AUTOCOMMIT_OFF = 0;

This item has no description.

SQL_AUTOCOMMIT_ON = 1;

This item has no description.

SQL_AUTOCOMMIT_DEFAULT = SQL_AUTOCOMMIT_ON;

This item has no description.

SQL_NONSCROLLABLE = 0;

This item has no description.

SQL_SCROLLABLE = 1;

This item has no description.

SQL_CURSOR_FORWARD_ONLY = 0;

This item has no description.

SQL_CURSOR_KEYSET_DRIVEN = 1;

This item has no description.

SQL_CURSOR_DYNAMIC = 2;

This item has no description.

SQL_CURSOR_STATIC = 3;

This item has no description.

SQL_CURSOR_TYPE_DEFAULT = SQL_CURSOR_FORWARD_ONLY;

This item has no description.

SQL_CONCUR_READ_ONLY = 1;

This item has no description.

SQL_CONCUR_LOCK = 2;

This item has no description.

SQL_CONCUR_ROWVER = 3;

This item has no description.

SQL_CONCUR_VALUES = 4;

This item has no description.

SQL_CONCUR_DEFAULT = SQL_CONCUR_READ_ONLY;

This item has no description.

SQL_DESC_COUNT = 1001;

This item has no description.

SQL_DESC_TYPE = 1002;

This item has no description.

SQL_DESC_LENGTH = 1003;

This item has no description.

SQL_DESC_OCTET_LENGTH_PTR = 1004;

This item has no description.

SQL_DESC_PRECISION = 1005;

This item has no description.

SQL_DESC_SCALE = 1006;

This item has no description.

SQL_DESC_DATETIME_INTERVAL_CODE = 1007;

This item has no description.

SQL_DESC_NULLABLE = 1008;

This item has no description.

SQL_DESC_INDICATOR_PTR = 1009;

This item has no description.

SQL_DESC_DATA_PTR = 1010;

This item has no description.

SQL_DESC_NAME = 1011;

This item has no description.

SQL_DESC_UNNAMED = 1012;

This item has no description.

SQL_DESC_OCTET_LENGTH = 1013;

This item has no description.

SQL_DESC_ALLOC_TYPE = 1099;

This item has no description.

SQL_DIAG_RETURNCODE = 1;

This item has no description.

SQL_DIAG_NUMBER = 2;

This item has no description.

SQL_DIAG_ROW_COUNT = 3;

This item has no description.

SQL_DIAG_SQLSTATE = 4;

This item has no description.

SQL_DIAG_NATIVE = 5;

This item has no description.

SQL_DIAG_MESSAGE_TEXT = 6;

This item has no description.

SQL_DIAG_DYNAMIC_FUNCTION = 7;

This item has no description.

SQL_DIAG_CLASS_ORIGIN = 8;

This item has no description.

SQL_DIAG_SUBCLASS_ORIGIN = 9;

This item has no description.

SQL_DIAG_CONNECTION_NAME = 10;

This item has no description.

SQL_DIAG_SERVER_NAME = 11;

This item has no description.

SQL_DIAG_DYNAMIC_FUNCTION_CODE = 12;

This item has no description.

SQL_DIAG_ALTER_TABLE = 4;

This item has no description.

SQL_DIAG_CREATE_INDEX = (-1);

This item has no description.

SQL_DIAG_CREATE_TABLE = 77;

This item has no description.

SQL_DIAG_CREATE_VIEW = 84;

This item has no description.

SQL_DIAG_DELETE_WHERE = 19;

This item has no description.

SQL_DIAG_DROP_INDEX = (-2);

This item has no description.

SQL_DIAG_DROP_TABLE = 32;

This item has no description.

SQL_DIAG_DROP_VIEW = 36;

This item has no description.

SQL_DIAG_DYNAMIC_DELETE_CURSOR = 38;

This item has no description.

SQL_DIAG_DYNAMIC_UPDATE_CURSOR = 81;

This item has no description.

SQL_DIAG_GRANT = 48;

This item has no description.

SQL_DIAG_INSERT = 50;

This item has no description.

SQL_DIAG_REVOKE = 59;

This item has no description.

SQL_DIAG_SELECT_CURSOR = 85;

This item has no description.

SQL_DIAG_UNKNOWN_STATEMENT = 0;

This item has no description.

SQL_DIAG_UPDATE_WHERE = 82;

This item has no description.

SQL_DIAG_CURSOR_ROW_COUNT = -1249;

This item has no description.

SQL_UNSPECIFIED = 0;

This item has no description.

SQL_INSENSITIVE = 1;

This item has no description.

SQL_SENSITIVE = 2;

This item has no description.

SQL_ALL_TYPES = 0;

This item has no description.

SQL_DEFAULT = 99;

This item has no description.

SQL_ARD_TYPE = (-99);

This item has no description.

SQL_CODE_DATE = 1;

This item has no description.

SQL_CODE_TIME = 2;

This item has no description.

SQL_CODE_TIMESTAMP = 3;

This item has no description.

SQL_FALSE = 0;

This item has no description.

SQL_TRUE = 1;

This item has no description.

SQL_NO_NULLS = 0;

This item has no description.

SQL_NULLABLE = 1;

This item has no description.

SQL_NULLABLE_UNKNOWN = 2;

This item has no description.

SQL_CLOSE = 0;

This item has no description.

SQL_DROP = 1;

This item has no description.

SQL_UNBIND = 2;

This item has no description.

SQL_RESET_PARAMS = 3;

This item has no description.

SQL_FETCH_NEXT = 1;

This item has no description.

SQL_FETCH_FIRST = 2;

This item has no description.

SQL_FETCH_FIRST_USER = 31;

This item has no description.

SQL_FETCH_FIRST_SYSTEM = 32;

This item has no description.

SQL_FETCH_LAST = 3;

This item has no description.

SQL_FETCH_PRIOR = 4;

This item has no description.

SQL_FETCH_ABSOLUTE = 5;

This item has no description.

SQL_FETCH_RELATIVE = 6;

This item has no description.

SQL_NULL_HENV = SQLHENV(0);

This item has no description.

SQL_NULL_HDBC = SQLHDBC(0);

This item has no description.

SQL_NULL_HSTMT = SQLHSTMT(0);

This item has no description.

SQL_NULL_HDESC = SQLHDESC(0);

This item has no description.

SQL_NULL_HANDLE = SQLHANDLE(0);

This item has no description.

SQL_SCOPE_CURROW = 0;

This item has no description.

SQL_SCOPE_TRANSACTION = 1;

This item has no description.

SQL_SCOPE_SESSION = 2;

This item has no description.

SQL_BEST_ROWID = 1;

This item has no description.

SQL_ROWVER = 2;

This item has no description.

SQL_ROW_IDENTIFIER = 1;

This item has no description.

SQL_INDEX_UNIQUE = 0;

This item has no description.

SQL_INDEX_ALL = 1;

This item has no description.

SQL_QUICK = 0;

This item has no description.

SQL_ENSURE = 1;

This item has no description.

SQL_TABLE_STAT = 0;

This item has no description.

SQL_INDEX_CLUSTERED = 1;

This item has no description.

SQL_INDEX_HASHED = 2;

This item has no description.

SQL_INDEX_OTHER = 3;

This item has no description.

SQL_SCROLL_CONCURRENCY = 43;

This item has no description.

SQL_TXN_CAPABLE = 46;

This item has no description.

SQL_TRANSACTION_CAPABLE = SQL_TXN_CAPABLE;

This item has no description.

SQL_USER_NAME = 47;

This item has no description.

SQL_TXN_ISOLATION_OPTION = 72;

This item has no description.

SQL_TRANSACTION_ISOLATION_OPTION = SQL_TXN_ISOLATION_OPTION;

This item has no description.

SQL_OJ_CAPABILITIES = 115;

This item has no description.

SQL_OUTER_JOIN_CAPABILITIES = SQL_OJ_CAPABILITIES;

This item has no description.

SQL_XOPEN_CLI_YEAR = 10000;

This item has no description.

SQL_CURSOR_SENSITIVITY = 10001;

This item has no description.

SQL_DESCRIBE_PARAMETER = 10002;

This item has no description.

SQL_CATALOG_NAME = 10003;

This item has no description.

SQL_COLLATION_SEQ = 10004;

This item has no description.

SQL_MAX_IDENTIFIER_LEN = 10005;

This item has no description.

SQL_MAXIMUM_IDENTIFIER_LENGTH = SQL_MAX_IDENTIFIER_LEN;

This item has no description.

SQL_SCCO_READ_ONLY = 1;

This item has no description.

SQL_SCCO_LOCK = 2;

This item has no description.

SQL_SCCO_OPT_ROWVER = 4;

This item has no description.

SQL_SCCO_OPT_VALUES = 8;

This item has no description.

SQL_TC_NONE = 0;

This item has no description.

SQL_TC_DML = 1;

This item has no description.

SQL_TC_ALL = 2;

This item has no description.

SQL_TC_DDL_COMMIT = 3;

This item has no description.

SQL_TC_DDL_IGNORE = 4;

This item has no description.

SQL_TXN_READ_UNCOMMITTED = 1;

This item has no description.

SQL_TRANSACTION_READ_UNCOMMITTED = SQL_TXN_READ_UNCOMMITTED;

This item has no description.

SQL_TXN_READ_COMMITTED = 2;

This item has no description.

SQL_TRANSACTION_READ_COMMITTED = SQL_TXN_READ_COMMITTED;

This item has no description.

SQL_TXN_REPEATABLE_READ = 4;

This item has no description.

SQL_TRANSACTION_REPEATABLE_READ = SQL_TXN_REPEATABLE_READ;

This item has no description.

SQL_TXN_SERIALIZABLE = 8;

This item has no description.

SQL_TRANSACTION_SERIALIZABLE = SQL_TXN_SERIALIZABLE;

This item has no description.

SQL_SS_ADDITIONS = 1;

This item has no description.

SQL_SS_DELETIONS = 2;

This item has no description.

SQL_SS_UPDATES = 4;

This item has no description.

SQL_COLUMN_COUNT = 0;

This item has no description.

SQL_COLUMN_NAME = 1;

This item has no description.

SQL_COLUMN_TYPE = 2;

This item has no description.

SQL_COLUMN_LENGTH = 3;

This item has no description.

SQL_COLUMN_PRECISION = 4;

This item has no description.

SQL_COLUMN_SCALE = 5;

This item has no description.

SQL_COLUMN_DISPLAY_SIZE = 6;

This item has no description.

SQL_COLUMN_NULLABLE = 7;

This item has no description.

SQL_COLUMN_UNSIGNED = 8;

This item has no description.

SQL_COLUMN_MONEY = 9;

This item has no description.

SQL_COLUMN_UPDATABLE = 10;

This item has no description.

SQL_COLUMN_AUTO_INCREMENT = 11;

This item has no description.

SQL_COLUMN_CASE_SENSITIVE = 12;

This item has no description.

SQL_COLUMN_SEARCHABLE = 13;

This item has no description.

SQL_COLUMN_TYPE_NAME = 14;

This item has no description.

SQL_COLUMN_TABLE_NAME = 15;

This item has no description.

SQL_COLUMN_OWNER_NAME = 16;

This item has no description.

SQL_COLUMN_QUALIFIER_NAME = 17;

This item has no description.

SQL_COLUMN_LABEL = 18;

This item has no description.

SQL_COLATT_OPT_MAX = SQL_COLUMN_LABEL;

This item has no description.

SQL_COLUMN_DRIVER_START = 1000;

This item has no description.

SQL_DESC_ARRAY_SIZE = 20;

This item has no description.

SQL_DESC_ARRAY_STATUS_PTR = 21;

This item has no description.

SQL_DESC_AUTO_UNIQUE_VALUE = SQL_COLUMN_AUTO_INCREMENT;

This item has no description.

SQL_DESC_BASE_COLUMN_NAME = 22;

This item has no description.

SQL_DESC_BASE_TABLE_NAME = 23;

This item has no description.

SQL_DESC_BIND_OFFSET_PTR = 24;

This item has no description.

SQL_DESC_BIND_TYPE = 25;

This item has no description.

SQL_DESC_CASE_SENSITIVE = SQL_COLUMN_CASE_SENSITIVE;

This item has no description.

SQL_DESC_CATALOG_NAME = SQL_COLUMN_QUALIFIER_NAME;

This item has no description.

SQL_DESC_CONCISE_TYPE = SQL_COLUMN_TYPE;

This item has no description.

SQL_DESC_DATETIME_INTERVAL_PRECISION = 26;

This item has no description.

SQL_DESC_DISPLAY_SIZE = SQL_COLUMN_DISPLAY_SIZE;

This item has no description.

SQL_DESC_FIXED_PREC_SCALE = SQL_COLUMN_MONEY;

This item has no description.

SQL_DESC_LABEL = SQL_COLUMN_LABEL;

This item has no description.

SQL_DESC_LITERAL_PREFIX = 27;

This item has no description.

SQL_DESC_LITERAL_SUFFIX = 28;

This item has no description.

SQL_DESC_LOCAL_TYPE_NAME = 29;

This item has no description.

SQL_DESC_MAXIMUM_SCALE = 30;

This item has no description.

SQL_DESC_MINIMUM_SCALE = 31;

This item has no description.

SQL_DESC_NUM_PREC_RADIX = 32;

This item has no description.

SQL_DESC_PARAMETER_TYPE = 33;

This item has no description.

SQL_DESC_ROWS_PROCESSED_PTR = 34;

This item has no description.

SQL_DESC_SCHEMA_NAME = SQL_COLUMN_OWNER_NAME;

This item has no description.

SQL_DESC_SEARCHABLE = SQL_COLUMN_SEARCHABLE;

This item has no description.

SQL_DESC_TYPE_NAME = SQL_COLUMN_TYPE_NAME;

This item has no description.

SQL_DESC_TABLE_NAME = SQL_COLUMN_TABLE_NAME;

This item has no description.

SQL_DESC_UNSIGNED = SQL_COLUMN_UNSIGNED;

This item has no description.

SQL_DESC_UPDATABLE = SQL_COLUMN_UPDATABLE;

This item has no description.

SQL_COMMIT = 0;

This item has no description.

SQL_ROLLBACK = 1;

This item has no description.

SQL_ATTR_ROW_ARRAY_SIZE = 27;

This item has no description.

ODBC_ADD_DSN = 1;

This item has no description.

ODBC_CONFIG_DSN = 2;

This item has no description.

ODBC_REMOVE_DSN = 3;

This item has no description.

ODBC_ADD_SYS_DSN = 4;

This item has no description.

ODBC_CONFIG_SYS_DSN = 5;

This item has no description.

ODBC_REMOVE_SYS_DSN = 6;

This item has no description.

Variables

SQLAllocHandle: function(HandleType: SQLSMALLINT; InputHandle:SQLHANDLE; Var OutputHandlePtr: SQLHANDLE): SQLRETURN; stdcall;

This item has no description.

SQLSetEnvAttr: function(EnvironmentHandle:SQLHENV; Attribute:SQLINTEGER;Value:SQLPOINTER; StringLength:SQLINTEGER):SQLRETURN; stdcall;

This item has no description.

SQLFreeHandle: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE):SQLRETURN; stdcall;

This item has no description.

SQLGetDiagRec: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE;RecNumber:SQLSMALLINT; Sqlstate:PSQLCHAR;var NativeError:SQLINTEGER; MessageText:PSQLCHAR;BufferLength:SQLSMALLINT; var TextLength:SQLSMALLINT ):SQLRETURN; stdcall;

This item has no description.

SQLGetDiagField: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE;RecNumber:SQLSMALLINT; DiagIdentifier:SQLSMALLINT;DiagInfoPtr:SQLPOINTER; BufferLength:SQLSMALLINT;var StringLengthPtr:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLConnect: function(ConnectionHandle:SQLHDBC; ServerName:PSQLCHAR;NameLength1:SQLSMALLINT; UserName:PSQLCHAR;NameLength2:SQLSMALLINT; Authentication:PSQLCHAR;NameLength3:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLDisconnect: function(ConnectionHandle:SQLHDBC):SQLRETURN; stdcall;

This item has no description.

SQLDriverConnect: function(hdbc: SQLHDBC; hwnd: SQLHWND;szCsin: PChar; szCLen: SQLSMALLINT;szCsout: PChar; cbCSMax: SQLSMALLINT;Var cbCsOut: SQLSMALLINT; f: SQLUSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLExecDirect: function(StatementHandle:SQLHSTMT; StatementText:PSQLCHAR;TextLength:SQLINTEGER):SQLRETURN; stdcall;

This item has no description.

SQLPrepare: function(StatementHandle:SQLHSTMT; StatementText:PSQLCHAR;TextLength:SQLINTEGER):SQLRETURN; stdcall;

This item has no description.

SQLCloseCursor: function(StatementHandle:SQLHSTMT):SQLRETURN; stdcall;

This item has no description.

SQLExecute: function(StatementHandle:SQLHSTMT):SQLRETURN; stdcall;

This item has no description.

SQLFetch: function(StatementHandle:SQLHSTMT):SQLRETURN; stdcall;

This item has no description.

SQLNumResultCols: function(StatementHandle:SQLHSTMT; var ColumnCount:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLDescribeCol: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;ColumnName:PSQLCHAR; BufferLength:SQLSMALLINT;var NameLength:SQLSMALLINT; var DataType:SQLSMALLINT;var ColumnSize:SQLULEN; var DecimalDigits:SQLSMALLINT;var Nullable:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLFetchScroll: function(StatementHandle:SQLHSTMT; FetchOrientation:SQLSMALLINT;FetchOffset:SQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLExtendedFetch: function(hstmt:SQLHSTMT; fFetchType:SQLUSMALLINT;irow:SQLLEN; pcrow:PSQLULEN;rgfRowStatus:PSQLUSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLGetData: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;TargetType:SQLSMALLINT; TargetValue:SQLPOINTER;BufferLength:SQLLEN; StrLen_or_Ind:PSQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLSetStmtAttr: function(StatementHandle:SQLHSTMT; Attribute:SQLINTEGER;Value:SQLPOINTER; StringLength:SQLINTEGER):SQLRETURN; stdcall;

This item has no description.

SQLGetStmtAttr: function(StatementHandle:SQLHSTMT; Attribute:SQLINTEGER;Value:SQLPOINTER; BufferLength:SQLINTEGER;StringLength:PSQLINTEGER):SQLRETURN; stdcall;

This item has no description.

SQLGetInfo: function(ConnectionHandle:SQLHDBC; InfoType:SQLUSMALLINT;InfoValue:SQLPOINTER; BufferLength:SQLSMALLINT;StringLength:PSQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLBulkOperations: function(StatementHandle: SQLHSTMT; Operation:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLPutData: function(StatementHandle:SQLHSTMT; Data:SQLPOINTER;StrLen_or_Ind:SQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLBindCol: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;TargetType:SQLSMALLINT; TargetValue:SQLPOINTER;BufferLength:SQLLEN; StrLen_or_Ind:PSQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLSetPos: function(hstmt:SQLHSTMT; irow:SQLSETPOSIROW;fOption:SQLUSMALLINT; fLock:SQLUSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLDataSources: function(EnvironmentHandle:SQLHENV; Direction:SQLUSMALLINT;ServerName:PSQLCHAR; BufferLength1:SQLSMALLINT;NameLength1:PSQLSMALLINT; Description:PSQLCHAR;BufferLength2:SQLSMALLINT; NameLength2:PSQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLDrivers: function(EnvironmentHandle:SQLHENV; Direction:SQLUSMALLINT;DriverDescription:PSQLCHAR; BufferLength1:SQLSMALLINT;DescriptionLength1:PSQLSMALLINT; DriverAttributes:PSQLCHAR;BufferLength2:SQLSMALLINT; AttributesLength2:PSQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLSetConnectAttr: function(ConnectionHandle:SQLHDBC; Attribute:SQLINTEGER; Value:SQLPOINTER; StringLength:SQLINTEGER):SQLRETURN; stdcall;

This item has no description.

SQLGetCursorName: function(StatementHandle:SQLHSTMT; CursorName:PSQLCHAR; BufferLength:SQLSMALLINT; NameLength:PSQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLSetCursorName: function(StatementHandle:SQLHSTMT; CursorName:PSQLCHAR; NameLength:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLRowCount: function(StatementHandle:SQLHSTMT; Var RowCount:SQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLBindParameter: function(hstmt:SQLHSTMT; ipar:SQLUSMALLINT;fParamType:SQLSMALLINT; fCType:SQLSMALLINT;fSqlType:SQLSMALLINT; cbColDef:SQLULEN;ibScale:SQLSMALLINT; rgbValue:SQLPOINTER;cbValueMax:SQLLEN; pcbValue:PSQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLFreeStmt: function(StatementHandle:SQLHSTMT; Option:SQLUSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLColAttribute: function(StatementHandle:SQLHSTMT; ColumnNumber:SQLUSMALLINT;FieldIdentifier:SQLUSMALLINT; CharacterAttribute:PSQLCHAR;BufferLength:SQLSMALLINT; StringLength:PSQLSMALLINT;NumericAttribute:PSQLLEN):SQLRETURN; stdcall;

This item has no description.

SQLEndTran: function(HandleType:SQLSMALLINT; Handle:SQLHANDLE;CompletionType:SQLSMALLINT):SQLRETURN; stdcall;

This item has no description.

SQLTables: function( hstmt : SQLHSTMT; szTableQualifier : PSQLCHAR;cbTableQualifier : SQLSMALLINT; szTableOwner : PSQLCHAR;cbTableOwner : SQLSMALLINT; szTableName : PSQLCHAR;cbTableName : SQLSMALLINT; szTableType : PSQLCHAR;cbTableType : SQLSMALLINT ) : SQLRETURN; stdcall;

This item has no description.

SQLColumns: function( hstmt : SQLHSTMT; szTableQualifier : PSQLCHAR;cbTableQualifier : SQLSMALLINT; szTableOwner : PSQLCHAR;cbTableOwner : SQLSMALLINT; szTableName : PSQLCHAR;cbTableName : SQLSMALLINT; szColumnName : PSQLCHAR;cbColumnName : SQLSMALLINT ) : SQLRETURN; stdcall;

This item has no description.

SQLSpecialColumns: function(StatementHandle:SQLHSTMT; IdentifierType:SQLUSMALLINT;CatalogName:PSQLCHAR; NameLength1:SQLSMALLINT;SchemaName:PSQLCHAR; NameLength2:SQLSMALLINT;TableName:PSQLCHAR; NameLength3:SQLSMALLINT;Scope:SQLUSMALLINT; Nullable:SQLUSMALLINT) : SQLRETURN; stdcall;

This item has no description.

SQLProcedures: function( hstmt : SQLHSTMT; szTableQualifier : PSQLCHAR;cbTableQualifier : SQLSMALLINT; szTableOwner : PSQLCHAR;cbTableOwner : SQLSMALLINT; szTableName : PSQLCHAR;cbTableName : SQLSMALLINT ) : SQLRETURN; stdcall;

This item has no description.

SQLPrimaryKeys: function(hstmt : SQLHSTMT; CatalogName:PSQLCHAR;NameLength1:SQLSMALLINT; SchemaName:PSQLCHAR;NameLength2:SQLSMALLINT; TableName:PSQLCHAR;NameLength3:SQLSMALLINT ):SQLRETURN; stdcall;

This item has no description.

SQLProcedureColumns:  function(hstmt: SQLHSTMT; CatalogName: PSQLCHAR; NameLength1: SQLSMALLINT; SchemaName: PSQLCHAR; NameLength2: SQLSMALLINT; ProcName: PSQLCHAR; NameLength3: SQLSMALLINT; ColumnName: PSQLCHAR; NameLength4: SQLSMALLINT): SQLRETURN; stdcall;

This item has no description.

SQLStatistics: function(hstmt: SQLHSTMT; CatalogName:PSQLCHAR; NameLength1:SQLSMALLINT; SchemaName:PSQLCHAR; NameLength2:SQLSMALLINT; TableName:PSQLCHAR; NameLength3:SQLSMALLINT; Unique:SQLUSMALLINT; Reserved:SQLUSMALLINT): SQLRETURN; stdcall;

This item has no description.

Generated by PasDoc 0.17.0.snapshot.

Documentation

Unit odbcsqldyn

Description

Overview

Classes, Interfaces, Objects and Records

Functions and Procedures

Types

Constants

Variables

Description

Functions and Procedures

Types

Constants

Variables