Programlama yapalım ve Öğrenelim. - Delphi Eğitim65
  Ana Sayfa
  .NET Eğitim Notları
  Visual C# .NET Örnek Kodları
  VisualBasic.NET Örnek Kodları
  J# Örnekleri
  ASP.NET Örnek Kodları
  Delphi Eğitim
  => Delphi Eğitim1
  => Delphi Eğitim2
  => Delphi Eğitim3
  => Delphi Eğitim4
  => Delphi Eğitim5
  => Delphi Eğitim6
  => Delphi Eğitim7
  => Delphi Eğitim8
  => Delphi Eğitim9
  => Delphi Eğitim10
  => Delphi Eğitim11
  => Delphi Eğitim13
  => Delphi Eğitim14
  => Delphi Eğitim15
  => Delphi Eğitim16
  => Delphi Eğitim17
  => Delphi Eğitim18
  => Delphi Eğitim19
  => Delphi Eğitim20
  => Delphi Eğitim21
  => Delphi Eğitim22
  => Delphi Eğitim23
  => Delphi Eğitim24
  => Delphi Eğitim25
  => Delphi Eğitim26
  => Delphi Eğitim27
  => Delphi Eğitim28
  => Delphi Eğitim29
  => Delphi Eğitim30
  => Delphi Eğtim31
  => Delphi Eğitim32
  => Delphi Eğitim33
  => Delphi Eğitim34
  => Delphi Eğitim35
  => Delphi Eğitim36
  => Delphi Eğitim37
  => Delphi Eğitim38
  => Delphi Eğitim39
  => Delphi Eğitim40
  => Delphi Eğitim41
  => Delphi Eğitim42
  => Delphi Eğitim43
  => Delphi Eğitim44
  => Delphi Eğitim45
  => Delphi Eğitim46
  => Delphi Eğitim47
  => Delphi Eğitim48
  => Delphi Eğitim49
  => Delphi Eğitim50
  => Delphi Eğitim51
  => Delphi Eğitim52
  => Delphi Eğitim53
  => Delphi Eğitim54
  => Delphi Eğitim55
  => Delphi Eğitim56
  => Delphi Eğitim57
  => Delphi Eğitim58
  => Delphi Eğitim59
  => Delphi Eğitim60
  => Delphi Eğitim61
  => Delphi Eğitim62
  => Delphi Eğitim63
  => Delphi Eğitim64
  => Delphi Eğitim65
  => Delphi Eğitim66
  => Delphi Eğitim67
  => Delphi Eğitim68
  => Delphi Eğitim69
  => Delphi Eğitim70
  => Delphi Eğitim71
  => Delphi Eğitim72
  => Delphi Eğitim73
  => Delphi Eğitim74
  => Delphi Eğitim75
  => Delphi Eğitim76
  => Delphi Eğitim77
  => Delphi Eğitim78
  => Delphi Eğitim79
  => Delphi Eğitim80
  => Delphi Eğitim81
  => Delphi Eğitim82
  => Delphi Eğitim83
  => Delphi Eğitim84
  => Delphi Eğitim85
  => Delphi Eğitim86
  => Delphi Eğitim87
  => Delphi Eğitim88
  => Delphi Eğitim89
  => Delphi Eğitim90
  => Delphi Eğitim91
  => Delphi Eğitim92
  => Delphi Eğitim93
  => Delphi Eğitim94
  => Delphi Eğitim95
  => Delphi Eğitim96
  => Delphi Eğitim97
  => Delphi Eğitim98
  => Delphi Eğitim99
  => Delphi Eğitim100
  => Delphi Eğitim101
  => Delphi Eğitim102
  => Delphi Eğitim103
  => Delphi Eğitim104
  => Delphi Eğitim105
  => Delphi Eğitim106
  => Delphi Eğitim107
  => Delphi Eğitim108
  => Delphi Eğitim109
  => Delphi Eğitim110
  => Delphi Eğitim111
  => Delphi Eğitim112
  => Delphi Eğitim113
  => Delphi Eğitim114
  => Delphi Eğitim115
  => Delphi Eğitim116
  => Delphi Eğitim117
  => Delphi Eğitim118
  => Delphi Eğitim119
  => Delphi Eğitim120
  => Delphi Eğitim121
  => Delphi Eğitim122
  => Delphi Eğitim123
  => Delphi Eğitim124
  => Delphi Eğitim125
  => Delphi Eğitim126
  => Delphi Eğitim127
  => Delphi Eğitim128
  => Delphi Eğitim129
  => Delphi Eğitim130
  => Delphi Eğitim131
  => Delphi Eğitim132
  => Delphi Eğitim133
  => Delphi Eğitim134
  => Delphi Eğitim135
  => Delphi Eğitim136
  => Delphi Eğitim137
  => Delphi Eğitim138
  => Delphi Eğitim139
  => Delphi Eğitim140
  => Delphi Eğitim141
  => Delphi Eğitim142
  => Delphi Eğitim143
  => Delphi Eğitim144
  => Delphi Eğitim145
  => Delphi Eğitim146
  => Delphi eğitim147
  => Delphi Eğitim148
  => Delphi Eğitim149
  => Delphi Eğitim150
  => Delphi Eğitim151
  => Delphi Eğitim152
  => Delphi Eğitim153
  => Delphi Eğitim154
  => Delphi Eğitim155
  => Delphi Eğitim156
  => Delphi Eğitim157
  => Delphi Eğitim158
  => Delphi Eğitim159
  => Delphi Eğitim160
  => Delphi Eğitim161
  => Delphi Eğitim162
  => Delphi Eğitim164
  => Delphi Eğitim165
  => Delphi Eğitim166
  => Delphi Eğitim167
  => Delphi Eğitim168
  => Delphi Eğitim169
  => Delphi Eğitim170
  => Delphi Eğitim171
  => Delphi Eğitim172
  => Delphi Eğitim173
  => Delphi Eğitim174
  => Delphi Eğitim175
  => Delphi Eğitim176
  => Delphi Eğitim177
  => Delphi Eğitim178
  => Delphi Eğitim179
  => Delphi Eğitim180
  => Delphi Eğitim181
  => Delphi Eğitim182
  => Delphi Eğitim183
  => Delphi Eğitim184
  => Delphi Eğitim185
  => Delphi Eğitim186
  => Delphi Eğitim187
  => Delphi Eğitim188
  => Delphi Eğitim189
  => Delphi Eğitim190
  => Delphi Eğitim191
  => Delphi Eğitim192
  => Delphi Eğitim193
  => Delphi Eğitim194
  => Delphi Eğitim195
  => Delphi Eğitim196
  => Delphi Eğitim197
  => Delphi Eğitim198
  => Delphi Eğitim199
  => Delphi Eğitim200
  => Delphi Eğitim201
  => Delphi Eğitim202
  => Delphi Eğitim203
  => Delphi Eğitim204
  => Delphi Eğitim205
  => Delphi Eğitim206
  => Delphi Eğitim207
  => Delphi Eğitim208
  => Delphi Eğitim209
  => Delphi Eğitim210
  => Delphi Eğitim211
  => Delphi Eğitim212
  => Delphi Eğitim213
  => Delphi Eğitim214
  => Delphi Eğitim215
  => Delphi Eğitim216
  => Delphi Eğitim217
  => Delphi Eğitim218
  => Delphi Eğitim219
  => Delphi Eğitim220
  => Delphi Eğitim221
  => Delphi Eğitim222
  => Delphi Eğitim223
  => Delphi Eğitim224
  => Delphi Eğitim225
  => Delphi Eğitim226
  => Delphi Eğitim227
  => Delphi Eğitim228
  => Delphi Eğitim229
  => Delphi Eğitim230
  => Delphi Eğitim231
  => Delphi Eğitim232
  => Delphi Eğitim233
  => Delphi Eğitim234
  => Delphi Eğitim235
  => Delphi Eğitim236
  => Delphi Eğitim237
  => Delphi Eğitim238
  => Delphi Eğitim239
  => Delphi Eğitim240
  => Delphi Eğitim241
  => Delphi Eğitim242
  İletişim

DBSearch

unit DBSearch;

 

interface

 

uses

  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,

  StdCtrls, Db, DbCtrls;

 

type

  TCustomSearchEdit = class(TCustomEdit)

  private

    { Private declarations }

    FDataLink: TFieldDataLink;

    FSearchOptions: TLocateOptions;

    procedure DataChange(Sender : Tobject);

    function GetDataSource : TDataSource;

    function GetDataField : string;

    procedure SetDataSource(Value : TDataSource);

    procedure SetDataField(const Value : string);

    procedure SetSearchOptions(const Value :TLocateOptions);

    procedure CMChanged(var Message: TMessage); message CM_CHANGED;

  protected

    { Protected declarations }

  public

    { Public declarations }

    constructor Create(AOwner: TComponent); override;

    destructor Destroy; override;

    property SearchOptions: TLocateOptions read FSearchOptions

             write SetSearchOptions default [loCaseInsensitive, loPartialKey];

  published

    { Published declarations }

    property DataSource: TDataSource read GetDataSource write SetDataSource;

    property DataField: string read GetDataField write SetDataField;

    property TabStop default True;

  end;

 

  TSearchEdit = class(TCustomSearchEdit)

  published

    property SearchOptions default [loCaseInsensitive, loPartialKey];

    property AutoSelect;

    property AutoSize;

    property BorderStyle;

    property CharCase;

    property Color;

    property Ctl3D;

    property DragCursor;

    property DragMode;

    property Enabled;

    property Font;

    property HideSelection;

    property ImeMode;

    property ImeName;

    property MaxLength;

    property OEMConvert;

    property ParentColor;

    property ParentCtl3D;

    property ParentFont;

    property ParentShowHint;

    property PasswordChar;

    property PopupMenu;

    property ReadOnly;

    property ShowHint;

    property TabOrder;

    property TabStop;

    property Text;

    property Visible;

    property OnChange;

    property OnClick;

    property OnDblClick;

    property OnDragDrop;

    property OnDragOver;

    property OnEndDrag;

    property OnEnter;

    property OnExit;

    property OnKeyDown;

    property OnKeyPress;

    property OnKeyUp;

    property OnMouseDown;

    property OnMouseMove;

    property OnMouseUp;

    property OnStartDrag;

  end;

 

procedure Register;

 

implementation

 

constructor TCustomSearchEdit.Create;

begin

  inherited Create(AOwner);

  FDataLink := TFieldDataLink.Create;

  FDataLink.Control := Self;

  FDataLink.OnDataChange := DataChange;

  FSearchOptions := [loCaseInsensitive, loPartialKey];

end;

 

destructor TCustomSearchEdit.Destroy;

begin

  FDataLink.Free;

  FDataLink := nil;

  inherited Destroy;

end;

 

procedure TCustomSearchEdit.DataChange(Sender: TObject);

begin

  if FDataLink.Field <> nil then

  begin

    if Screen.ActiveControl <> Self then

    begin

      if FDataLink.CanModify then

         Text := FDataLink.Field.Text

      else

      begin

        Text := FDataLink.Field.DisplayText;

      end;

      SelectAll;

    end;

  end else

  begin

    if csDesigning in ComponentState then

      Text := Name else

      Text := '';

  end;

end;

 

procedure TCustomSearchEdit.CMChanged;

begin

  if not ((csDesigning in ComponentState) and

         (csLoading in ComponentState)) then

  begin

    if Screen.ActiveControl = Self then

       FDataLink.DataSet.Locate(FDataLink.FieldName, Text,

       FSearchOptions);

  end;

end;

 

function TCustomSearchEdit.GetDataSource: TDataSource;

begin

  Result := FDataLink.DataSource;

end;

 

procedure TCustomSearchEdit.SetDataSource(Value: TDataSource);

begin

  FDataLink.DataSource := Value;

  if Value <> nil then Value.FreeNotification(Self);

end;

 

function TCustomSearchEdit.GetDataField: string;

begin

  Result := FDataLink.FieldName;

end;

 

procedure TCustomSearchEdit.SetDataField(const Value: string);

begin

  FDataLink.FieldName := Value;

end;

 

procedure TCustomSearchEdit.SetSearchOptions(const Value :TLocateOptions);

begin

  FSearchOptions := Value;

end;

 

procedure Register;

begin

  RegisterComponents('Technisoft', [TSearchEdit]);

end;

 

end.

 

Delphi - .....................................

 

ADODB_TLB

unit ADODB_TLB;

 

interface

 

uses Windows, ActiveX, Classes, Graphics, OleCtrls, StdVCL;

 

// *********************************************************************//

// 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}';

  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}';

  IID_RecordsetEventsVt: TGUID = '{00000403-0000-0010-8000-00AA006D2EA4}';

  DIID_ConnectionEvents: TGUID = '{00000400-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}';

  CLASS_Connection: TGUID = '{00000514-0000-0010-8000-00AA006D2EA4}';

  IID_ADOCommandConstruction: TGUID = '{00000517-0000-0010-8000-00AA006D2EA4}';

  CLASS_Command: TGUID = '{00000507-0000-0010-8000-00AA006D2EA4}';

  CLASS_Recordset: TGUID = '{00000535-0000-0010-8000-00AA006D2EA4}';

  IID_ADORecordsetConstruction: TGUID = '{00000283-0000-0010-8000-00AA006D2EA4}';

  IID_Field15: TGUID = '{00000505-0000-0010-8000-00AA006D2EA4}';

  CLASS_Parameter: TGUID = '{0000050B-0000-0010-8000-00AA006D2EA4}';

 

// *********************************************************************//

// Declaration of Enumerations defined in Type Library                  //

// *********************************************************************//

// CursorTypeEnum constants

type

  CursorTypeEnum = TOleEnum;

const

  adOpenUnspecified = $FFFFFFFF;

  adOpenForwardOnly = $00000000;

  adOpenKeyset = $00000001;

  adOpenDynamic = $00000002;

  adOpenStatic = $00000003;

 

// CursorOptionEnum constants

type

  CursorOptionEnum = TOleEnum;

const

  adHoldRecords = $00000100;

  adMovePrevious = $00000200;

  adAddNew = $01000400;

  adDelete = $01000800;

  adUpdate = $01008000;

  adBookmark = $00002000;

  adApproxPosition = $00004000;

  adUpdateBatch = $00010000;

  adResync = $00020000;

  adNotify = $00040000;

  adFind = $00080000;

  adSeek = $00400000;

  adIndex = $00800000;

 

// LockTypeEnum constants

type

  LockTypeEnum = TOleEnum;

const

  adLockUnspecified = $FFFFFFFF;

  adLockReadOnly = $00000001;

  adLockPessimistic = $00000002;

  adLockOptimistic = $00000003;

  adLockBatchOptimistic = $00000004;

 

// ExecuteOptionEnum constants

type

  ExecuteOptionEnum = TOleEnum;

const

  adOptionUnspecified = $FFFFFFFF;

  adAsyncExecute = $00000010;

  adAsyncFetch = $00000020;

  adAsyncFetchNonBlocking = $00000040;

  adExecuteNoRecords = $00000080;

 

// ConnectOptionEnum constants

type

  ConnectOptionEnum = TOleEnum;

const

  adConnectUnspecified = $FFFFFFFF;

  adAsyncConnect = $00000010;

 

// ObjectStateEnum constants

type

  ObjectStateEnum = TOleEnum;

const

  adStateClosed = $00000000;

  adStateOpen = $00000001;

  adStateConnecting = $00000002;

  adStateExecuting = $00000004;

  adStateFetching = $00000008;

 

// CursorLocationEnum constants

type

  CursorLocationEnum = TOleEnum;

const

  adUseNone = $00000001;

  adUseServer = $00000002;

  adUseClient = $00000003;

  adUseClientBatch = $00000003;

 

// DataTypeEnum constants

type

  DataTypeEnum = TOleEnum;

const

  adEmpty = $00000000;

  adTinyInt = $00000010;

  adSmallInt = $00000002;

  adInteger = $00000003;

  adBigInt = $00000014;

  adUnsignedTinyInt = $00000011;

  adUnsignedSmallInt = $00000012;

  adUnsignedInt = $00000013;

  adUnsignedBigInt = $00000015;

  adSingle = $00000004;

  adDouble = $00000005;

  adCurrency = $00000006;

  adDecimal = $0000000E;

  adNumeric = $00000083;

  adBoolean = $0000000B;

  adError = $0000000A;

  adUserDefined = $00000084;

  adVariant = $0000000C;

  adIDispatch = $00000009;

  adIUnknown = $0000000D;

  adGUID = $00000048;

  adDate = $00000007;

  adDBDate = $00000085;

  adDBTime = $00000086;

  adDBTimeStamp = $00000087;

  adBSTR = $00000008;

  adChar = $00000081;

  adVarChar = $000000C8;

  adLongVarChar = $000000C9;

  adWChar = $00000082;

  adVarWChar = $000000CA;

  adLongVarWChar = $000000CB;

  adBinary = $00000080;

  adVarBinary = $000000CC;

  adLongVarBinary = $000000CD;

  adChapter = $00000088;

  adFileTime = $00000040;

  adDBFileTime = $00000089;

  adPropVariant = $0000008A;

  adVarNumeric = $0000008B;

 

// FieldAttributeEnum constants

type

  FieldAttributeEnum = TOleEnum;

const

  adFldUnspecified = $FFFFFFFF;

  adFldMayDefer = $00000002;

  adFldUpdatable = $00000004;

  adFldUnknownUpdatable = $00000008;

  adFldFixed = $00000010;

  adFldIsNullable = $00000020;

  adFldMayBeNull = $00000040;

  adFldLong = $00000080;

  adFldRowID = $00000100;

  adFldRowVersion = $00000200;

  adFldCacheDeferred = $00001000;

  adFldNegativeScale = $00004000;

  adFldKeyColumn = $00008000;

 

// EditModeEnum constants

type

  EditModeEnum = TOleEnum;

const

  adEditNone = $00000000;

  adEditInProgress = $00000001;

  adEditAdd = $00000002;

  adEditDelete = $00000004;

 

// RecordStatusEnum constants

type

  RecordStatusEnum = TOleEnum;

const

  adRecOK = $00000000;

  adRecNew = $00000001;

  adRecModified = $00000002;

  adRecDeleted = $00000004;

  adRecUnmodified = $00000008;

  adRecInvalid = $00000010;

  adRecMultipleChanges = $00000040;

  adRecPendingChanges = $00000080;

  adRecCanceled = $00000100;

  adRecCantRelease = $00000400;

  adRecConcurrencyViolation = $00000800;

  adRecIntegrityViolation = $00001000;

  adRecMaxChangesExceeded = $00002000;

  adRecObjectOpen = $00004000;

  adRecOutOfMemory = $00008000;

  adRecPermissionDenied = $00010000;

  adRecSchemaViolation = $00020000;

  adRecDBDeleted = $00040000;

 

// GetRowsOptionEnum constants

type

  GetRowsOptionEnum = TOleEnum;

const

  adGetRowsRest = $FFFFFFFF;

 

// PositionEnum constants

type

  PositionEnum = TOleEnum;

const

  adPosUnknown = $FFFFFFFF;

  adPosBOF = $FFFFFFFE;

  adPosEOF = $FFFFFFFD;

 

// BookmarkEnum constants

type

  BookmarkEnum = TOleEnum;

const

  adBookmarkCurrent = $00000000;

  adBookmarkFirst = $00000001;

  adBookmarkLast = $00000002;

 

// MarshalOptionsEnum constants

type

  MarshalOptionsEnum = TOleEnum;

const

  adMarshalAll = $00000000;

  adMarshalModifiedOnly = $00000001;

 

// AffectEnum constants

type

  AffectEnum = TOleEnum;

const

  adAffectCurrent = $00000001;

  adAffectGroup = $00000002;

  adAffectAll = $00000003;

  adAffectAllChapters = $00000004;

 

// ResyncEnum constants

type

  ResyncEnum = TOleEnum;

const

  adResyncUnderlyingValues = $00000001;

  adResyncAllValues = $00000002;

 

// CompareEnum constants

type

  CompareEnum = TOleEnum;

const

  adCompareLessThan = $00000000;

  adCompareEqual = $00000001;

  adCompareGreaterThan = $00000002;

  adCompareNotEqual = $00000003;

  adCompareNotComparable = $00000004;

 

// FilterGroupEnum constants

type

  FilterGroupEnum = TOleEnum;

const

  adFilterNone = $00000000;

  adFilterPendingRecords = $00000001;

  adFilterAffectedRecords = $00000002;

  adFilterFetchedRecords = $00000003;

  adFilterPredicate = $00000004;

  adFilterConflictingRecords = $00000005;

 

// SearchDirectionEnum constants

type

  SearchDirectionEnum = TOleEnum;

const

  adSearchForward = $00000001;

  adSearchBackward = $FFFFFFFF;

 

// PersistFormatEnum constants

type

  PersistFormatEnum = TOleEnum;

const

  adPersistADTG = $00000000;

  adPersistXML = $00000001;

 

// StringFormatEnum constants

type

  StringFormatEnum = TOleEnum;

const

  adClipString = $00000002;

 

// ConnectPromptEnum constants

type

  ConnectPromptEnum = TOleEnum;

const

  adPromptAlways = $00000001;

  adPromptComplete = $00000002;

  adPromptCompleteRequired = $00000003;

  adPromptNever = $00000004;

 

// ConnectModeEnum constants

type

  ConnectModeEnum = TOleEnum;

const

  adModeUnknown = $00000000;

  adModeRead = $00000001;

  adModeWrite = $00000002;

  adModeReadWrite = $00000003;

  adModeShareDenyRead = $00000004;

  adModeShareDenyWrite = $00000008;

  adModeShareExclusive = $0000000C;

  adModeShareDenyNone = $00000010;

 

// IsolationLevelEnum constants

type

  IsolationLevelEnum = TOleEnum;

const

  adXactUnspecified = $FFFFFFFF;

  adXactChaos = $00000010;

  adXactReadUncommitted = $00000100;

  adXactBrowse = $00000100;

  adXactCursorStability = $00001000;

  adXactReadCommitted = $00001000;

  adXactRepeatableRead = $00010000;

  adXactSerializable = $00100000;

  adXactIsolated = $00100000;

 

// XactAttributeEnum constants

type

  XactAttributeEnum = TOleEnum;

const

  adXactCommitRetaining = $00020000;

  adXactAbortRetaining = $00040000;

  adXactAsyncPhaseOne = $00080000;

  adXactSyncPhaseOne = $00100000;

 

// PropertyAttributesEnum constants

type

  PropertyAttributesEnum = TOleEnum;

const

  adPropNotSupported = $00000000;

  adPropRequired = $00000001;

  adPropOptional = $00000002;

  adPropRead = $00000200;

  adPropWrite = $00000400;

 

// ErrorValueEnum constants

type

  ErrorValueEnum = TOleEnum;

const

  adErrInvalidArgument = $00000BB9;

  adErrNoCurrentRecord = $00000BCD;

  adErrIllegalOperation = $00000C93;

  adErrInTransaction = $00000CAE;

  adErrFeatureNotAvailable = $00000CB3;

  adErrItemNotFound = $00000CC1;

  adErrObjectInCollection = $00000D27;

  adErrObjectNotSet = $00000D5C;

  adErrDataConversion = $00000D5D;

  adErrObjectClosed = $00000E78;

  adErrObjectOpen = $00000E79;

  adErrProviderNotFound = $00000E7A;

  adErrBoundToCommand = $00000E7B;

  adErrInvalidParamInfo = $00000E7C;

  adErrInvalidConnection = $00000E7D;

  adErrNotReentrant = $00000E7E;

  adErrStillExecuting = $00000E7F;

  adErrOperationCancelled = $00000E80;

  adErrStillConnecting = $00000E81;

  adErrNotExecuting = $00000E83;

  adErrUnsafeOperation = $00000E84;

 

// ParameterAttributesEnum constants

type

  ParameterAttributesEnum = TOleEnum;

const

  adParamSigned = $00000010;

  adParamNullable = $00000040;

  adParamLong = $00000080;

 

// ParameterDirectionEnum constants

type

  ParameterDirectionEnum = TOleEnum;

const

  adParamUnknown = $00000000;

  adParamInput = $00000001;

  adParamOutput = $00000002;

  adParamInputOutput = $00000003;

  adParamReturnValue = $00000004;

 

// CommandTypeEnum constants

type

  CommandTypeEnum = TOleEnum;

const

  adCmdUnspecified = $FFFFFFFF;

  adCmdUnknown = $00000008;

  adCmdText = $00000001;

  adCmdTable = $00000002;

  adCmdStoredProc = $00000004;

  adCmdFile = $00000100;

  adCmdTableDirect = $00000200;

 

// EventStatusEnum constants

type

  EventStatusEnum = TOleEnum;

const

  adStatusOK = $00000001;

  adStatusErrorsOccurred = $00000002;

  adStatusCantDeny = $00000003;

  adStatusCancel = $00000004;

  adStatusUnwantedEvent = $00000005;

 

// EventReasonEnum constants

type

  EventReasonEnum = TOleEnum;

const

  adRsnAddNew = $00000001;

  adRsnDelete = $00000002;

  adRsnUpdate = $00000003;

  adRsnUndoUpdate = $00000004;

  adRsnUndoAddNew = $00000005;

  adRsnUndoDelete = $00000006;

  adRsnRequery = $00000007;

  adRsnResynch = $00000008;

  adRsnClose = $00000009;

  adRsnMove = $0000000A;

  adRsnFirstChange = $0000000B;

  adRsnMoveFirst = $0000000C;

  adRsnMoveNext = $0000000D;

  adRsnMovePrevious = $0000000E;

  adRsnMoveLast = $0000000F;

 

// SchemaEnum constants

type

  SchemaEnum = TOleEnum;

const

  adSchemaProviderSpecific = $FFFFFFFF;

  adSchemaAsserts = $00000000;

  adSchemaCatalogs = $00000001;

  adSchemaCharacterSets = $00000002;

  adSchemaCollations = $00000003;

  adSchemaColumns = $00000004;

  adSchemaCheckConstraints = $00000005;

  adSchemaConstraintColumnUsage = $00000006;

  adSchemaConstraintTableUsage = $00000007;

  adSchemaKeyColumnUsage = $00000008;

  adSchemaReferentialContraints = $00000009;

  adSchemaReferentialConstraints = $00000009;

  adSchemaTableConstraints = $0000000A;

  adSchemaColumnsDomainUsage = $0000000B;

  adSchemaIndexes = $0000000C;

  adSchemaColumnPrivileges = $0000000D;

  adSchemaTablePrivileges = $0000000E;

  adSchemaUsagePrivileges = $0000000F;

  adSchemaProcedures = $00000010;

  adSchemaSchemata = $00000011;

  adSchemaSQLLanguages = $00000012;

  adSchemaStatistics = $00000013;

  adSchemaTables = $00000014;

  adSchemaTranslations = $00000015;

  adSchemaProviderTypes = $00000016;

  adSchemaViews = $00000017;

  adSchemaViewColumnUsage = $00000018;

  adSchemaViewTableUsage = $00000019;

  adSchemaProcedureParameters = $0000001A;

  adSchemaForeignKeys = $0000001B;

  adSchemaPrimaryKeys = $0000001C;

  adSchemaProcedureColumns = $0000001D;

  adSchemaDBInfoKeywords = $0000001E;

  adSchemaDBInfoLiterals = $0000001F;

  adSchemaCubes = $00000020;

  adSchemaDimensions = $00000021;

  adSchemaHierarchies = $00000022;

  adSchemaLevels = $00000023;

  adSchemaMeasures = $00000024;

  adSchemaProperties = $00000025;

  adSchemaMembers = $00000026;

  adSchemaTrustees = $00000027;

 

// SeekEnum constants

type

  SeekEnum = TOleEnum;

const

  adSeekFirstEQ = $00000001;

  adSeekLastEQ = $00000002;

  adSeekAfterEQ = $00000004;

  adSeekAfter = $00000008;

  adSeekBeforeEQ = $00000010;

  adSeekBefore = $00000020;

 

// ADCPROP_UPDATECRITERIA_ENUM constants

type

  ADCPROP_UPDATECRITERIA_ENUM = TOleEnum;

const

  adCriteriaKey = $00000000;

  adCriteriaAllCols = $00000001;

  adCriteriaUpdCols = $00000002;

  adCriteriaTimeStamp = $00000003;

 

// ADCPROP_ASYNCTHREADPRIORITY_ENUM constants

type

  ADCPROP_ASYNCTHREADPRIORITY_ENUM = TOleEnum;

const

  adPriorityLowest = $00000001;

  adPriorityBelowNormal = $00000002;

  adPriorityNormal = $00000003;

  adPriorityAboveNormal = $00000004;

  adPriorityHighest = $00000005;

 

// CEResyncEnum constants

type

  CEResyncEnum = TOleEnum;

const

  adResyncNone = $00000000;

  adResyncAutoIncrement = $00000001;

  adResyncConflicts = $00000002;

  adResyncUpdates = $00000004;

  adResyncInserts = $00000008;

  adResyncAll = $0000000F;

 

// ADCPROP_AUTORECALC_ENUM constants

type

  ADCPROP_AUTORECALC_ENUM = TOleEnum;

const

  adRecalcUpFront = $00000000;

  adRecalcAlways = $00000001;

 

type

 

// *********************************************************************//

// Forward declaration of interfaces defined in Type Library            //

// *********************************************************************//

  _Collection = interface;

  _CollectionDisp = dispinterface;

  _DynaCollection = interface;

  _DynaCollectionDisp = dispinterface;

  _ADO = interface;

  _ADODisp = dispinterface;

  Properties = interface;

  PropertiesDisp = dispinterface;

  Property_ = interface;

  Property_Disp = dispinterface;

  Error = interface;

  ErrorDisp = dispinterface;

  Errors = interface;

  ErrorsDisp = dispinterface;

  Command15 = interface;

  Command15Disp = dispinterface;

  Connection15 = interface;

  Connection15Disp = dispinterface;

  _Connection = interface;

  _ConnectionDisp = dispinterface;

  Recordset15 = interface;

  Recordset15Disp = dispinterface;

  Recordset20 = interface;

  Recordset20Disp = dispinterface;

  _Recordset = interface;

  _RecordsetDisp = dispinterface;

  Fields15 = interface;

  Fields15Disp = dispinterface;

  Fields = interface;

  FieldsDisp = dispinterface;

  Field = interface;

  FieldDisp = dispinterface;

  _Parameter = interface;

  _ParameterDisp = dispinterface;

  Parameters = interface;

  ParametersDisp = dispinterface;

  _Command = interface;

  _CommandDisp = dispinterface;

  ConnectionEventsVt = interface;

  RecordsetEventsVt = interface;

  ConnectionEvents = dispinterface;

  RecordsetEvents = dispinterface;

  ADOConnectionConstruction15 = interface;

  ADOConnectionConstruction = interface;

  ADOCommandConstruction = interface;

  ADORecordsetConstruction = interface;

  Field15 = interface;

  Field15Disp = dispinterface;

 

// *********************************************************************//

// Declaration of CoClasses defined in Type Library                     //

// (NOTE: Here we map each CoClass to its Default Interface)            //

// *********************************************************************//

  Connection = _Connection;

  Command = _Command;

  Recordset = _Recordset;

  Parameter = _Parameter;

 

 

// *********************************************************************//

// Declaration of structures, unions and aliases.                       //

// *********************************************************************//

  POleVariant1 = ^OleVariant; {*}

 

  SearchDirection = SearchDirectionEnum;

 

// *********************************************************************//

// Interface: _Collection

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000512-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _Collection = interface(IDispatch)

    ['{00000512-0000-0010-8000-00AA006D2EA4}']

    function Get_Count: Integer; safecall;

    function _NewEnum: IUnknown; safecall;

    procedure Refresh; safecall;

    property Count: Integer read Get_Count;

  end;

 

// *********************************************************************//

// DispIntf:  _CollectionDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000512-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _CollectionDisp = dispinterface

    ['{00000512-0000-0010-8000-00AA006D2EA4}']

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: _DynaCollection

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000513-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _DynaCollection = interface(_Collection)

    ['{00000513-0000-0010-8000-00AA006D2EA4}']

    procedure Append(const Object_: IDispatch); safecall;

    procedure Delete(Index: OleVariant); safecall;

  end;

 

// *********************************************************************//

// DispIntf:  _DynaCollectionDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000513-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _DynaCollectionDisp = dispinterface

    ['{00000513-0000-0010-8000-00AA006D2EA4}']

    procedure Append(const Object_: IDispatch); dispid 1610809344;

    procedure Delete(Index: OleVariant); dispid 1610809345;

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: _ADO

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000534-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _ADO = interface(IDispatch)

    ['{00000534-0000-0010-8000-00AA006D2EA4}']

    function Get_Properties: Properties; safecall;

    property Properties: Properties read Get_Properties;

  end;

 

// *********************************************************************//

// DispIntf:  _ADODisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000534-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _ADODisp = dispinterface

    ['{00000534-0000-0010-8000-00AA006D2EA4}']

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: Properties

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000504-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Properties = interface(_Collection)

    ['{00000504-0000-0010-8000-00AA006D2EA4}']

    function Get_Item(Index: OleVariant): Property_; safecall;

    property Item[Index: OleVariant]: Property_ read Get_Item; default;

  end;

 

// *********************************************************************//

// DispIntf:  PropertiesDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000504-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  PropertiesDisp = dispinterface

    ['{00000504-0000-0010-8000-00AA006D2EA4}']

    property Item[Index: OleVariant]: Property_ readonly dispid 0; default;

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: Property_

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000503-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Property_ = interface(IDispatch)

    ['{00000503-0000-0010-8000-00AA006D2EA4}']

    function Get_Value: OleVariant; safecall;

    procedure Set_Value(pval: OleVariant); safecall;

    function Get_Name: WideString; safecall;

    function Get_Type_: DataTypeEnum; safecall;

    function Get_Attributes: Integer; safecall;

    procedure Set_Attributes(plAttributes: Integer); safecall;

    property Value: OleVariant read Get_Value write Set_Value;

    property Name: WideString read Get_Name;

    property Type_: DataTypeEnum read Get_Type_;

    property Attributes: Integer read Get_Attributes write Set_Attributes;

  end;

 

// *********************************************************************//

// DispIntf:  Property_Disp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000503-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Property_Disp = dispinterface

    ['{00000503-0000-0010-8000-00AA006D2EA4}']

    property Value: OleVariant dispid 0;

    property Name: WideString readonly dispid 1610743810;

    property Type_: DataTypeEnum readonly dispid 1610743811;

    property Attributes: Integer dispid 1610743812;

  end;

 

// *********************************************************************//

// Interface: Error

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000500-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Error = interface(IDispatch)

    ['{00000500-0000-0010-8000-00AA006D2EA4}']

    function Get_Number: Integer; safecall;

    function Get_Source: WideString; safecall;

    function Get_Description: WideString; safecall;

    function Get_HelpFile: WideString; safecall;

    function Get_HelpContext: Integer; safecall;

    function Get_SQLState: WideString; safecall;

    function Get_NativeError: Integer; safecall;

    property Number: Integer read Get_Number;

    property Source: WideString read Get_Source;

    property Description: WideString read Get_Description;

    property HelpFile: WideString read Get_HelpFile;

    property HelpContext: Integer read Get_HelpContext;

    property SQLState: WideString read Get_SQLState;

    property NativeError: Integer read Get_NativeError;

  end;

 

// *********************************************************************//

// DispIntf:  ErrorDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000500-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ErrorDisp = dispinterface

    ['{00000500-0000-0010-8000-00AA006D2EA4}']

    property Number: Integer readonly dispid 1610743808;

    property Source: WideString readonly dispid 1610743809;

    property Description: WideString readonly dispid 0;

    property HelpFile: WideString readonly dispid 1610743811;

    property HelpContext: Integer readonly dispid 1610743812;

    property SQLState: WideString readonly dispid 1610743813;

    property NativeError: Integer readonly dispid 1610743814;

  end;

 

// *********************************************************************//

// Interface: Errors

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000501-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Errors = interface(_Collection)

    ['{00000501-0000-0010-8000-00AA006D2EA4}']

    function Get_Item(Index: OleVariant): Error; safecall;

    procedure Clear; safecall;

    property Item[Index: OleVariant]: Error read Get_Item; default;

  end;

 

// *********************************************************************//

// DispIntf:  ErrorsDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000501-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ErrorsDisp = dispinterface

    ['{00000501-0000-0010-8000-00AA006D2EA4}']

    property Item[Index: OleVariant]: Error readonly dispid 0; default;

    procedure Clear; dispid 1610809345;

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: Command15

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000508-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Command15 = interface(_ADO)

    ['{00000508-0000-0010-8000-00AA006D2EA4}']

    function Get_ActiveConnection: _Connection; safecall;

    procedure Set_ActiveConnection(const ppvObject: _Connection); safecall;

    procedure _Set_ActiveConnection(ppvObject: OleVariant); safecall;

    function Get_CommandText: WideString; safecall;

    procedure Set_CommandText(const pbstr: WideString); safecall;

    function Get_CommandTimeout: Integer; safecall;

    procedure Set_CommandTimeout(pl: Integer); safecall;

    function Get_Prepared: WordBool; safecall;

    procedure Set_Prepared(pfPrepared: WordBool); safecall;

    function Execute(out RecordsAffected: OleVariant; var Parameters: OleVariant; Options: Integer): _Recordset; safecall;

    function CreateParameter(const Name: WideString; Type_: DataTypeEnum;

                             Direction: ParameterDirectionEnum; Size: Integer; Value: OleVariant): _Parameter; safecall;

    function Get_Parameters: Parameters; safecall;

    procedure Set_CommandType(plCmdType: CommandTypeEnum); safecall;

    function Get_CommandType: CommandTypeEnum; safecall;

    function Get_Name: WideString; safecall;

    procedure Set_Name(const pbstrName: WideString); safecall;

    property CommandText: WideString read Get_CommandText write Set_CommandText;

    property CommandTimeout: Integer read Get_CommandTimeout write Set_CommandTimeout;

    property Prepared: WordBool read Get_Prepared write Set_Prepared;

    property Parameters: Parameters read Get_Parameters;

    property CommandType: CommandTypeEnum read Get_CommandType write Set_CommandType;

    property Name: WideString read Get_Name write Set_Name;

  end;

 

// *********************************************************************//

// DispIntf:  Command15Disp

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000508-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Command15Disp = dispinterface

    ['{00000508-0000-0010-8000-00AA006D2EA4}']

    function ActiveConnection: _Connection; dispid 1610809344;

    property CommandText: WideString dispid 1610809347;

    property CommandTimeout: Integer dispid 1610809349;

    property Prepared: WordBool dispid 1610809351;

    function Execute(out RecordsAffected: OleVariant; var Parameters: OleVariant; Options: Integer): _Recordset; dispid 1610809353;

    function CreateParameter(const Name: WideString; Type_: DataTypeEnum;

                             Direction: ParameterDirectionEnum; Size: Integer; Value: OleVariant): _Parameter; dispid 1610809354;

    property Parameters: Parameters readonly dispid 0;

    property CommandType: CommandTypeEnum dispid 1610809356;

    property Name: WideString dispid 1610809358;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: Connection15

// Flags:     (4432) Hidden Dual OleAutomation Dispatchable

// GUID:      {00000515-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Connection15 = interface(_ADO)

    ['{00000515-0000-0010-8000-00AA006D2EA4}']

    function Get_ConnectionString: WideString; safecall;

    procedure Set_ConnectionString(const pbstr: WideString); safecall;

    function Get_CommandTimeout: Integer; safecall;

    procedure Set_CommandTimeout(plTimeout: Integer); safecall;

    function Get_ConnectionTimeout: Integer; safecall;

    procedure Set_ConnectionTimeout(plTimeout: Integer); safecall;

    function Get_Version: WideString; safecall;

    procedure Close; safecall;

    function Execute(const CommandText: WideString; out RecordsAffected: OleVariant;

                     Options: Integer): _Recordset; safecall;

    function BeginTrans: Integer; safecall;

    procedure CommitTrans; safecall;

    procedure RollbackTrans; safecall;

    procedure Open(const ConnectionString: WideString; const UserID: WideString;

                   const Password: WideString; Options: Integer); safecall;

    function Get_Errors: Errors; safecall;

    function Get_DefaultDatabase: WideString; safecall;

    procedure Set_DefaultDatabase(const pbstr: WideString); safecall;

    function Get_IsolationLevel: IsolationLevelEnum; safecall;

    procedure Set_IsolationLevel(Level: IsolationLevelEnum); safecall;

    function Get_Attributes: Integer; safecall;

    procedure Set_Attributes(plAttr: Integer); safecall;

    function Get_CursorLocation: CursorLocationEnum; safecall;

    procedure Set_CursorLocation(plCursorLoc: CursorLocationEnum); safecall;

    function Get_Mode: ConnectModeEnum; safecall;

    procedure Set_Mode(plMode: ConnectModeEnum); safecall;

    function Get_Provider: WideString; safecall;

    procedure Set_Provider(const pbstr: WideString); safecall;

    function Get_State: Integer; safecall;

    function OpenSchema(Schema: SchemaEnum; Restrictions: OleVariant; SchemaID: OleVariant): _Recordset; safecall;

    property ConnectionString: WideString read Get_ConnectionString write Set_ConnectionString;

    property CommandTimeout: Integer read Get_CommandTimeout write Set_CommandTimeout;

    property ConnectionTimeout: Integer read Get_ConnectionTimeout write Set_ConnectionTimeout;

    property Version: WideString read Get_Version;

    property Errors: Errors read Get_Errors;

    property DefaultDatabase: WideString read Get_DefaultDatabase write Set_DefaultDatabase;

    property IsolationLevel: IsolationLevelEnum read Get_IsolationLevel write Set_IsolationLevel;

    property Attributes: Integer read Get_Attributes write Set_Attributes;

    property CursorLocation: CursorLocationEnum read Get_CursorLocation write Set_CursorLocation;

    property Mode: ConnectModeEnum read Get_Mode write Set_Mode;

    property Provider: WideString read Get_Provider write Set_Provider;

    property State: Integer read Get_State;

  end;

 

// *********************************************************************//

// DispIntf:  Connection15Disp

// Flags:     (4432) Hidden Dual OleAutomation Dispatchable

// GUID:      {00000515-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Connection15Disp = dispinterface

    ['{00000515-0000-0010-8000-00AA006D2EA4}']

    property ConnectionString: WideString dispid 0;

    property CommandTimeout: Integer dispid 2;

    property ConnectionTimeout: Integer dispid 3;

    property Version: WideString readonly dispid 4;

    procedure Close; dispid 5;

    function Execute(const CommandText: WideString; out RecordsAffected: OleVariant;

                     Options: Integer): _Recordset; dispid 6;

    function BeginTrans: Integer; dispid 7;

    procedure CommitTrans; dispid 8;

    procedure RollbackTrans; dispid 9;

    procedure Open(const ConnectionString: WideString; const UserID: WideString;

                   const Password: WideString; Options: Integer); dispid 10;

    property Errors: Errors readonly dispid 11;

    property DefaultDatabase: WideString dispid 12;

    property IsolationLevel: IsolationLevelEnum dispid 13;

    property Attributes: Integer dispid 14;

    property CursorLocation: CursorLocationEnum dispid 15;

    property Mode: ConnectModeEnum dispid 16;

    property Provider: WideString dispid 17;

    property State: Integer readonly dispid 18;

    function OpenSchema(Schema: SchemaEnum; Restrictions: OleVariant; SchemaID: OleVariant): _Recordset; dispid 19;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: _Connection

// Flags:     (4416) Dual OleAutomation Dispatchable

// GUID:      {00000550-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _Connection = interface(Connection15)

    ['{00000550-0000-0010-8000-00AA006D2EA4}']

    procedure Cancel; safecall;

  end;

 

// *********************************************************************//

// DispIntf:  _ConnectionDisp

// Flags:     (4416) Dual OleAutomation Dispatchable

// GUID:      {00000550-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _ConnectionDisp = dispinterface

    ['{00000550-0000-0010-8000-00AA006D2EA4}']

    procedure Cancel; dispid 21;

    property ConnectionString: WideString dispid 0;

    property CommandTimeout: Integer dispid 2;

    property ConnectionTimeout: Integer dispid 3;

    property Version: WideString readonly dispid 4;

    procedure Close; dispid 5;

    function Execute(const CommandText: WideString; out RecordsAffected: OleVariant;

                     Options: Integer): _Recordset; dispid 6;

    function BeginTrans: Integer; dispid 7;

    procedure CommitTrans; dispid 8;

    procedure RollbackTrans; dispid 9;

    procedure Open(const ConnectionString: WideString; const UserID: WideString;

                   const Password: WideString; Options: Integer); dispid 10;

    property Errors: Errors readonly dispid 11;

    property DefaultDatabase: WideString dispid 12;

    property IsolationLevel: IsolationLevelEnum dispid 13;

    property Attributes: Integer dispid 14;

    property CursorLocation: CursorLocationEnum dispid 15;

    property Mode: ConnectModeEnum dispid 16;

    property Provider: WideString dispid 17;

    property State: Integer readonly dispid 18;

    function OpenSchema(Schema: SchemaEnum; Restrictions: OleVariant; SchemaID: OleVariant): _Recordset; dispid 19;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: Recordset15

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000050E-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Recordset15 = interface(_ADO)

    ['{0000050E-0000-0010-8000-00AA006D2EA4}']

    function Get_AbsolutePosition: PositionEnum; safecall;

    procedure Set_AbsolutePosition(pl: PositionEnum); safecall;

    procedure Set_ActiveConnection(const pvar: IDispatch); safecall;

    procedure _Set_ActiveConnection(pvar: OleVariant); safecall;

    function Get_ActiveConnection: OleVariant; safecall;

    function Get_BOF: WordBool; safecall;

    function Get_Bookmark: OleVariant; safecall;

    procedure Set_Bookmark(pvBookmark: OleVariant); safecall;

    function Get_CacheSize: Integer; safecall;

    procedure Set_CacheSize(pl: Integer); safecall;

    function Get_CursorType: CursorTypeEnum; safecall;

    procedure Set_CursorType(plCursorType: CursorTypeEnum); safecall;

    function Get_EOF: WordBool; safecall;

    function Get_Fields: Fields; safecall;

    function Get_LockType: LockTypeEnum; safecall;

    procedure Set_LockType(plLockType: LockTypeEnum); safecall;

    function Get_MaxRecords: Integer; safecall;

    procedure Set_MaxRecords(plMaxRecords: Integer); safecall;

    function Get_RecordCount: Integer; safecall;

    procedure Set_Source(const pvSource: IDispatch); safecall;

    procedure _Set_Source(const pvSource: WideString); safecall;

    function Get_Source: OleVariant; safecall;

    procedure AddNew(FieldList: OleVariant; Values: OleVariant); safecall;

    procedure CancelUpdate; safecall;

    procedure Close; safecall;

    procedure Delete(AffectRecords: AffectEnum); safecall;

    function GetRows(Rows: Integer; Start: OleVariant; Fields: OleVariant): OleVariant; safecall;

    procedure Move(NumRecords: Integer; Start: OleVariant); safecall;

    procedure MoveNext; safecall;

    procedure MovePrevious; safecall;

    procedure MoveFirst; safecall;

    procedure MoveLast; safecall;

    procedure Open(Source: OleVariant; ActiveConnection: OleVariant; CursorType: CursorTypeEnum;

                   LockType: LockTypeEnum; Options: Integer); safecall;

    procedure Requery(Options: Integer); safecall;

    procedure _xResync(AffectRecords: AffectEnum); safecall;

    procedure Update(Fields: OleVariant; Values: OleVariant); safecall;

    function Get_AbsolutePage: PositionEnum; safecall;

    procedure Set_AbsolutePage(pl: PositionEnum); safecall;

    function Get_EditMode: EditModeEnum; safecall;

    function Get_Filter: OleVariant; safecall;

    procedure Set_Filter(Criteria: OleVariant); safecall;

    function Get_PageCount: Integer; safecall;

    function Get_PageSize: Integer; safecall;

    procedure Set_PageSize(pl: Integer); safecall;

    function Get_Sort: WideString; safecall;

    procedure Set_Sort(const Criteria: WideString); safecall;

    function Get_Status: Integer; safecall;

    function Get_State: Integer; safecall;

    function _xClone: _Recordset; safecall;

    procedure UpdateBatch(AffectRecords: AffectEnum); safecall;

    procedure CancelBatch(AffectRecords: AffectEnum); safecall;

    function Get_CursorLocation: CursorLocationEnum; safecall;

    procedure Set_CursorLocation(plCursorLoc: CursorLocationEnum); safecall;

    function NextRecordset(out RecordsAffected: OleVariant): _Recordset; safecall;

    function Supports(CursorOptions: CursorOptionEnum): WordBool; safecall;

    function Get_Collect(Index: OleVariant): OleVariant; safecall;

    procedure Set_Collect(Index: OleVariant; pvar: OleVariant); safecall;

    function Get_MarshalOptions: MarshalOptionsEnum; safecall;

    procedure Set_MarshalOptions(peMarshal: MarshalOptionsEnum); safecall;

    procedure Find(const Criteria: WideString; SkipRecords: Integer;

                   SearchDirection: SearchDirectionEnum; Start: OleVariant); safecall;

    property AbsolutePosition: PositionEnum read Get_AbsolutePosition write Set_AbsolutePosition;

    property BOF: WordBool read Get_BOF;

    property Bookmark: OleVariant read Get_Bookmark write Set_Bookmark;

    property CacheSize: Integer read Get_CacheSize write Set_CacheSize;

    property CursorType: CursorTypeEnum read Get_CursorType write Set_CursorType;

    property EOF: WordBool read Get_EOF;

    property Fields: Fields read Get_Fields;

    property LockType: LockTypeEnum read Get_LockType write Set_LockType;

    property MaxRecords: Integer read Get_MaxRecords write Set_MaxRecords;

    property RecordCount: Integer read Get_RecordCount;

    property AbsolutePage: PositionEnum read Get_AbsolutePage write Set_AbsolutePage;

    property EditMode: EditModeEnum read Get_EditMode;

    property Filter: OleVariant read Get_Filter write Set_Filter;

    property PageCount: Integer read Get_PageCount;

    property PageSize: Integer read Get_PageSize write Set_PageSize;

    property Sort: WideString read Get_Sort write Set_Sort;

    property Status: Integer read Get_Status;

    property State: Integer read Get_State;

    property CursorLocation: CursorLocationEnum read Get_CursorLocation write Set_CursorLocation;

    property Collect[Index: OleVariant]: OleVariant read Get_Collect write Set_Collect;

    property MarshalOptions: MarshalOptionsEnum read Get_MarshalOptions write Set_MarshalOptions;

  end;

 

// *********************************************************************//

// DispIntf:  Recordset15Disp

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000050E-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Recordset15Disp = dispinterface

    ['{0000050E-0000-0010-8000-00AA006D2EA4}']

    property AbsolutePosition: PositionEnum dispid 1000;

    function ActiveConnection: IDispatch; dispid 1001;

    property BOF: WordBool readonly dispid 1002;

    property Bookmark: OleVariant dispid 1003;

    property CacheSize: Integer dispid 1004;

    property CursorType: CursorTypeEnum dispid 1005;

    property EOF: WordBool readonly dispid 1006;

    property Fields: Fields readonly dispid 0;

    property LockType: LockTypeEnum dispid 1008;

    property MaxRecords: Integer dispid 1009;

    property RecordCount: Integer readonly dispid 1010;

    function Source: IDispatch; dispid 1011;

    procedure AddNew(FieldList: OleVariant; Values: OleVariant); dispid 1012;

    procedure CancelUpdate; dispid 1013;

    procedure Close; dispid 1014;

    procedure Delete(AffectRecords: AffectEnum); dispid 1015;

    function GetRows(Rows: Integer; Start: OleVariant; Fields: OleVariant): OleVariant; dispid 1016;

    procedure Move(NumRecords: Integer; Start: OleVariant); dispid 1017;

    procedure MoveNext; dispid 1018;

    procedure MovePrevious; dispid 1019;

    procedure MoveFirst; dispid 1020;

    procedure MoveLast; dispid 1021;

    procedure Open(Source: OleVariant; ActiveConnection: OleVariant; CursorType: CursorTypeEnum;

                   LockType: LockTypeEnum; Options: Integer); dispid 1022;

    procedure Requery(Options: Integer); dispid 1023;

    procedure _xResync(AffectRecords: AffectEnum); dispid 1610809378;

    procedure Update(Fields: OleVariant; Values: OleVariant); dispid 1025;

    property AbsolutePage: PositionEnum dispid 1047;

    property EditMode: EditModeEnum readonly dispid 1026;

    property Filter: OleVariant dispid 1030;

    property PageCount: Integer readonly dispid 1050;

    property PageSize: Integer dispid 1048;

    property Sort: WideString dispid 1031;

    property Status: Integer readonly dispid 1029;

    property State: Integer readonly dispid 1054;

    function _xClone: _Recordset; dispid 1610809392;

    procedure UpdateBatch(AffectRecords: AffectEnum); dispid 1035;

    procedure CancelBatch(AffectRecords: AffectEnum); dispid 1049;

    property CursorLocation: CursorLocationEnum dispid 1051;

    function NextRecordset(out RecordsAffected: OleVariant): _Recordset; dispid 1052;

    function Supports(CursorOptions: CursorOptionEnum): WordBool; dispid 1036;

    property Collect[Index: OleVariant]: OleVariant dispid -8;

    property MarshalOptions: MarshalOptionsEnum dispid 1053;

    procedure Find(const Criteria: WideString; SkipRecords: Integer;

                   SearchDirection: SearchDirectionEnum; Start: OleVariant); dispid 1058;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: Recordset20

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054F-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Recordset20 = interface(Recordset15)

    ['{0000054F-0000-0010-8000-00AA006D2EA4}']

    procedure Cancel; safecall;

    function Get_DataSource: IUnknown; safecall;

    procedure Set_DataSource(const ppunkDataSource: IUnknown); safecall;

    procedure Save(const FileName: WideString; PersistFormat: PersistFormatEnum); safecall;

    function Get_ActiveCommand: IDispatch; safecall;

    procedure Set_StayInSync(pbStayInSync: WordBool); safecall;

    function Get_StayInSync: WordBool; safecall;

    function GetString(StringFormat: StringFormatEnum; NumRows: Integer;

                       const ColumnDelimeter: WideString; const RowDelimeter: WideString;

                       const NullExpr: WideString): WideString; safecall;

    function Get_DataMember: WideString; safecall;

    procedure Set_DataMember(const pbstrDataMember: WideString); safecall;

    function CompareBookmarks(Bookmark1: OleVariant; Bookmark2: OleVariant): CompareEnum; safecall;

    function Clone(LockType: LockTypeEnum): _Recordset; safecall;

    procedure Resync(AffectRecords: AffectEnum; ResyncValues: ResyncEnum); safecall;

    property DataSource: IUnknown read Get_DataSource write Set_DataSource;

    property ActiveCommand: IDispatch read Get_ActiveCommand;

    property StayInSync: WordBool read Get_StayInSync write Set_StayInSync;

    property DataMember: WideString read Get_DataMember write Set_DataMember;

  end;

 

// *********************************************************************//

// DispIntf:  Recordset20Disp

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054F-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Recordset20Disp = dispinterface

    ['{0000054F-0000-0010-8000-00AA006D2EA4}']

    procedure Cancel; dispid 1055;

    property DataSource: IUnknown dispid 1056;

    procedure Save(const FileName: WideString; PersistFormat: PersistFormatEnum); dispid 1057;

    property ActiveCommand: IDispatch readonly dispid 1061;

    property StayInSync: WordBool dispid 1063;

    function GetString(StringFormat: StringFormatEnum; NumRows: Integer;

                       const ColumnDelimeter: WideString; const RowDelimeter: WideString;

                       const NullExpr: WideString): WideString; dispid 1062;

    property DataMember: WideString dispid 1064;

    function CompareBookmarks(Bookmark1: OleVariant; Bookmark2: OleVariant): CompareEnum; dispid 1065;

    function Clone(LockType: LockTypeEnum): _Recordset; dispid 1034;

    procedure Resync(AffectRecords: AffectEnum; ResyncValues: ResyncEnum); dispid 1024;

    property AbsolutePosition: PositionEnum dispid 1000;

    function ActiveConnection: IDispatch; dispid 1001;

    property BOF: WordBool readonly dispid 1002;

    property Bookmark: OleVariant dispid 1003;

    property CacheSize: Integer dispid 1004;

    property CursorType: CursorTypeEnum dispid 1005;

    property EOF: WordBool readonly dispid 1006;

    property Fields: Fields readonly dispid 0;

    property LockType: LockTypeEnum dispid 1008;

    property MaxRecords: Integer dispid 1009;

    property RecordCount: Integer readonly dispid 1010;

    function Source: IDispatch; dispid 1011;

    procedure AddNew(FieldList: OleVariant; Values: OleVariant); dispid 1012;

    procedure CancelUpdate; dispid 1013;

    procedure Close; dispid 1014;

    procedure Delete(AffectRecords: AffectEnum); dispid 1015;

    function GetRows(Rows: Integer; Start: OleVariant; Fields: OleVariant): OleVariant; dispid 1016;

    procedure Move(NumRecords: Integer; Start: OleVariant); dispid 1017;

    procedure MoveNext; dispid 1018;

    procedure MovePrevious; dispid 1019;

    procedure MoveFirst; dispid 1020;

    procedure MoveLast; dispid 1021;

    procedure Open(Source: OleVariant; ActiveConnection: OleVariant; CursorType: CursorTypeEnum;

                   LockType: LockTypeEnum; Options: Integer); dispid 1022;

    procedure Requery(Options: Integer); dispid 1023;

    procedure _xResync(AffectRecords: AffectEnum); dispid 1610809378;

    procedure Update(Fields: OleVariant; Values: OleVariant); dispid 1025;

    property AbsolutePage: PositionEnum dispid 1047;

    property EditMode: EditModeEnum readonly dispid 1026;

    property Filter: OleVariant dispid 1030;

    property PageCount: Integer readonly dispid 1050;

    property PageSize: Integer dispid 1048;

    property Sort: WideString dispid 1031;

    property Status: Integer readonly dispid 1029;

    property State: Integer readonly dispid 1054;

    function _xClone: _Recordset; dispid 1610809392;

    procedure UpdateBatch(AffectRecords: AffectEnum); dispid 1035;

    procedure CancelBatch(AffectRecords: AffectEnum); dispid 1049;

    property CursorLocation: CursorLocationEnum dispid 1051;

    function NextRecordset(out RecordsAffected: OleVariant): _Recordset; dispid 1052;

    function Supports(CursorOptions: CursorOptionEnum): WordBool; dispid 1036;

    property Collect[Index: OleVariant]: OleVariant dispid -8;

    property MarshalOptions: MarshalOptionsEnum dispid 1053;

    procedure Find(const Criteria: WideString; SkipRecords: Integer;

                   SearchDirection: SearchDirectionEnum; Start: OleVariant); dispid 1058;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: _Recordset

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000555-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _Recordset = interface(Recordset20)

    ['{00000555-0000-0010-8000-00AA006D2EA4}']

    procedure Seek(KeyValues: OleVariant; SeekOption: SeekEnum); safecall;

    procedure Set_Index(const pbstrIndex: WideString); safecall;

    function Get_Index: WideString; safecall;

    property Index: WideString read Get_Index write Set_Index;

  end;

 

// *********************************************************************//

// DispIntf:  _RecordsetDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000555-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _RecordsetDisp = dispinterface

    ['{00000555-0000-0010-8000-00AA006D2EA4}']

    procedure Seek(KeyValues: OleVariant; SeekOption: SeekEnum); dispid 1066;

    property Index: WideString dispid 1067;

    procedure Cancel; dispid 1055;

    property DataSource: IUnknown dispid 1056;

    procedure Save(const FileName: WideString; PersistFormat: PersistFormatEnum); dispid 1057;

    property ActiveCommand: IDispatch readonly dispid 1061;

    property StayInSync: WordBool dispid 1063;

    function GetString(StringFormat: StringFormatEnum; NumRows: Integer;

                       const ColumnDelimeter: WideString; const RowDelimeter: WideString;

                       const NullExpr: WideString): WideString; dispid 1062;

    property DataMember: WideString dispid 1064;

    function CompareBookmarks(Bookmark1: OleVariant; Bookmark2: OleVariant): CompareEnum; dispid 1065;

    function Clone(LockType: LockTypeEnum): _Recordset; dispid 1034;

    procedure Resync(AffectRecords: AffectEnum; ResyncValues: ResyncEnum); dispid 1024;

    property AbsolutePosition: PositionEnum dispid 1000;

    function ActiveConnection: IDispatch; dispid 1001;

    property BOF: WordBool readonly dispid 1002;

    property Bookmark: OleVariant dispid 1003;

    property CacheSize: Integer dispid 1004;

    property CursorType: CursorTypeEnum dispid 1005;

    property EOF: WordBool readonly dispid 1006;

    property Fields: Fields readonly dispid 0;

    property LockType: LockTypeEnum dispid 1008;

    property MaxRecords: Integer dispid 1009;

    property RecordCount: Integer readonly dispid 1010;

    function Source: IDispatch; dispid 1011;

    procedure AddNew(FieldList: OleVariant; Values: OleVariant); dispid 1012;

    procedure CancelUpdate; dispid 1013;

    procedure Close; dispid 1014;

    procedure Delete(AffectRecords: AffectEnum); dispid 1015;

    function GetRows(Rows: Integer; Start: OleVariant; Fields: OleVariant): OleVariant; dispid 1016;

    procedure Move(NumRecords: Integer; Start: OleVariant); dispid 1017;

    procedure MoveNext; dispid 1018;

    procedure MovePrevious; dispid 1019;

    procedure MoveFirst; dispid 1020;

    procedure MoveLast; dispid 1021;

    procedure Open(Source: OleVariant; ActiveConnection: OleVariant; CursorType: CursorTypeEnum;

                   LockType: LockTypeEnum; Options: Integer); dispid 1022;

    procedure Requery(Options: Integer); dispid 1023;

    procedure _xResync(AffectRecords: AffectEnum); dispid 1610809378;

    procedure Update(Fields: OleVariant; Values: OleVariant); dispid 1025;

    property AbsolutePage: PositionEnum dispid 1047;

    property EditMode: EditModeEnum readonly dispid 1026;

    property Filter: OleVariant dispid 1030;

    property PageCount: Integer readonly dispid 1050;

    property PageSize: Integer dispid 1048;

    property Sort: WideString dispid 1031;

    property Status: Integer readonly dispid 1029;

    property State: Integer readonly dispid 1054;

    function _xClone: _Recordset; dispid 1610809392;

    procedure UpdateBatch(AffectRecords: AffectEnum); dispid 1035;

    procedure CancelBatch(AffectRecords: AffectEnum); dispid 1049;

    property CursorLocation: CursorLocationEnum dispid 1051;

    function NextRecordset(out RecordsAffected: OleVariant): _Recordset; dispid 1052;

    function Supports(CursorOptions: CursorOptionEnum): WordBool; dispid 1036;

    property Collect[Index: OleVariant]: OleVariant dispid -8;

    property MarshalOptions: MarshalOptionsEnum dispid 1053;

    procedure Find(const Criteria: WideString; SkipRecords: Integer;

                   SearchDirection: SearchDirectionEnum; Start: OleVariant); dispid 1058;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: Fields15

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000506-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Fields15 = interface(_Collection)

    ['{00000506-0000-0010-8000-00AA006D2EA4}']

    function Get_Item(Index: OleVariant): Field; safecall;

    property Item[Index: OleVariant]: Field read Get_Item; default;

  end;

 

// *********************************************************************//

// DispIntf:  Fields15Disp

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000506-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Fields15Disp = dispinterface

    ['{00000506-0000-0010-8000-00AA006D2EA4}']

    property Item[Index: OleVariant]: Field readonly dispid 0; default;

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: Fields

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054D-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Fields = interface(Fields15)

    ['{0000054D-0000-0010-8000-00AA006D2EA4}']

    procedure Append(const Name: WideString; Type_: DataTypeEnum; DefinedSize: Integer;

                     Attrib: FieldAttributeEnum); safecall;

    procedure Delete(Index: OleVariant); safecall;

  end;

 

// *********************************************************************//

// DispIntf:  FieldsDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054D-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  FieldsDisp = dispinterface

    ['{0000054D-0000-0010-8000-00AA006D2EA4}']

    procedure Append(const Name: WideString; Type_: DataTypeEnum; DefinedSize: Integer;

                     Attrib: FieldAttributeEnum); dispid 1610874880;

    procedure Delete(Index: OleVariant); dispid 1610874881;

    property Item[Index: OleVariant]: Field readonly dispid 0; default;

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: Field

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054C-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Field = interface(_ADO)

    ['{0000054C-0000-0010-8000-00AA006D2EA4}']

    function Get_ActualSize: Integer; safecall;

    function Get_Attributes: Integer; safecall;

    function Get_DefinedSize: Integer; safecall;

    function Get_Name: WideString; safecall;

    function Get_Type_: DataTypeEnum; safecall;

    function Get_Value: OleVariant; safecall;

    procedure Set_Value(pvar: OleVariant); safecall;

    function Get_Precision: Byte; safecall;

    function Get_NumericScale: Byte; safecall;

    procedure AppendChunk(Data: OleVariant); safecall;

    function GetChunk(Length: Integer): OleVariant; safecall;

    function Get_OriginalValue: OleVariant; safecall;

    function Get_UnderlyingValue: OleVariant; safecall;

    function Get_DataFormat: IUnknown; safecall;

    procedure Set_DataFormat(const ppiDF: IUnknown); safecall;

    procedure Set_Precision(pbPrecision: Byte); safecall;

    procedure Set_NumericScale(pbNumericScale: Byte); safecall;

    procedure Set_Type_(pDataType: DataTypeEnum); safecall;

    procedure Set_DefinedSize(pl: Integer); safecall;

    procedure Set_Attributes(pl: Integer); safecall;

    property ActualSize: Integer read Get_ActualSize;

    property Attributes: Integer read Get_Attributes write Set_Attributes;

    property DefinedSize: Integer read Get_DefinedSize write Set_DefinedSize;

    property Name: WideString read Get_Name;

    property Type_: DataTypeEnum read Get_Type_ write Set_Type_;

    property Value: OleVariant read Get_Value write Set_Value;

    property Precision: Byte read Get_Precision write Set_Precision;

    property NumericScale: Byte read Get_NumericScale write Set_NumericScale;

    property OriginalValue: OleVariant read Get_OriginalValue;

    property UnderlyingValue: OleVariant read Get_UnderlyingValue;

    property DataFormat: IUnknown read Get_DataFormat write Set_DataFormat;

  end;

 

// *********************************************************************//

// DispIntf:  FieldDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054C-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  FieldDisp = dispinterface

    ['{0000054C-0000-0010-8000-00AA006D2EA4}']

    property ActualSize: Integer readonly dispid 1109;

    property Attributes: Integer dispid 1036;

    property DefinedSize: Integer dispid 1103;

    property Name: WideString readonly dispid 1100;

    property Type_: DataTypeEnum dispid 1102;

    property Value: OleVariant dispid 0;

    property Precision: Byte dispid 1610809351;

    property NumericScale: Byte dispid 1610809352;

    procedure AppendChunk(Data: OleVariant); dispid 1107;

    function GetChunk(Length: Integer): OleVariant; dispid 1108;

    property OriginalValue: OleVariant readonly dispid 1104;

    property UnderlyingValue: OleVariant readonly dispid 1105;

    property DataFormat: IUnknown dispid 1610809357;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: _Parameter

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000050C-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _Parameter = interface(_ADO)

    ['{0000050C-0000-0010-8000-00AA006D2EA4}']

    function Get_Name: WideString; safecall;

    procedure Set_Name(const pbstr: WideString); safecall;

    function Get_Value: OleVariant; safecall;

    procedure Set_Value(pvar: OleVariant); safecall;

    function Get_Type_: DataTypeEnum; safecall;

    procedure Set_Type_(psDataType: DataTypeEnum); safecall;

    procedure Set_Direction(plParmDirection: ParameterDirectionEnum); safecall;

    function Get_Direction: ParameterDirectionEnum; safecall;

    procedure Set_Precision(pbPrecision: Byte); safecall;

    function Get_Precision: Byte; safecall;

    procedure Set_NumericScale(pbScale: Byte); safecall;

    function Get_NumericScale: Byte; safecall;

    procedure Set_Size(pl: Integer); safecall;

    function Get_Size: Integer; safecall;

    procedure AppendChunk(Val: OleVariant); safecall;

    function Get_Attributes: Integer; safecall;

    procedure Set_Attributes(plParmAttribs: Integer); safecall;

    property Name: WideString read Get_Name write Set_Name;

    property Value: OleVariant read Get_Value write Set_Value;

    property Type_: DataTypeEnum read Get_Type_ write Set_Type_;

    property Direction: ParameterDirectionEnum read Get_Direction write Set_Direction;

    property Precision: Byte read Get_Precision write Set_Precision;

    property NumericScale: Byte read Get_NumericScale write Set_NumericScale;

    property Size: Integer read Get_Size write Set_Size;

    property Attributes: Integer read Get_Attributes write Set_Attributes;

  end;

 

// *********************************************************************//

// DispIntf:  _ParameterDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000050C-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _ParameterDisp = dispinterface

    ['{0000050C-0000-0010-8000-00AA006D2EA4}']

    property Name: WideString dispid 1610809344;

    property Value: OleVariant dispid 0;

    property Type_: DataTypeEnum dispid 1610809348;

    property Direction: ParameterDirectionEnum dispid 1610809350;

    property Precision: Byte dispid 1610809352;

    property NumericScale: Byte dispid 1610809354;

    property Size: Integer dispid 1610809356;

    procedure AppendChunk(Val: OleVariant); dispid 1610809358;

    property Attributes: Integer dispid 1610809359;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: Parameters

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000050D-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Parameters = interface(_DynaCollection)

    ['{0000050D-0000-0010-8000-00AA006D2EA4}']

    function Get_Item(Index: OleVariant): _Parameter; safecall;

    property Item[Index: OleVariant]: _Parameter read Get_Item; default;

  end;

 

// *********************************************************************//

// DispIntf:  ParametersDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000050D-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ParametersDisp = dispinterface

    ['{0000050D-0000-0010-8000-00AA006D2EA4}']

    property Item[Index: OleVariant]: _Parameter readonly dispid 0; default;

    procedure Append(const Object_: IDispatch); dispid 1610809344;

    procedure Delete(Index: OleVariant); dispid 1610809345;

    property Count: Integer readonly dispid 1610743808;

    function _NewEnum: IUnknown; dispid -4;

    procedure Refresh; dispid 1610743810;

  end;

 

// *********************************************************************//

// Interface: _Command

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054E-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _Command = interface(Command15)

    ['{0000054E-0000-0010-8000-00AA006D2EA4}']

    function Get_State: Integer; safecall;

    procedure Cancel; safecall;

    property State: Integer read Get_State;

  end;

 

// *********************************************************************//

// DispIntf:  _CommandDisp

// Flags:     (4544) Dual NonExtensible OleAutomation Dispatchable

// GUID:      {0000054E-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  _CommandDisp = dispinterface

    ['{0000054E-0000-0010-8000-00AA006D2EA4}']

    property State: Integer readonly dispid 1610874880;

    procedure Cancel; dispid 1610874881;

    function ActiveConnection: _Connection; dispid 1610809344;

    property CommandText: WideString dispid 1610809347;

    property CommandTimeout: Integer dispid 1610809349;

    property Prepared: WordBool dispid 1610809351;

    function Execute(out RecordsAffected: OleVariant; var Parameters: OleVariant; Options: Integer): _Recordset; dispid 1610809353;

    function CreateParameter(const Name: WideString; Type_: DataTypeEnum;

                             Direction: ParameterDirectionEnum; Size: Integer; Value: OleVariant): _Parameter; dispid 1610809354;

    property Parameters: Parameters readonly dispid 0;

    property CommandType: CommandTypeEnum dispid 1610809356;

    property Name: WideString dispid 1610809358;

    property Properties: Properties readonly dispid 500;

  end;

 

// *********************************************************************//

// Interface: ConnectionEventsVt

// Flags:     (16) Hidden

// GUID:      {00000402-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ConnectionEventsVt = interface(IUnknown)

    ['{00000402-0000-0010-8000-00AA006D2EA4}']

    function InfoMessage(const pError: Error; var adStatus: EventStatusEnum;

                         const pConnection: _Connection): HResult; stdcall;

    function BeginTransComplete(TransactionLevel: Integer; const pError: Error;

                                var adStatus: EventStatusEnum; const pConnection: _Connection): HResult; stdcall;

    function CommitTransComplete(const pError: Error; var adStatus: EventStatusEnum;

                                 const pConnection: _Connection): HResult; stdcall;

    function RollbackTransComplete(const pError: Error; var adStatus: EventStatusEnum;

                                   const pConnection: _Connection): HResult; stdcall;

    function WillExecute(var Source: WideString; var CursorType: CursorTypeEnum;

                         var LockType: LockTypeEnum; var Options: Integer;

                         var adStatus: EventStatusEnum; const pCommand: _Command;

                         const pRecordset: _Recordset; const pConnection: _Connection): HResult; stdcall;

    function ExecuteComplete(RecordsAffected: Integer; const pError: Error;

                             var adStatus: EventStatusEnum; const pCommand: _Command;

                             const pRecordset: _Recordset; const pConnection: _Connection): HResult; stdcall;

    function WillConnect(var ConnectionString: WideString; var UserID: WideString;

                         var Password: WideString; var Options: Integer;

                         var adStatus: EventStatusEnum; const pConnection: _Connection): HResult; stdcall;

    function ConnectComplete(const pError: Error; var adStatus: EventStatusEnum;

                             const pConnection: _Connection): HResult; stdcall;

    function Disconnect(var adStatus: EventStatusEnum; const pConnection: _Connection): HResult; stdcall;

  end;

 

// *********************************************************************//

// Interface: RecordsetEventsVt

// Flags:     (16) Hidden

// GUID:      {00000403-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  RecordsetEventsVt = interface(IUnknown)

    ['{00000403-0000-0010-8000-00AA006D2EA4}']

    function WillChangeField(cFields: Integer; Fields: OleVariant; var adStatus: EventStatusEnum;

                             const pRecordset: _Recordset): HResult; stdcall;

    function FieldChangeComplete(cFields: Integer; Fields: OleVariant; const pError: Error;

                                 var adStatus: EventStatusEnum; const pRecordset: _Recordset): HResult; stdcall;

    function WillChangeRecord(adReason: EventReasonEnum; cRecords: Integer;

                              var adStatus: EventStatusEnum; const pRecordset: _Recordset): HResult; stdcall;

    function RecordChangeComplete(adReason: EventReasonEnum; cRecords: Integer;

                                  const pError: Error; var adStatus: EventStatusEnum;

                                  const pRecordset: _Recordset): HResult; stdcall;

    function WillChangeRecordset(adReason: EventReasonEnum; var adStatus: EventStatusEnum;

                                 const pRecordset: _Recordset): HResult; stdcall;

    function RecordsetChangeComplete(adReason: EventReasonEnum; const pError: Error;

                                     var adStatus: EventStatusEnum; const pRecordset: _Recordset): HResult; stdcall;

    function WillMove(adReason: EventReasonEnum; var adStatus: EventStatusEnum;

                      const pRecordset: _Recordset): HResult; stdcall;

    function MoveComplete(adReason: EventReasonEnum; const pError: Error;

                          var adStatus: EventStatusEnum; const pRecordset: _Recordset): HResult; stdcall;

    function EndOfRecordset(var fMoreData: WordBool; var adStatus: EventStatusEnum;

                            const pRecordset: _Recordset): HResult; stdcall;

    function FetchProgress(Progress: Integer; MaxProgress: Integer; var adStatus: EventStatusEnum;

                           const pRecordset: _Recordset): HResult; stdcall;

    function FetchComplete(const pError: Error; var adStatus: EventStatusEnum;

                           const pRecordset: _Recordset): HResult; stdcall;

  end;

 

