sdodbc.hpp

SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland Delphi

	/* TICustomOdbcCommand.Destroy */ inline __fastcall virtual ~TIOdbcCallIndexes(void) { }
	#pragma option pop
	
};


class DELPHICLASS TIOdbcDatabase;
class PASCALIMPLEMENTATION TIOdbcDatabase : public TICustomOdbcDatabase 
{
	typedef TICustomOdbcDatabase inherited;
	
protected:
	virtual void __fastcall FreeSqlLib(void);
	virtual void __fastcall LoadSqlLib(void);
	virtual void __fastcall RaiseSDEngineError(short AErrorCode, short ANativeError, const AnsiString AMsg, const AnsiString ASqlState);
	
public:
	virtual Sdcommon::TISqlCommand* __fastcall CreateSqlCommand(void);
public:
	#pragma option push -w-inl
	/* TICustomOdbcDatabase.Create */ inline __fastcall virtual TIOdbcDatabase(Classes::TStrings* ADbParams) : TICustomOdbcDatabase(ADbParams) { }
	#pragma option pop
	#pragma option push -w-inl
	/* TICustomOdbcDatabase.Destroy */ inline __fastcall virtual ~TIOdbcDatabase(void) { }
	#pragma option pop
	
};


class DELPHICLASS TIOdbcCommand;
class PASCALIMPLEMENTATION TIOdbcCommand : public TICustomOdbcCommand 
{
	typedef TICustomOdbcCommand inherited;
	
public:
	#pragma option push -w-inl
	/* TICustomOdbcCommand.Create */ inline __fastcall virtual TIOdbcCommand(Sdcommon::TISqlDatabase* ASqlDatabase) : TICustomOdbcCommand(ASqlDatabase) { }
	#pragma option pop
	#pragma option push -w-inl
	/* TICustomOdbcCommand.Destroy */ inline __fastcall virtual ~TIOdbcCommand(void) { }
	#pragma option pop
	
};


//-- var, const, procedure ---------------------------------------------------
#define ODBC_TBL_SCH_NAME_FIELD "TABLE_SCHEM"
#define ODBC_TBL_NAME_FIELD "TABLE_NAME"
#define ODBC_TBL_TYPE_NAME_FIELD "TABLE_TYPE"
#define ODBC_COL_NAME_FIELD "COLUMN_NAME"
#define ODBC_PROC_NAME_FIELD "PROCEDURE_NAME"
#define ODBC_PROC_SCH_NAME_FIELD "PROCEDURE_SCHEM"
static const Shortint SQL_VALUE_DATA = 0x0;
static const Shortint SQL_NULL_DATA = 0xffffffff;
static const Shortint SQL_DATA_AT_EXEC = 0xfffffffe;
static const Shortint SQL_SUCCESS = 0x0;
static const Shortint SQL_SUCCESS_WITH_INFO = 0x1;
static const Shortint SQL_STILL_EXECUTING = 0x2;
static const Shortint SQL_NEED_DATA = 0x63;
static const Shortint SQL_NO_DATA = 0x64;
static const Shortint SQL_NO_DATA_FOUND = 0x64;
static const Shortint SQL_ERROR = 0xffffffff;
static const Shortint SQL_INVALID_HANDLE = 0xfffffffe;
static const Shortint SQL_NTS = 0xfffffffd;
static const int SQL_NTSL = 0xfffffffd;
static const Word SQL_MAX_MESSAGE_LENGTH = 0x200;
static const Shortint SQL_DATE_LEN = 0xa;
static const Shortint SQL_TIME_LEN = 0x8;
static const Shortint SQL_TIMESTAMP_LEN = 0x13;
static const Shortint SQL_HANDLE_ENV = 0x1;
static const Shortint SQL_HANDLE_DBC = 0x2;
static const Shortint SQL_HANDLE_STMT = 0x3;
static const Shortint SQL_HANDLE_DESC = 0x4;
static const Word SQL_ATTR_OUTPUT_NTS = 0x2711;
static const Word SQL_ATTR_AUTO_IPD = 0x2711;
static const Word SQL_ATTR_METADATA_ID = 0x271e;
static const Word SQL_ATTR_APP_ROW_DESC = 0x271a;
static const Word SQL_ATTR_APP_PARAM_DESC = 0x271b;
static const Word SQL_ATTR_IMP_ROW_DESC = 0x271c;
static const Word SQL_ATTR_IMP_PARAM_DESC = 0x271d;
static const Shortint SQL_ATTR_CURSOR_SCROLLABLE = 0xffffffff;
static const Shortint SQL_ATTR_CURSOR_SENSITIVITY = 0xfffffffe;
static const Shortint SQL_NONSCROLLABLE = 0x0;
static const Shortint SQL_SCROLLABLE = 0x1;
static const Word SQL_DESC_COUNT = 0x3e9;
static const Word SQL_DESC_TYPE = 0x3ea;
static const Word SQL_DESC_LENGTH = 0x3eb;
static const Word SQL_DESC_OCTET_LENGTH_PTR = 0x3ec;
static const Word SQL_DESC_PRECISION = 0x3ed;
static const Word SQL_DESC_SCALE = 0x3ee;
static const Word SQL_DESC_DATETIME_INTERVAL_CODE = 0x3ef;
static const Word SQL_DESC_NULLABLE = 0x3f0;
static const Word SQL_DESC_INDICATOR_PTR = 0x3f1;
static const Word SQL_DESC_DATA_PTR = 0x3f2;
static const Word SQL_DESC_NAME = 0x3f3;
static const Word SQL_DESC_UNNAMED = 0x3f4;
static const Word SQL_DESC_OCTET_LENGTH = 0x3f5;
static const Word SQL_DESC_ALLOC_TYPE = 0x44b;
static const Shortint SQL_DIAG_RETURNCODE = 0x1;
static const Shortint SQL_DIAG_NUMBER = 0x2;
static const Shortint SQL_DIAG_ROW_COUNT = 0x3;
static const Shortint SQL_DIAG_SQLSTATE = 0x4;
static const Shortint SQL_DIAG_NATIVE = 0x5;
static const Shortint SQL_DIAG_MESSAGE_TEXT = 0x6;
static const Shortint SQL_DIAG_DYNAMIC_FUNCTION = 0x7;
static const Shortint SQL_DIAG_CLASS_ORIGIN = 0x8;
static const Shortint SQL_DIAG_SUBCLASS_ORIGIN = 0x9;
static const Shortint SQL_DIAG_CONNECTION_NAME = 0xa;
static const Shortint SQL_DIAG_SERVER_NAME = 0xb;
static const Shortint SQL_DIAG_DYNAMIC_FUNCTION_CODE = 0xc;
static const Shortint SQL_DIAG_ALTER_DOMAIN = 0x3;
static const Shortint SQL_DIAG_ALTER_TABLE = 0x4;
static const Shortint SQL_DIAG_CALL = 0x7;
static const Shortint SQL_DIAG_CREATE_ASSERTION = 0x6;
static const Shortint SQL_DIAG_CREATE_CHARACTER_SET = 0x8;
static const Shortint SQL_DIAG_CREATE_COLLATION = 0xa;
static const Shortint SQL_DIAG_CREATE_DOMAIN = 0x17;
static const Shortint SQL_DIAG_CREATE_SCHEMA = 0x40;
static const Shortint SQL_DIAG_CREATE_INDEX = 0xffffffff;
static const Shortint SQL_DIAG_CREATE_TABLE = 0x4d;
static const Shortint SQL_DIAG_CREATE_TRANSLATION = 0x4f;
static const Shortint SQL_DIAG_CREATE_VIEW = 0x54;
static const Shortint SQL_DIAG_DELETE_WHERE = 0x13;
static const Shortint SQL_DIAG_DROP_ASSERTION = 0x18;
static const Shortint SQL_DIAG_DROP_CHARACTER_SET = 0x19;
static const Shortint SQL_DIAG_DROP_COLLATION = 0x1a;
static const Shortint SQL_DIAG_DROP_DOMAIN = 0x1b;
static const Shortint SQL_DIAG_DROP_INDEX = 0xfffffffe;
static const Shortint SQL_DIAG_DROP_SCHEMA = 0x1f;
static const Shortint SQL_DIAG_DROP_TABLE = 0x20;
static const Shortint SQL_DIAG_DROP_TRANSLATION = 0x21;
static const Shortint SQL_DIAG_DROP_VIEW = 0x24;
static const Shortint SQL_DIAG_DYNAMIC_DELETE_CURSOR = 0x26;
static const Shortint SQL_DIAG_DYNAMIC_UPDATE_CURSOR = 0x51;
static const Shortint SQL_DIAG_GRANT = 0x30;
static const Shortint SQL_DIAG_INSERT = 0x32;
static const Shortint SQL_DIAG_REVOKE = 0x3b;
static const Shortint SQL_DIAG_SELECT_CURSOR = 0x55;
static const Shortint SQL_DIAG_UNKNOWN_STATEMENT = 0x0;
static const Shortint SQL_DIAG_UPDATE_WHERE = 0x52;
static const Shortint SQL_UNKNOWN_TYPE = 0x0;
static const Shortint SQL_CHAR = 0x1;
static const Shortint SQL_NUMERIC = 0x2;
static const Shortint SQL_DECIMAL = 0x3;
static const Shortint SQL_INTEGER = 0x4;
static const Shortint SQL_SMALLINT = 0x5;
static const Shortint SQL_FLOAT = 0x6;
static const Shortint SQL_REAL = 0x7;
static const Shortint SQL_DOUBLE = 0x8;
static const Shortint SQL_DATETIME = 0x9;
static const Shortint SQL_VARCHAR = 0xc;
static const Shortint SQL_TYPE_DATE = 0x5b;
static const Shortint SQL_TYPE_TIME = 0x5c;
static const Shortint SQL_TYPE_TIMESTAMP = 0x5d;
static const Shortint SQL_UNSPECIFIED = 0x0;
static const Shortint SQL_INSENSITIVE = 0x1;
static const Shortint SQL_SENSITIVE = 0x2;
static const Shortint SQL_ALL_TYPES = 0x0;
static const Shortint SQL_DEFAULT = 0x63;
static const Shortint SQL_ARD_TYPE = 0xffffff9d;
static const Shortint SQL_CODE_DATE = 0x1;
static const Shortint SQL_CODE_TIME = 0x2;
static const Shortint SQL_CODE_TIMESTAMP = 0x3;
static const Shortint SQL_FALSE = 0x0;
static const Shortint SQL_TRUE = 0x1;
static const Shortint SQL_NO_NULLS = 0x0;
static const Shortint SQL_NULLABLE = 0x1;
static const Shortint SQL_NULLABLE_UNKNOWN = 0x2;
static const Shortint SQL_PRED_NONE = 0x0;
static const Shortint SQL_PRED_CHAR = 0x1;
static const Shortint SQL_PRED_BASIC = 0x2;
static const Shortint SQL_NAMED = 0x0;
static const Shortint SQL_UNNAMED = 0x1;
static const Shortint SQL_DESC_ALLOC_AUTO = 0x1;
static const Shortint SQL_DESC_ALLOC_USER = 0x2;
static const Shortint SQL_CLOSE = 0x0;
static const Shortint SQL_DROP = 0x1;
static const Shortint SQL_UNBIND = 0x2;
static const Shortint SQL_RESET_PARAMS = 0x3;
static const Shortint SQL_FETCH_NEXT = 0x1;
static const Shortint SQL_FETCH_FIRST = 0x2;
static const Shortint SQL_FETCH_LAST = 0x3;
static const Shortint SQL_FETCH_PRIOR = 0x4;
static const Shortint SQL_FETCH_ABSOLUTE = 0x5;
static const Shortint SQL_FETCH_RELATIVE = 0x6;
static const Shortint SQL_COMMIT = 0x0;
static const Shortint SQL_ROLLBACK = 0x1;
static const Shortint SQL_NULL_HENV = 0x0;
static const Shortint SQL_NULL_HDBC = 0x0;
static const Shortint SQL_NULL_HSTMT = 0x0;
static const Shortint SQL_NULL_HDESC = 0x0;
static const Shortint SQL_NULL_HANDLE = 0x0;
static const Shortint SQL_SCOPE_CURROW = 0x0;
static const Shortint SQL_SCOPE_TRANSACTION = 0x1;
static const Shortint SQL_SCOPE_SESSION = 0x2;
static const Shortint SQL_PC_UNKNOWN = 0x0;
static const Shortint SQL_PC_NON_PSEUDO = 0x1;
static const Shortint SQL_PC_PSEUDO = 0x2;
static const Shortint SQL_ROW_IDENTIFIER = 0x1;
static const Shortint SQL_INDEX_UNIQUE = 0x0;
static const Shortint SQL_INDEX_ALL = 0x1;
static const Shortint SQL_INDEX_CLUSTERED = 0x1;
static const Shortint SQL_INDEX_HASHED = 0x2;
static const Shortint SQL_INDEX_OTHER = 0x3;
static const Shortint SQL_API_SQLALLOCCONNECT = 0x1;
static const Shortint SQL_API_SQLALLOCENV = 0x2;
static const Word SQL_API_SQLALLOCHANDLE = 0x3e9;
static const Shortint SQL_API_SQLALLOCSTMT = 0x3;
static const Shortint SQL_API_SQLBINDCOL = 0x4;
static const Word SQL_API_SQLBINDPARAM = 0x3ea;
static const Shortint SQL_API_SQLCANCEL = 0x5;
static const Word SQL_API_SQLCLOSECURSOR = 0x3eb;
static const Shortint SQL_API_SQLCOLATTRIBUTE = 0x6;
static const Shortint SQL_API_SQLCOLUMNS = 0x28;
static const Shortint SQL_API_SQLCONNECT = 0x7;
static const Word SQL_API_SQLCOPYDESC = 0x3ec;
static const Shortint SQL_API_SQLDATASOURCES = 0x39;
static const Shortint SQL_API_SQLDESCRIBECOL = 0x8;
static const Shortint SQL_API_SQLDISCONNECT = 0x9;
static const Word SQL_API_SQLENDTRAN = 0x3ed;
static const Shortint SQL_API_SQLERROR = 0xa;
static const Shortint SQL_API_SQLEXECDIRECT = 0xb;
static const Shortint SQL_API_SQLEXECUTE = 0xc;
static const Shortint SQL_API_SQLFETCH = 0xd;
static const Word SQL_API_SQLFETCHSCROLL = 0x3fd;
static const Shortint SQL_API_SQLFREECONNECT = 0xe;
static const Shortint SQL_API_SQLFREEENV = 0xf;
static const Word SQL_API_SQLFREEHANDLE = 0x3ee;
static const Shortint SQL_API_SQLFREESTMT = 0x10;
static const Word SQL_API_SQLGETCONNECTATTR = 0x3ef;
static const Shortint SQL_API_SQLGETCONNECTOPTION = 0x2a;
static const Shortint SQL_API_SQLGETCURSORNAME = 0x11;
static const Shortint SQL_API_SQLGETDATA = 0x2b;
static const Word SQL_API_SQLGETDESCFIELD = 0x3f0;
static const Word SQL_API_SQLGETDESCREC = 0x3f1;
static const Word SQL_API_SQLGETDIAGFIELD = 0x3f2;
static const Word SQL_API_SQLGETDIAGREC = 0x3f3;
static const Word SQL_API_SQLGETENVATTR = 0x3f4;
static const Shortint SQL_API_SQLGETFUNCTIONS = 0x2c;
static const Shortint SQL_API_SQLGETINFO = 0x2d;
static const Word SQL_API_SQLGETSTMTATTR = 0x3f6;
static const Shortint SQL_API_SQLGETSTMTOPTION = 0x2e;
static const Shortint SQL_API_SQLGETTYPEINFO = 0x2f;
static const Shortint SQL_API_SQLNUMRESULTCOLS = 0x12;
static const Shortint SQL_API_SQLPARAMDATA = 0x30;
static const Shortint SQL_API_SQLPREPARE = 0x13;
static const Shortint SQL_API_SQLPUTDATA = 0x31;
static const Shortint SQL_API_SQLROWCOUNT = 0x14;
static const Word SQL_API_SQLSETCONNECTATTR = 0x3f8;
static const Shortint SQL_API_SQLSETCONNECTOPTION = 0x32;
static const Shortint SQL_API_SQLSETCURSORNAME = 0x15;
static const Word SQL_API_SQLSETDESCFIELD = 0x3f9;
static const Word SQL_API_SQLSETDESCREC = 0x3fa;
static const Word SQL_API_SQLSETENVATTR = 0x3fb;
static const Shortint SQL_API_SQLSETPARAM = 0x16;
static const Word SQL_API_SQLSETSTMTATTR = 0x3fc;
static const Shortint SQL_API_SQLSETSTMTOPTION = 0x33;
static const Shortint SQL_API_SQLSPECIALCOLUMNS = 0x34;
static const Shortint SQL_API_SQLSTATISTICS = 0x35;
static const Shortint SQL_API_SQLTABLES = 0x36;
static const Shortint SQL_API_SQLTRANSACT = 0x17;
static const Shortint SQL_MAX_DRIVER_CONNECTIONS = 0x0;
static const Shortint SQL_MAXIMUM_DRIVER_CONNECTIONS = 0x0;
static const Shortint SQL_MAX_CONCURRENT_ACTIVITIES = 0x1;
static const Shortint SQL_MAXIMUM_CONCURRENT_ACTIVITIES = 0x1;
static const Shortint SQL_DATA_SOURCE_NAME = 0x2;
static const Shortint SQL_FETCH_DIRECTION = 0x8;
static const Shortint SQL_SERVER_NAME = 0xd;
static const Shortint SQL_SEARCH_PATTERN_ESCAPE = 0xe;
static const Shortint SQL_DBMS_NAME = 0x11;
static const Shortint SQL_DBMS_VER = 0x12;
static const Shortint SQL_ACCESSIBLE_TABLES = 0x13;
static const Shortint SQL_ACCESSIBLE_PROCEDURES = 0x14;
static const Shortint SQL_CURSOR_COMMIT_BEHAVIOR = 0x17;
static const Shortint SQL_DATA_SOURCE_READ_ONLY = 0x19;
static const Shortint SQL_DEFAULT_TXN_ISOLATION = 0x1a;
static const Shortint SQL_IDENTIFIER_CASE = 0x1c;
static const Shortint SQL_IDENTIFIER_QUOTE_CHAR = 0x1d;
static const Shortint SQL_MAX_COLUMN_NAME_LEN = 0x1e;
static const Shortint SQL_MAXIMUM_COLUMN_NAME_LENGTH = 0x1e;
static const Shortint SQL_MAX_CURSOR_NAME_LEN = 0x1f;
static const Shortint SQL_MAXIMUM_CURSOR_NAME_LENGTH = 0x1f;
static const Shortint SQL_MAX_SCHEMA_NAME_LEN = 0x20;
static const Shortint SQL_MAXIMUM_SCHEMA_NAME_LENGTH = 0x20;
static const Shortint SQL_MAX_CATALOG_NAME_LEN = 0x22;
static const Shortint SQL_MAXIMUM_CATALOG_NAME_LENGTH = 0x22;
static const Shortint SQL_MAX_TABLE_NAME_LEN = 0x23;
static const Shortint SQL_SCROLL_CONCURRENCY = 0x2b;
static const Shortint SQL_TXN_CAPABLE = 0x2e;
static const Shortint SQL_TRANSACTION_CAPABLE = 0x2e;
static const Shortint SQL_USER_NAME = 0x2f;
static const Shortint SQL_TXN_ISOLATION_OPTION = 0x48;
static const Shortint SQL_TRANSACTION_ISOLATION_OPTION = 0x48;
static const Shortint SQL_INTEGRITY = 0x49;
static const Shortint SQL_GETDATA_EXTENSIONS = 0x51;
static const Shortint SQL_NULL_COLLATION = 0x55;
static const Shortint SQL_ALTER_TABLE = 0x56;
static const Shortint SQL_ORDER_BY_COLUMNS_IN_SELECT = 0x5a;