ADODB

From XE API Documentation
Jump to: navigation, search

Classes

_Command

_Command is an alias for the MSDN ADO Command object.

_Connection

_Connection is an alias for the MSDN ADO Connection interface.

_Parameter

_Parameter is an alias for the MSDN ADO Parameter object.

_Recordset

_Recordset is an alias for the MSDN ADO Recordset object.

EADOErrorEADOError is the exception class for database errors generated by ADO databases.
Error

Error is an alias for the MSDN ADO Error object.

Errors

Errors is an alias for the MSDN ADO Errors collection.

Parameters

Parameters is an alias for the MSDN ADO Parameters collection.

Properties

Properties is an alias for the MSDN ADO Properties collection.

Property_

Property_ is an alias for the MSDN ADO Property object.

TADOBlobStreamTADOBlobStream is a stream object that reads from and writes to field objects that represent Binary large object (BLOB) fields.
TADOCommand

TADOCommand represents an ADO command object.

TADOConnection

TADOConnection connects to an ADO data store.

TADODataSet

TADODataSet represents a dataset retrieved from an ADO data store.

TADOQuery

TADOQuery provides the means for issuing SQL against an ADO data store.

TADOStoredProc

TADOStoredProc encapsulates a stored procedure in an ADO database.

TADOTable

TADOTable is a dataset component that encapsulates a table accessed through an ADO data store.

TCustomADODataSetTCustomADODataSet is the virtualized base class for all ADO dataset components.
TParameter

TParameter represents a parameter.

TParametersTParameters manages a collection of parameters.
TRDSConnection

TRDSConnection implements an RDS DataSpace object.

Functions

CreateUDLFile
DataLinkDir
GetDataLinkFiles
GetProviderNames
PromptDataLinkFile
PromptDataSource

Types

PVariantList
TADOLockTypeTADOLockType specifies the types of locks used.
TAffectRecords
TBeginTransCompleteEvent
TCommandTypeTCommandType values designate the type of a command.
TConnectErrorEvent
TConnectModeTConnectMode values indicate the persimissions available to a connection.
TConnectOptionTConnectOption indicates whether the connection to the ADO data store is synchronous or asynchronous.
TCursorLocationTCursorLocation values specify whether to use client-side or server-side cursor library.
TCursorOptionTCursorOptions values indicate the functionality a recordset provides.
TCursorOptionsTCursorOptions indicates the functionality provided by a recordset.
TCursorTypeTCursorType valies indicate the type of cursor to use for a recordset.
TDataTypeTDataType indicates the type of a parameter.
TDisconnectEvent
TEndOfRecordsetEvent
TEventReasonTEventReason values indicate the reason an event occurred.
TEventStatusTEventStatus values indicate the success or failure of an operation.
TExecuteCompleteEvent
TExecuteOption
TExecuteOptionsTExecuteOptions values specify the characteristics of an execution operation.
TFetchProgressEvent
TFieldChangeCompleteEvent
TFilterGroup
TInfoMessageEvent
TIsolationLevelTIsolationLevel values specify the level of isolation for a connection.
TMarshalOption
TObjectState
TObjectStatesTObjectStates values indicate the current state of an ADO object.
TParameterAttribute
TParameterAttributesTParameterAttributes values indicate the types of values a parameter can accept.
TParameterDirectionTParameterDirection specifies the direction of a parameter.
TPersistFormatTPersistFormat values indicate the format for a saved recordset.
TPropList
TRecordChangeCompleteEvent
TRecordsetCreate
TRecordsetErrorEvent
TRecordsetEvent
TRecordsetReasonEvent
TRecordStatus
TRecordStatusSetTRecordStatusSet values indicate the status of the current record relative to batch updates or other bulk operations.
TSchemaInfoTSchemaInfo values indicate the type of schema information to retrieve.
TSeekOption
TVariantList
TWillChangeFieldEvent
TWillChangeRecordEvent
TWillConnectEvent
TWillExecuteEvent
TXactAttributeTXactAttribute values specify automated transaction behavior.
TXactAttributes

Variables

TPropList
TVariantList

Constants

arAllarAll: TAffectRecords = arAll;
arAllChaptersarAllChapters: TAffectRecords = arAllChapters;
arCurrentarCurrent: TAffectRecords = arCurrent;
arFilteredarFiltered: TAffectRecords = arFiltered;
clUseClientclUseClient: TCursorLocation = clUseClient;
clUseServerclUseServer: TCursorLocation = clUseServer;
cmdFilecmdFile: TCommandType = cmdFile;
cmdStoredProccmdStoredProc: TCommandType = cmdStoredProc;
cmdTablecmdTable: TCommandType = cmdTable;
cmdTableDirectcmdTableDirect: TCommandType = cmdTableDirect;
cmdTextcmdText: TCommandType = cmdText;
cmdUnknowncmdUnknown: TCommandType = cmdUnknown;
cmReadcmRead: TConnectMode = cmRead;
cmReadWritecmReadWrite: TConnectMode = cmReadWrite;
cmShareDenyNonecmShareDenyNone: TConnectMode = cmShareDenyNone;
cmShareDenyReadcmShareDenyRead: TConnectMode = cmShareDenyRead;
cmShareDenyWritecmShareDenyWrite: TConnectMode = cmShareDenyWrite;
cmShareExclusivecmShareExclusive: TConnectMode = cmShareExclusive;
cmUnknowncmUnknown: TConnectMode = cmUnknown;
cmWritecmWrite: TConnectMode = cmWrite;
coAddNewcoAddNew: TCursorOption = coAddNew;
coApproxPositioncoApproxPosition: TCursorOption = coApproxPosition;
coAsyncConnectcoAsyncConnect: TConnectOption = coAsyncConnect;
coBookmarkcoBookmark: TCursorOption = coBookmark;
coConnectUnspecifiedcoConnectUnspecified: TConnectOption = coConnectUnspecified;
coDeletecoDelete: TCursorOption = coDelete;
coFindcoFind: TCursorOption = coFind;
coHoldRecordscoHoldRecords: TCursorOption = coHoldRecords;
coIndexcoIndex: TCursorOption = coIndex;
coMovePreviouscoMovePrevious: TCursorOption = coMovePrevious;
coNotifycoNotify: TCursorOption = coNotify;
coResynccoResync: TCursorOption = coResync;
coSeekcoSeek: TCursorOption = coSeek;
coUpdatecoUpdate: TCursorOption = coUpdate;
coUpdateBatchcoUpdateBatch: TCursorOption = coUpdateBatch;
ctDynamicctDynamic: TCursorType = ctDynamic;
ctKeysetctKeyset: TCursorType = ctKeyset;
ctOpenForwardOnlyctOpenForwardOnly: TCursorType = ctOpenForwardOnly;
ctStaticctStatic: TCursorType = ctStatic;
ctUnspecifiedctUnspecified: TCursorType = ctUnspecified;
eoAsyncExecuteeoAsyncExecute: TExecuteOption = eoAsyncExecute;
eoAsyncFetcheoAsyncFetch: TExecuteOption = eoAsyncFetch;
eoAsyncFetchNonBlockingeoAsyncFetchNonBlocking: TExecuteOption = eoAsyncFetchNonBlocking;
eoExecuteNoRecordseoExecuteNoRecords: TExecuteOption = eoExecuteNoRecords;
erAddNewerAddNew: TEventReason = erAddNew;
erCloseerClose: TEventReason = erClose;
erDeleteerDelete: TEventReason = erDelete;
erFirstChangeerFirstChange: TEventReason = erFirstChange;
erMoveerMove: TEventReason = erMove;
erMoveFirsterMoveFirst: TEventReason = erMoveFirst;
erMoveLasterMoveLast: TEventReason = erMoveLast;
erMoveNexterMoveNext: TEventReason = erMoveNext;
erMovePreviouserMovePrevious: TEventReason = erMovePrevious;
erRequeryerRequery: TEventReason = erRequery;
erResyncherResynch: TEventReason = erResynch;
erUndoAddNewerUndoAddNew: TEventReason = erUndoAddNew;
erUndoDeleteerUndoDelete: TEventReason = erUndoDelete;
erUndoUpdateerUndoUpdate: TEventReason = erUndoUpdate;
erUpdateerUpdate: TEventReason = erUpdate;
esCancelesCancel: TEventStatus = esCancel;
esCantDenyesCantDeny: TEventStatus = esCantDeny;
esErrorsOccuredesErrorsOccured: TEventStatus = esErrorsOccured;
esOKesOK: TEventStatus = esOK;
esUnwantedEventesUnwantedEvent: TEventStatus = esUnwantedEvent;
fgAffectedRecordsfgAffectedRecords: TFilterGroup = fgAffectedRecords;
fgConflictingRecordsfgConflictingRecords: TFilterGroup = fgConflictingRecords;
fgFetchedRecordsfgFetchedRecords: TFilterGroup = fgFetchedRecords;
fgNonefgNone: TFilterGroup = fgNone;
fgPendingRecordsfgPendingRecords: TFilterGroup = fgPendingRecords;
fgPredicatefgPredicate: TFilterGroup = fgPredicate;
fgUnassignedfgUnassigned: TFilterGroup = fgUnassigned;
ilBrowseilBrowse: TIsolationLevel = ilBrowse;
ilChaosilChaos: TIsolationLevel = ilChaos;
ilCursorStabilityilCursorStability: TIsolationLevel = ilCursorStability;
ilIsolatedilIsolated: TIsolationLevel = ilIsolated;
ilReadCommittedilReadCommitted: TIsolationLevel = ilReadCommitted;
ilReadUncommittedilReadUncommitted: TIsolationLevel = ilReadUncommitted;
ilRepeatableReadilRepeatableRead: TIsolationLevel = ilRepeatableRead;
ilSerializableilSerializable: TIsolationLevel = ilSerializable;
ilUnspecifiedilUnspecified: TIsolationLevel = ilUnspecified;
ltBatchOptimisticltBatchOptimistic: TADOLockType = ltBatchOptimistic;
ltOptimisticltOptimistic: TADOLockType = ltOptimistic;
ltPessimisticltPessimistic: TADOLockType = ltPessimistic;
ltReadOnlyltReadOnly: TADOLockType = ltReadOnly;
ltUnspecifiedltUnspecified: TADOLockType = ltUnspecified;
moMarshalAllmoMarshalAll: TMarshalOption = moMarshalAll;
moMarshalModifiedOnlymoMarshalModifiedOnly: TMarshalOption = moMarshalModifiedOnly;
paLongpaLong: TParameterAttribute = paLong;
paNullablepaNullable: TParameterAttribute = paNullable;
paSignedpaSigned: TParameterAttribute = paSigned;
pdInputpdInput: TParameterDirection = pdInput;
pdInputOutputpdInputOutput: TParameterDirection = pdInputOutput;
pdOutputpdOutput: TParameterDirection = pdOutput;
pdReturnValuepdReturnValue: TParameterDirection = pdReturnValue;
pdUnknownpdUnknown: TParameterDirection = pdUnknown;
pfADTGpfADTG: TPersistFormat = pfADTG;
pfXMLpfXML: TPersistFormat = pfXML;
rsCanceledrsCanceled: TRecordStatus = rsCanceled;
rsCantReleasersCantRelease: TRecordStatus = rsCantRelease;
rsConcurrencyViolationrsConcurrencyViolation: TRecordStatus = rsConcurrencyViolation;
rsDBDeletedrsDBDeleted: TRecordStatus = rsDBDeleted;
rsDeletedrsDeleted: TRecordStatus = rsDeleted;
rsIntegrityViolationrsIntegrityViolation: TRecordStatus = rsIntegrityViolation;
rsInvalidrsInvalid: TRecordStatus = rsInvalid;
rsMaxChangesExceededrsMaxChangesExceeded: TRecordStatus = rsMaxChangesExceeded;
rsModifiedrsModified: TRecordStatus = rsModified;
rsMultipleChangesrsMultipleChanges: TRecordStatus = rsMultipleChanges;
rsNewrsNew: TRecordStatus = rsNew;
rsObjectOpenrsObjectOpen: TRecordStatus = rsObjectOpen;
rsOKrsOK: TRecordStatus = rsOK;
rsOutOfMemoryrsOutOfMemory: TRecordStatus = rsOutOfMemory;
rsPendingChangesrsPendingChanges: TRecordStatus = rsPendingChanges;
rsPermissionDeniedrsPermissionDenied: TRecordStatus = rsPermissionDenied;
rsSchemaViolationrsSchemaViolation: TRecordStatus = rsSchemaViolation;
rsUnmodifiedrsUnmodified: TRecordStatus = rsUnmodified;
siAssertssiAsserts: TSchemaInfo = siAsserts;
siCatalogssiCatalogs: TSchemaInfo = siCatalogs;
siCharacterSetssiCharacterSets: TSchemaInfo = siCharacterSets;
siCheckConstraintssiCheckConstraints: TSchemaInfo = siCheckConstraints;
siCollationssiCollations: TSchemaInfo = siCollations;
siColumnPrivilegessiColumnPrivileges: TSchemaInfo = siColumnPrivileges;
siColumnssiColumns: TSchemaInfo = siColumns;
siColumnsDomainUsagesiColumnsDomainUsage: TSchemaInfo = siColumnsDomainUsage;
siConstraintColumnUsagesiConstraintColumnUsage: TSchemaInfo = siConstraintColumnUsage;
siConstraintTableUsagesiConstraintTableUsage: TSchemaInfo = siConstraintTableUsage;
siCubessiCubes: TSchemaInfo = siCubes;
siDBInfoKeywordssiDBInfoKeywords: TSchemaInfo = siDBInfoKeywords;
siDBInfoLiteralssiDBInfoLiterals: TSchemaInfo = siDBInfoLiterals;
siDimensionssiDimensions: TSchemaInfo = siDimensions;
siForeignKeyssiForeignKeys: TSchemaInfo = siForeignKeys;
siHierarchiessiHierarchies: TSchemaInfo = siHierarchies;
siIndexessiIndexes: TSchemaInfo = siIndexes;
siKeyColumnUsagesiKeyColumnUsage: TSchemaInfo = siKeyColumnUsage;
siLevelssiLevels: TSchemaInfo = siLevels;
siMeasuressiMeasures: TSchemaInfo = siMeasures;
siMemberssiMembers: TSchemaInfo = siMembers;
siPrimaryKeyssiPrimaryKeys: TSchemaInfo = siPrimaryKeys;
siProcedureColumnssiProcedureColumns: TSchemaInfo = siProcedureColumns;
siProcedureParameterssiProcedureParameters: TSchemaInfo = siProcedureParameters;
siProceduressiProcedures: TSchemaInfo = siProcedures;
siPropertiessiProperties: TSchemaInfo = siProperties;
siProviderSpecificsiProviderSpecific: TSchemaInfo = siProviderSpecific;
siProviderTypessiProviderTypes: TSchemaInfo = siProviderTypes;
siReferentialConstraintssiReferentialConstraints: TSchemaInfo = siReferentialConstraints;
siSchematasiSchemata: TSchemaInfo = siSchemata;
siSQLLanguagessiSQLLanguages: TSchemaInfo = siSQLLanguages;
siStatisticssiStatistics: TSchemaInfo = siStatistics;
siTableConstraintssiTableConstraints: TSchemaInfo = siTableConstraints;
siTablePrivilegessiTablePrivileges: TSchemaInfo = siTablePrivileges;
siTablessiTables: TSchemaInfo = siTables;
siTranslationssiTranslations: TSchemaInfo = siTranslations;
siUsagePrivilegessiUsagePrivileges: TSchemaInfo = siUsagePrivileges;
siViewColumnUsagesiViewColumnUsage: TSchemaInfo = siViewColumnUsage;
siViewssiViews: TSchemaInfo = siViews;
siViewTableUsagesiViewTableUsage: TSchemaInfo = siViewTableUsage;
soAftersoAfter: TSeekOption = soAfter;
soAfterEQsoAfterEQ: TSeekOption = soAfterEQ;
soBeforesoBefore: TSeekOption = soBefore;
soBeforeEQsoBeforeEQ: TSeekOption = soBeforeEQ;
soFirstEQsoFirstEQ: TSeekOption = soFirstEQ;
soLastEQsoLastEQ: TSeekOption = soLastEQ;
stClosedstClosed: TObjectState = stClosed;
stConnectingstConnecting: TObjectState = stConnecting;
stExecutingstExecuting: TObjectState = stExecuting;
stFetchingstFetching: TObjectState = stFetching;
stOpenstOpen: TObjectState = stOpen;
xaAbortRetainingxaAbortRetaining: TXactAttribute = xaAbortRetaining;
xaCommitRetainingxaCommitRetaining: TXactAttribute = xaCommitRetaining;