// *********************************************************************//

// DispIntf:  ConnectionEvents

// Flags:     (4096) Dispatchable

// GUID:      {00000400-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ConnectionEvents = dispinterface

    ['{00000400-0000-0010-8000-00AA006D2EA4}']

    procedure InfoMessage(const pError: Error; var adStatus: EventStatusEnum;

                          const pConnection: _Connection); dispid 0;

    procedure BeginTransComplete(TransactionLevel: Integer; const pError: Error;

                                 var adStatus: EventStatusEnum; const pConnection: _Connection); dispid 1;

    procedure CommitTransComplete(const pError: Error; var adStatus: EventStatusEnum;

                                  const pConnection: _Connection); dispid 3;

    procedure RollbackTransComplete(const pError: Error; var adStatus: EventStatusEnum;

                                    const pConnection: _Connection); dispid 2;

    procedure WillExecute(var Source: WideString; var CursorType: CursorTypeEnum;

                          var LockType: LockTypeEnum; var Options: Integer;

                          var adStatus: EventStatusEnum; const pCommand: _Command;

                          const pRecordset: _Recordset; const pConnection: _Connection); dispid 4;

    procedure ExecuteComplete(RecordsAffected: Integer; const pError: Error;

                              var adStatus: EventStatusEnum; const pCommand: _Command;

                              const pRecordset: _Recordset; const pConnection: _Connection); dispid 5;

    procedure WillConnect(var ConnectionString: WideString; var UserID: WideString;

                          var Password: WideString; var Options: Integer;

                          var adStatus: EventStatusEnum; const pConnection: _Connection); dispid 6;

    procedure ConnectComplete(const pError: Error; var adStatus: EventStatusEnum;

                              const pConnection: _Connection); dispid 7;

    procedure Disconnect(var adStatus: EventStatusEnum; const pConnection: _Connection); dispid 8;

  end;

 

// *********************************************************************//

// DispIntf:  RecordsetEvents

// Flags:     (4096) Dispatchable

// GUID:      {00000266-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  RecordsetEvents = dispinterface

    ['{00000266-0000-0010-8000-00AA006D2EA4}']

    procedure WillChangeField(cFields: Integer; Fields: OleVariant; var adStatus: EventStatusEnum;

                              const pRecordset: _Recordset); dispid 9;

    procedure FieldChangeComplete(cFields: Integer; Fields: OleVariant; const pError: Error;

                                  var adStatus: EventStatusEnum; const pRecordset: _Recordset); dispid 10;

    procedure WillChangeRecord(adReason: EventReasonEnum; cRecords: Integer;

                               var adStatus: EventStatusEnum; const pRecordset: _Recordset); dispid 11;

    procedure RecordChangeComplete(adReason: EventReasonEnum; cRecords: Integer;

                                   const pError: Error; var adStatus: EventStatusEnum;

                                   const pRecordset: _Recordset); dispid 12;

    procedure WillChangeRecordset(adReason: EventReasonEnum; var adStatus: EventStatusEnum;

                                  const pRecordset: _Recordset); dispid 13;

    procedure RecordsetChangeComplete(adReason: EventReasonEnum; const pError: Error;

                                      var adStatus: EventStatusEnum; const pRecordset: _Recordset); dispid 14;

    procedure WillMove(adReason: EventReasonEnum; var adStatus: EventStatusEnum;

                       const pRecordset: _Recordset); dispid 15;

    procedure MoveComplete(adReason: EventReasonEnum; const pError: Error;

                           var adStatus: EventStatusEnum; const pRecordset: _Recordset); dispid 16;

    procedure EndOfRecordset(var fMoreData: WordBool; var adStatus: EventStatusEnum;

                             const pRecordset: _Recordset); dispid 17;

    procedure FetchProgress(Progress: Integer; MaxProgress: Integer; var adStatus: EventStatusEnum;

                            const pRecordset: _Recordset); dispid 18;

    procedure FetchComplete(const pError: Error; var adStatus: EventStatusEnum;

                            const pRecordset: _Recordset); dispid 19;

  end;

 

// *********************************************************************//

// Interface: ADOConnectionConstruction15

// Flags:     (512) Restricted

// GUID:      {00000516-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ADOConnectionConstruction15 = interface(IUnknown)

    ['{00000516-0000-0010-8000-00AA006D2EA4}']

    function Get_DSO(out ppDSO: IUnknown): HResult; stdcall;

    function Get_Session(out ppSession: IUnknown): HResult; stdcall;

    function WrapDSOandSession(const pDSO: IUnknown; const pSession: IUnknown): HResult; stdcall;

  end;

 

// *********************************************************************//

// Interface: ADOConnectionConstruction

// Flags:     (512) Restricted

// GUID:      {00000551-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ADOConnectionConstruction = interface(ADOConnectionConstruction15)

    ['{00000551-0000-0010-8000-00AA006D2EA4}']

  end;

 

// *********************************************************************//

// Interface: ADOCommandConstruction

// Flags:     (512) Restricted

// GUID:      {00000517-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ADOCommandConstruction = interface(IUnknown)

    ['{00000517-0000-0010-8000-00AA006D2EA4}']

    function Get_OLEDBCommand(out ppOLEDBCommand: IUnknown): HResult; stdcall;

    function Set_OLEDBCommand(const ppOLEDBCommand: IUnknown): HResult; stdcall;

  end;

 

// *********************************************************************//

// Interface: ADORecordsetConstruction

// Flags:     (4608) Restricted Dispatchable

// GUID:      {00000283-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  ADORecordsetConstruction = interface(IDispatch)

    ['{00000283-0000-0010-8000-00AA006D2EA4}']

    function Get_Rowset(out ppRowset: IUnknown): HResult; stdcall;

    function Set_Rowset(const ppRowset: IUnknown): HResult; stdcall;

    function Get_Chapter(out plChapter: Integer): HResult; stdcall;

    function Set_Chapter(plChapter: Integer): HResult; stdcall;

    function Get_RowPosition(out ppRowPos: IUnknown): HResult; stdcall;

    function Set_RowPosition(const ppRowPos: IUnknown): HResult; stdcall;

  end;

 

// *********************************************************************//

// Interface: Field15

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000505-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Field15 = interface(_ADO)

    ['{00000505-0000-0010-8000-00AA006D2EA4}']

    function Get_ActualSize: Integer; safecall;

    function Get_Attributes: Integer; safecall;

    function Get_DefinedSize: Integer; safecall;

    function Get_Name: WideString; safecall;

    function Get_Type_: DataTypeEnum; safecall;

    function Get_Value: OleVariant; safecall;

    procedure Set_Value(pvar: OleVariant); safecall;

    function Get_Precision: Byte; safecall;

    function Get_NumericScale: Byte; safecall;

    procedure AppendChunk(Data: OleVariant); safecall;

    function GetChunk(Length: Integer): OleVariant; safecall;

    function Get_OriginalValue: OleVariant; safecall;

    function Get_UnderlyingValue: OleVariant; safecall;

    property ActualSize: Integer read Get_ActualSize;

    property Attributes: Integer read Get_Attributes;

    property DefinedSize: Integer read Get_DefinedSize;

    property Name: WideString read Get_Name;

    property Type_: DataTypeEnum read Get_Type_;

    property Value: OleVariant read Get_Value write Set_Value;

    property Precision: Byte read Get_Precision;

    property NumericScale: Byte read Get_NumericScale;

    property OriginalValue: OleVariant read Get_OriginalValue;

    property UnderlyingValue: OleVariant read Get_UnderlyingValue;

  end;

 

// *********************************************************************//

// DispIntf:  Field15Disp

// Flags:     (4560) Hidden Dual NonExtensible OleAutomation Dispatchable

// GUID:      {00000505-0000-0010-8000-00AA006D2EA4}

// *********************************************************************//

  Field15Disp = dispinterface

    ['{00000505-0000-0010-8000-00AA006D2EA4}']

    property ActualSize: Integer readonly dispid 1109;

    property Attributes: Integer readonly dispid 1036;

    property DefinedSize: Integer readonly dispid 1103;

    property Name: WideString readonly dispid 1100;

    property Type_: DataTypeEnum readonly dispid 1102;

    property Value: OleVariant dispid 0;

    property Precision: Byte readonly dispid 1610809351;

    property NumericScale: Byte readonly dispid 1610809352;

    procedure AppendChunk(Data: OleVariant); dispid 1107;

    function GetChunk(Length: Integer): OleVariant; dispid 1108;

    property OriginalValue: OleVariant readonly dispid 1104;

    property UnderlyingValue: OleVariant readonly dispid 1105;

    property Properties: Properties readonly dispid 500;

  end;

 

  CoConnection = class

    class function Create: _Connection;

    class function CreateRemote(const MachineName: string): _Connection;

  end;

 

  CoCommand = class

    class function Create: _Command;

    class function CreateRemote(const MachineName: string): _Command;

  end;

 

  CoRecordset = class

    class function Create: _Recordset;

    class function CreateRemote(const MachineName: string): _Recordset;

  end;

 

  CoParameter = class

    class function Create: _Parameter;

    class function CreateRemote(const MachineName: string): _Parameter;

  end;

 

implementation

 

uses ComObj;

 

class function CoConnection.Create: _Connection;

begin

  Result := CreateComObject(CLASS_Connection) as _Connection;

end;

 

class function CoConnection.CreateRemote(const MachineName: string): _Connection;

begin

  Result := CreateRemoteComObject(MachineName, CLASS_Connection) as _Connection;

end;

 

class function CoCommand.Create: _Command;

begin

  Result := CreateComObject(CLASS_Command) as _Command;

end;

 

class function CoCommand.CreateRemote(const MachineName: string): _Command;

begin

  Result := CreateRemoteComObject(MachineName, CLASS_Command) as _Command;

end;

 

class function CoRecordset.Create: _Recordset;

begin

  Result := CreateComObject(CLASS_Recordset) as _Recordset;

end;

 

class function CoRecordset.CreateRemote(const MachineName: string): _Recordset;

begin

  Result := CreateRemoteComObject(MachineName, CLASS_Recordset) as _Recordset;

end;

 

class function CoParameter.Create: _Parameter;

begin

  Result := CreateComObject(CLASS_Parameter) as _Parameter;

end;

 

class function CoParameter.CreateRemote(const MachineName: string): _Parameter;

begin

  Result := CreateRemoteComObject(MachineName, CLASS_Parameter) as _Parameter;

end;

 

end.

 

Delphi - .....................................

 

Bu web sitesi ücretsiz olarak Bedava-Sitem.com ile oluşturulmuştur. Siz de kendi web sitenizi kurmak ister misiniz?
Ücretsiz kaydol