📄 adoint.pas
字号:
{ *********************************************************************** }
{ }
{ Delphi Runtime Library }
{ }
{ Copyright (c) 1999-2001 Borland Software Corporation }
{ }
{ *********************************************************************** }
{*******************************************************}
{ ADO Interface Unit }
{*******************************************************}
unit ADOInt;
// ********************************************************************* //
// Type Lib: C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\MSADO15.DLL //
// IID\LCID: {00000200-0000-0010-8000-00AA006D2EA4}\0 //
// PASTLWTR : 1.1 //
// HelpString: Microsoft ActiveX Data Objects 2.1 Library //
// Version: 2.1 //
// ********************************************************************* //
interface
uses Windows, ActiveX;
// ********************************************************************* //
// GUIDS declared in the TypeLibrary. Following prefixes are used: //
// Type Libraries : LIBID_xxxx //
// CoClasses : CLASS_xxxx //
// DISPInterfaces : DIID_xxxx //
// Non-DISP interfaces: IID_xxxx //
// ********************************************************************* //
const
LIBID_ADODB: TGUID = '{00000201-0000-0010-8000-00AA006D2EA4}';
CLASS_Connection: TGUID = '{00000514-0000-0010-8000-00AA006D2EA4}';
CLASS_Command: TGUID = '{00000507-0000-0010-8000-00AA006D2EA4}';
CLASS_Recordset: TGUID = '{00000535-0000-0010-8000-00AA006D2EA4}';
CLASS_Parameter: TGUID = '{0000050B-0000-0010-8000-00AA006D2EA4}';
CLASS_DataSpace: TGUID = '{BD96C556-65A3-11D0-983A-00C04FC29E36}';
CLASS_DataFactory: TGUID = '{9381D8F5-0288-11D0-9501-00AA00B911A5}';
IID__Collection: TGUID = '{00000512-0000-0010-8000-00AA006D2EA4}';
IID__DynaCollection: TGUID = '{00000513-0000-0010-8000-00AA006D2EA4}';
IID__ADO: TGUID = '{00000534-0000-0010-8000-00AA006D2EA4}';
IID_Properties: TGUID = '{00000504-0000-0010-8000-00AA006D2EA4}';
IID_Property_: TGUID = '{00000503-0000-0010-8000-00AA006D2EA4}';
IID_Error: TGUID = '{00000500-0000-0010-8000-00AA006D2EA4}';
IID_Errors: TGUID = '{00000501-0000-0010-8000-00AA006D2EA4}';
IID_Command15: TGUID = '{00000508-0000-0010-8000-00AA006D2EA4}';
IID_Connection15: TGUID = '{00000515-0000-0010-8000-00AA006D2EA4}';
IID__Connection: TGUID = '{00000550-0000-0010-8000-00AA006D2EA4}';
IID_Recordset15: TGUID = '{0000050E-0000-0010-8000-00AA006D2EA4}';
IID_Recordset20: TGUID = '{0000054F-0000-0010-8000-00AA006D2EA4}';
IID__Recordset: TGUID = '{00000555-0000-0010-8000-00AA006D2EA4}';
IID_Fields15: TGUID = '{00000506-0000-0010-8000-00AA006D2EA4}';
IID_Fields: TGUID = '{0000054D-0000-0010-8000-00AA006D2EA4}';
IID_Field: TGUID = '{0000054C-0000-0010-8000-00AA006D2EA4}';
IID__Parameter: TGUID = '{0000050C-0000-0010-8000-00AA006D2EA4}';
IID_Parameters: TGUID = '{0000050D-0000-0010-8000-00AA006D2EA4}';
IID__Command: TGUID = '{0000054E-0000-0010-8000-00AA006D2EA4}';
IID_ConnectionEventsVt: TGUID = '{00000402-0000-0010-8000-00AA006D2EA4}';
DIID_ConnectionEvents: TGUID = '{00000400-0000-0010-8000-00AA006D2EA4}';
IID_RecordsetEventsVt: TGUID = '{00000403-0000-0010-8000-00AA006D2EA4}';
DIID_RecordsetEvents: TGUID = '{00000266-0000-0010-8000-00AA006D2EA4}';
IID_ADOConnectionConstruction15: TGUID = '{00000516-0000-0010-8000-00AA006D2EA4}';
IID_ADOConnectionConstruction: TGUID = '{00000551-0000-0010-8000-00AA006D2EA4}';
IID_ADOCommandConstruction: TGUID = '{00000517-0000-0010-8000-00AA006D2EA4}';
IID_ADORecordsetConstruction: TGUID = '{00000283-0000-0010-8000-00AA006D2EA4}';
IID_Field15: TGUID = '{00000505-0000-0010-8000-00AA006D2EA4}';
IID_IDataspace: TGUID = '{BD96C556-65A3-11D0-983A-00C04FC29E34}';
// *********************************************************************//
// Misc. Constants (not from Type Library) //
// *********************************************************************//
// ConnectionString Tags
const
CT_USERID = 'USER ID='; { Do not localize }
CT_PROVIDER = 'PROVIDER='; { Do not localize }
CT_FILENAME = 'FILE NAME='; { Do not localize }
// *********************************************************************//
// Declaration of Enumerations defined in Type Library //
// *********************************************************************//
// CursorTypeEnum constants
type
CursorTypeEnum = TOleEnum;
{$EXTERNALSYM CursorTypeEnum}
const
adOpenUnspecified = $FFFFFFFF;
{$EXTERNALSYM adOpenUnspecified}
adOpenForwardOnly = $00000000;
{$EXTERNALSYM adOpenForwardOnly}
adOpenKeyset = $00000001;
{$EXTERNALSYM adOpenKeyset}
adOpenDynamic = $00000002;
{$EXTERNALSYM adOpenDynamic}
adOpenStatic = $00000003;
{$EXTERNALSYM adOpenStatic}
// CursorOptionEnum constants
type
CursorOptionEnum = TOleEnum;
{$EXTERNALSYM CursorOptionEnum}
const
adHoldRecords = $00000100;
{$EXTERNALSYM adHoldRecords}
adMovePrevious = $00000200;
{$EXTERNALSYM adMovePrevious}
adAddNew = $01000400;
{$EXTERNALSYM adAddNew}
adDelete = $01000800;
{$EXTERNALSYM adDelete}
adUpdate = $01008000;
{$EXTERNALSYM adUpdate}
adBookmark = $00002000;
{$EXTERNALSYM adBookmark}
adApproxPosition = $00004000;
{$EXTERNALSYM adApproxPosition}
adUpdateBatch = $00010000;
{$EXTERNALSYM adUpdateBatch}
adResync = $00020000;
{$EXTERNALSYM adResync}
adNotify = $00040000;
{$EXTERNALSYM adNotify}
adFind = $00080000;
{$EXTERNALSYM adFind}
adSeek = $00400000;
{$EXTERNALSYM adSeek}
adIndex = $00800000;
{$EXTERNALSYM adIndex}
// LockTypeEnum constants
type
LockTypeEnum = TOleEnum;
{$EXTERNALSYM LockTypeEnum}
const
adLockUnspecified = $FFFFFFFF;
{$EXTERNALSYM adLockUnspecified}
adLockReadOnly = $00000001;
{$EXTERNALSYM adLockReadOnly}
adLockPessimistic = $00000002;
{$EXTERNALSYM adLockPessimistic}
adLockOptimistic = $00000003;
{$EXTERNALSYM adLockOptimistic}
adLockBatchOptimistic = $00000004;
{$EXTERNALSYM adLockBatchOptimistic}
// ExecuteOptionEnum constants
type
ExecuteOptionEnum = TOleEnum;
{$EXTERNALSYM ExecuteOptionEnum}
const
adOptionUnspecified = $FFFFFFFF;
{$EXTERNALSYM adOptionUnspecified}
adAsyncExecute = $00000010;
{$EXTERNALSYM adAsyncExecute}
adAsyncFetch = $00000020;
{$EXTERNALSYM adAsyncFetch}
adAsyncFetchNonBlocking = $00000040;
{$EXTERNALSYM adAsyncFetchNonBlocking}
adExecuteNoRecords = $00000080;
{$EXTERNALSYM adExecuteNoRecords}
// ConnectOptionEnum constants
type
ConnectOptionEnum = TOleEnum;
{$EXTERNALSYM ConnectOptionEnum}
const
adConnectUnspecified = $FFFFFFFF;
{$EXTERNALSYM adConnectUnspecified}
adAsyncConnect = $00000010;
{$EXTERNALSYM adAsyncConnect}
// ObjectStateEnum constants
type
ObjectStateEnum = TOleEnum;
{$EXTERNALSYM ObjectStateEnum}
const
adStateClosed = $00000000;
{$EXTERNALSYM adStateClosed}
adStateOpen = $00000001;
{$EXTERNALSYM adStateOpen}
adStateConnecting = $00000002;
{$EXTERNALSYM adStateConnecting}
adStateExecuting = $00000004;
{$EXTERNALSYM adStateExecuting}
adStateFetching = $00000008;
{$EXTERNALSYM adStateFetching}
// CursorLocationEnum constants
type
CursorLocationEnum = TOleEnum;
{$EXTERNALSYM CursorLocationEnum}
const
adUseNone = $00000001;
{$EXTERNALSYM adUseNone}
adUseServer = $00000002;
{$EXTERNALSYM adUseServer}
adUseClient = $00000003;
{$EXTERNALSYM adUseClient}
adUseClientBatch = $00000003;
{$EXTERNALSYM adUseClientBatch}
// DataTypeEnum constants
type
DataTypeEnum = TOleEnum;
{$EXTERNALSYM DataTypeEnum}
const
adEmpty = $00000000;
{$EXTERNALSYM adEmpty}
adTinyInt = $00000010;
{$EXTERNALSYM adTinyInt}
adSmallInt = $00000002;
{$EXTERNALSYM adSmallInt}
adInteger = $00000003;
{$EXTERNALSYM adInteger}
adBigInt = $00000014;
{$EXTERNALSYM adBigInt}
adUnsignedTinyInt = $00000011;
{$EXTERNALSYM adUnsignedTinyInt}
adUnsignedSmallInt = $00000012;
{$EXTERNALSYM adUnsignedSmallInt}
adUnsignedInt = $00000013;
{$EXTERNALSYM adUnsignedInt}
adUnsignedBigInt = $00000015;
{$EXTERNALSYM adUnsignedBigInt}
adSingle = $00000004;
{$EXTERNALSYM adSingle}
adDouble = $00000005;
{$EXTERNALSYM adDouble}
adCurrency = $00000006;
{$EXTERNALSYM adCurrency}
adDecimal = $0000000E;
{$EXTERNALSYM adDecimal}
adNumeric = $00000083;
{$EXTERNALSYM adNumeric}
adBoolean = $0000000B;
{$EXTERNALSYM adBoolean}
adError = $0000000A;
{$EXTERNALSYM adError}
adUserDefined = $00000084;
{$EXTERNALSYM adUserDefined}
adVariant = $0000000C;
{$EXTERNALSYM adVariant}
adIDispatch = $00000009;
{$EXTERNALSYM adIDispatch}
adIUnknown = $0000000D;
{$EXTERNALSYM adIUnknown}
adGUID = $00000048;
{$EXTERNALSYM adGUID}
adDate = $00000007;
{$EXTERNALSYM adDate}
adDBDate = $00000085;
{$EXTERNALSYM adDBDate}
adDBTime = $00000086;
{$EXTERNALSYM adDBTime}
adDBTimeStamp = $00000087;
{$EXTERNALSYM adDBTimeStamp}
adBSTR = $00000008;
{$EXTERNALSYM adBSTR}
adChar = $00000081;
{$EXTERNALSYM adChar}
adVarChar = $000000C8;
{$EXTERNALSYM adVarChar}
adLongVarChar = $000000C9;
{$EXTERNALSYM adLongVarChar}
adWChar = $00000082;
{$EXTERNALSYM adWChar}
adVarWChar = $000000CA;
{$EXTERNALSYM adVarWChar}
adLongVarWChar = $000000CB;
{$EXTERNALSYM adLongVarWChar}
adBinary = $00000080;
{$EXTERNALSYM adBinary}
adVarBinary = $000000CC;
{$EXTERNALSYM adVarBinary}
adLongVarBinary = $000000CD;
{$EXTERNALSYM adLongVarBinary}
adChapter = $00000088;
{$EXTERNALSYM adChapter}
adFileTime = $00000040;
{$EXTERNALSYM adFileTime}
adDBFileTime = $00000089;
{$EXTERNALSYM adDBFileTime}
adPropVariant = $0000008A;
{$EXTERNALSYM adPropVariant}
adVarNumeric = $0000008B;
{$EXTERNALSYM adVarNumeric}
// FieldAttributeEnum constants
type
FieldAttributeEnum = TOleEnum;
{$EXTERNALSYM FieldAttributeEnum}
const
adFldUnspecified = $FFFFFFFF;
{$EXTERNALSYM adFldUnspecified}
adFldMayDefer = $00000002;
{$EXTERNALSYM adFldMayDefer}
adFldUpdatable = $00000004;
{$EXTERNALSYM adFldUpdatable}
adFldUnknownUpdatable = $00000008;
{$EXTERNALSYM adFldUnknownUpdatable}
adFldFixed = $00000010;
{$EXTERNALSYM adFldFixed}
adFldIsNullable = $00000020;
{$EXTERNALSYM adFldIsNullable}
adFldMayBeNull = $00000040;
{$EXTERNALSYM adFldMayBeNull}
adFldLong = $00000080;
{$EXTERNALSYM adFldLong}
adFldRowID = $00000100;
{$EXTERNALSYM adFldRowID}
adFldRowVersion = $00000200;
{$EXTERNALSYM adFldRowVersion}
adFldCacheDeferred = $00001000;
{$EXTERNALSYM adFldCacheDeferred}
adFldNegativeScale = $00004000;
{$EXTERNALSYM adFldNegativeScale}
adFldKeyColumn = $00008000;
{$EXTERNALSYM adFldKeyColumn}
// EditModeEnum constants
type
EditModeEnum = TOleEnum;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -