_ADO | Description |
Property Properties As Properties |
_Collection | Description |
Property Count As Long | |
Sub Refresh |
_DynaCollection | Description |
Property Count As Long | |
Sub Append(ByVal Object As Object) | |
Sub Delete(ByVal Index) | |
Sub Refresh |
ADCPROP_ASYNCTHREADPRIORITY_ENUM | Description |
Const adPriorityAboveNormal = 4 | |
Const adPriorityBelowNormal = 2 | |
Const adPriorityHighest = 5 | |
Const adPriorityLowest = 1 | |
Const adPriorityNormal = 3 |
ADCPROP_AUTORECALC_ENUM | Description |
Const adRecalcAlways = 1 | |
Const adRecalcUpFront = 0 |
ADCPROP_UPDATECRITERIA_ENUM | Description |
Const adCriteriaAllCols = 1 | |
Const adCriteriaKey = 0 | |
Const adCriteriaTimeStamp = 3 | |
Const adCriteriaUpdCols = 2 |
ADCPROP_UPDATERESYNC_ENUM | Description |
Const adResyncAll = 15 | |
Const adResyncAutoIncrement = 1 | |
Const adResyncConflicts = 2 | |
Const adResyncInserts = 8 | |
Const adResyncNone = 0 | |
Const adResyncUpdates = 4 |
AffectEnum | Description |
Const adAffectAll = 3 | (undocumented) |
Const adAffectAllChapters = 4 | |
Const adAffectCurrent = 1 | |
Const adAffectGroup = 2 |
BookmarkEnum | Description |
Const adBookmarkCurrent = 0 | |
Const adBookmarkFirst = 1 | |
Const adBookmarkLast = 2 |
Command | Description |
Property ActiveConnection As _Connection | |
Property CommandText As String | |
Property CommandTimeout As Long | |
Property CommandType As CommandTypeEnum | |
Property Name As String | |
Property Parameters As Parameters | |
Property Prepared As Boolean | |
Property Properties As Properties | |
Property State As Long | |
Sub Cancel | |
Function CreateParameter([ByVal Name As String], [ByVal Type As DataTypeEnumadEmpty], [ByVal Direction As ParameterDirectionEnumadParamInput], [ByVal Size As Long], [ByVal Value]) As _Parameter | |
Function Execute(RecordsAffected, Parameters, [ByVal Options As Long-1]) As _Recordset |
Command15 | Description |
Property ActiveConnection As _Connection | |
Property CommandText As String | |
Property CommandTimeout As Long | |
Property CommandType As CommandTypeEnum | |
Property Name As String | |
Property Parameters As Parameters | |
Property Prepared As Boolean | |
Property Properties As Properties | |
Function CreateParameter([ByVal Name As String], [ByVal Type As DataTypeEnumadEmpty], [ByVal Direction As ParameterDirectionEnumadParamInput], [ByVal Size As Long], [ByVal Value]) As _Parameter | |
Function Execute(RecordsAffected, Parameters, [ByVal Options As Long-1]) As _Recordset |
CommandTypeEnum | Description |
Const adCmdFile = 256 (&H100) | |
Const adCmdStoredProc = 4 | |
Const adCmdTable = 2 | |
Const adCmdTableDirect = 512 (&H200) | |
Const adCmdText = 1 | |
Const adCmdUnknown = 8 | |
Const adCmdUnspecified = -1 (&HFFFFFFFF) | (undocumented) |
CompareEnum | Description |
Const adCompareEqual = 1 | |
Const adCompareGreaterThan = 2 | |
Const adCompareLessThan = 0 | |
Const adCompareNotComparable = 4 | |
Const adCompareNotEqual = 3 |
Connection | Description |
Property Attributes As Long | |
Property CommandTimeout As Long | |
Property ConnectionString As String | |
Property ConnectionTimeout As Long | |
Property CursorLocation As CursorLocationEnum | |
Property DefaultDatabase As String | |
Property Errors As Errors | |
Property IsolationLevel As IsolationLevelEnum | |
Property Mode As ConnectModeEnum | |
Property Properties As Properties | |
Property Provider As String | |
Property State As Long | |
Property Version As String | |
Sub Cancel | |
Sub Close | |
Sub CommitTrans | |
Sub Open([ByVal ConnectionString As String], [ByVal UserID As String], [ByVal Password As String], [ByVal Options As Long-1]) | |
Sub RollbackTrans | |
Function BeginTrans As Long | |
Function Execute(ByVal CommandText As String, RecordsAffected, [ByVal Options As Long-1]) As _Recordset | |
Function OpenSchema(ByVal Schema As SchemaEnum, [ByVal Restrictions], [ByVal SchemaID]) As _Recordset | |
Sub BeginTransComplete(ByVal TransactionLevel As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub CommitTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub ConnectComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub Disconnect(adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub ExecuteComplete(ByVal RecordsAffected As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection) | |
Sub InfoMessage(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub RollbackTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub WillConnect(ConnectionString As String, UserID As String, Password As String, Options As Long, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub WillExecute(Source As String, CursorType As CursorTypeEnum, LockType As LockTypeEnum, Options As Long, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection) |
Connection15 | Description |
Property Attributes As Long | |
Property CommandTimeout As Long | |
Property ConnectionString As String | |
Property ConnectionTimeout As Long | |
Property CursorLocation As CursorLocationEnum | |
Property DefaultDatabase As String | |
Property Errors As Errors | |
Property IsolationLevel As IsolationLevelEnum | |
Property Mode As ConnectModeEnum | |
Property Properties As Properties | |
Property Provider As String | |
Property State As Long | |
Property Version As String | |
Sub Close | |
Sub CommitTrans | |
Sub Open([ByVal ConnectionString As String], [ByVal UserID As String], [ByVal Password As String], [ByVal Options As Long-1]) | |
Sub RollbackTrans | |
Function BeginTrans As Long | |
Function Execute(ByVal CommandText As String, RecordsAffected, [ByVal Options As Long-1]) As _Recordset | |
Function OpenSchema(ByVal Schema As SchemaEnum, [ByVal Restrictions], [ByVal SchemaID]) As _Recordset |
ConnectionEventsVt | Description |
Sub BeginTransComplete(ByVal TransactionLevel As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub CommitTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub ConnectComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub Disconnect(adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub ExecuteComplete(ByVal RecordsAffected As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection) | |
Sub InfoMessage(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub RollbackTransComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub WillConnect(ConnectionString As String, UserID As String, Password As String, Options As Long, adStatus As EventStatusEnum, ByVal pConnection As _Connection) | |
Sub WillExecute(Source As String, CursorType As CursorTypeEnum, LockType As LockTypeEnum, Options As Long, adStatus As EventStatusEnum, ByVal pCommand As _Command, ByVal pRecordset As _Recordset, ByVal pConnection As _Connection) |
ConnectModeEnum | Description |
Const adModeRead = 1 | |
Const adModeReadWrite = 3 | |
Const adModeRecursive = 4194304 (&H400000) | |
Const adModeShareDenyNone = 16 (&H10) | |
Const adModeShareDenyRead = 4 | |
Const adModeShareDenyWrite = 8 | |
Const adModeShareExclusive = 12 | |
Const adModeUnknown = 0 | |
Const adModeWrite = 2 |
ConnectOptionEnum | Description |
Const adAsyncConnect = 16 (&H10) | |
Const adConnectUnspecified = -1 (&HFFFFFFFF) | (undocumented) |
ConnectPromptEnum | Description |
Const adPromptAlways = 1 | |
Const adPromptComplete = 2 | |
Const adPromptCompleteRequired = 3 | |
Const adPromptNever = 4 |
CopyRecordOptionsEnum | Description |
Const adCopyAllowEmulation = 4 | |
Const adCopyNonRecursive = 2 | |
Const adCopyOverWrite = 1 | |
Const adCopyUnspecified = -1 (&HFFFFFFFF) |
CursorLocationEnum | Description |
Const adUseClient = 3 | |
Const adUseClientBatch = 3 | (undocumented) |
Const adUseNone = 1 | (undocumented) |
Const adUseServer = 2 |
CursorOptionEnum | Description |
Const adAddNew = 16778240 (&H1000400) | |
Const adApproxPosition = 16384 (&H4000) | |
Const adBookmark = 8192 (&H2000) | |
Const adDelete = 16779264 (&H1000800) | |
Const adFind = 524288 (&H80000) | |
Const adHoldRecords = 256 (&H100) | |
Const adIndex = 8388608 (&H800000) | |
Const adMovePrevious = 512 (&H200) | |
Const adNotify = 262144 (&H40000) | |
Const adResync = 131072 (&H20000) | |
Const adSeek = 4194304 (&H400000) | |
Const adUpdate = 16809984 (&H1008000) | |
Const adUpdateBatch = 65536 (&H10000) |
CursorTypeEnum | Description |
Const adOpenDynamic = 2 | |
Const adOpenForwardOnly = 0 | |
Const adOpenKeyset = 1 | |
Const adOpenStatic = 3 | |
Const adOpenUnspecified = -1 (&HFFFFFFFF) | (undocumented) |
DataTypeEnum | Description |
Const adArray = 8192 (&H2000) | |
Const adBigInt = 20 (&H14) | |
Const adBinary = 128 (&H80) | |
Const adBoolean = 11 | |
Const adBSTR = 8 | |
Const adChapter = 136 (&H88) | |
Const adChar = 129 (&H81) | |
Const adCurrency = 6 | |
Const adDate = 7 | |
Const adDBDate = 133 (&H85) | |
Const adDBTime = 134 (&H86) | |
Const adDBTimeStamp = 135 (&H87) | |
Const adDecimal = 14 | |
Const adDouble = 5 | |
Const adEmpty = 0 | |
Const adError = 10 | |
Const adFileTime = 64 (&H40) | |
Const adGUID = 72 (&H48) | |
Const adIDispatch = 9 | |
Const adInteger = 3 | |
Const adIUnknown = 13 | |
Const adLongVarBinary = 205 (&HCD) | |
Const adLongVarChar = 201 (&HC9) | |
Const adLongVarWChar = 203 (&HCB) | |
Const adNumeric = 131 (&H83) | |
Const adPropVariant = 138 (&H8A) | |
Const adSingle = 4 | |
Const adSmallInt = 2 | |
Const adTinyInt = 16 (&H10) | |
Const adUnsignedBigInt = 21 (&H15) | |
Const adUnsignedInt = 19 (&H13) | |
Const adUnsignedSmallInt = 18 (&H12) | |
Const adUnsignedTinyInt = 17 (&H11) | |
Const adUserDefined = 132 (&H84) | |
Const adVarBinary = 204 (&HCC) | |
Const adVarChar = 200 (&HC8) | |
Const adVariant = 12 | |
Const adVarNumeric = 139 (&H8B) | |
Const adVarWChar = 202 (&HCA) | |
Const adWChar = 130 (&H82) |
EditModeEnum | Description |
Const adEditAdd = 2 | |
Const adEditDelete = 4 | |
Const adEditInProgress = 1 | |
Const adEditNone = 0 |
Error | Description |
Property Description As String | |
Property HelpContext As Long | |
Property HelpFile As String | |
Property NativeError As Long | |
Property Number As Long | |
Property Source As String | |
Property SQLState As String |
Errors | Description |
Property Count As Long | |
Property Item(ByVal Index) As Error | |
Sub Clear | |
Sub Refresh |
ErrorValueEnum | Description |
Const adErrBoundToCommand = 3707 (&HE7B) | |
Const adErrCannotComplete = 3732 (&HE94) | |
Const adErrCantChangeConnection = 3748 (&HEA4) | |
Const adErrCantChangeProvider = 3220 (&HC94) | |
Const adErrCantConvertvalue = 3724 (&HE8C) | |
Const adErrCantCreate = 3725 (&HE8D) | |
Const adErrCatalogNotSet = 3747 (&HEA3) | |
Const adErrColumnNotOnThisRow = 3726 (&HE8E) | |
Const adErrDataConversion = 3421 (&HD5D) | |
Const adErrDataOverflow = 3721 (&HE89) | |
Const adErrDelResOutOfScope = 3738 (&HE9A) | |
Const adErrDenyNotSupported = 3750 (&HEA6) | |
Const adErrDenyTypeNotSupported = 3751 (&HEA7) | |
Const adErrFeatureNotAvailable = 3251 (&HCB3) | |
Const adErrFieldsUpdateFailed = 3749 (&HEA5) | |
Const adErrIllegalOperation = 3219 (&HC93) | |
Const adErrIntegrityViolation = 3719 (&HE87) | |
Const adErrInTransaction = 3246 (&HCAE) | |
Const adErrInvalidArgument = 3001 (&HBB9) | |
Const adErrInvalidConnection = 3709 (&HE7D) | |
Const adErrInvalidParamInfo = 3708 (&HE7C) | |
Const adErrInvalidTransaction = 3714 (&HE82) | |
Const adErrInvalidURL = 3729 (&HE91) | |
Const adErrItemNotFound = 3265 (&HCC1) | |
Const adErrNoCurrentRecord = 3021 (&HBCD) | |
Const adErrNotExecuting = 3715 (&HE83) | (undocumented) |
Const adErrNotReentrant = 3710 (&HE7E) | |
Const adErrObjectClosed = 3704 (&HE78) | |
Const adErrObjectInCollection = 3367 (&HD27) | |
Const adErrObjectNotSet = 3420 (&HD5C) | |
Const adErrObjectOpen = 3705 (&HE79) | |
Const adErrOpeningFile = 3002 (&HBBA) | |
Const adErrOperationCancelled = 3712 (&HE80) | |
Const adErrOutOfSpace = 3734 (&HE96) | |
Const adErrPermissionDenied = 3720 (&HE88) | |
Const adErrPropConflicting = 3742 (&HE9E) | |
Const adErrPropInvalidColumn = 3739 (&HE9B) | |
Const adErrPropInvalidOption = 3740 (&HE9C) | |
Const adErrPropInvalidValue = 3741 (&HE9D) | |
Const adErrPropNotAllSettable = 3743 (&HE9F) | |
Const adErrPropNotSet = 3744 (&HEA0) | |
Const adErrPropNotSettable = 3745 (&HEA1) | |
Const adErrPropNotSupported = 3746 (&HEA2) | |
Const adErrProviderFailed = 3000 (&HBB8) | |
Const adErrProviderNotFound = 3706 (&HE7A) | |
Const adErrReadFile = 3003 (&HBBB) | |
Const adErrResourceExists = 3731 (&HE93) | |
Const adErrResourceLocked = 3730 (&HE92) | |
Const adErrResourceOutOfScope = 3735 (&HE97) | |
Const adErrSchemaViolation = 3722 (&HE8A) | |
Const adErrSignMismatch = 3723 (&HE8B) | |
Const adErrStillConnecting = 3713 (&HE81) | |
Const adErrStillExecuting = 3711 (&HE7F) | |
Const adErrTreePermissionDenied = 3728 (&HE90) | |
Const adErrUnavailable = 3736 (&HE98) | |
Const adErrUnsafeOperation = 3716 (&HE84) | |
Const adErrURLDoesNotExist = 3727 (&HE8F) | |
Const adErrURLNamedRowDoesNotExist = 3737 (&HE99) | |
Const adErrVolumeNotFound = 3733 (&HE95) | |
Const adErrWriteFile = 3004 (&HBBC) | |
Const adwrnSecurityDialog = 3717 (&HE85) | |
Const adwrnSecurityDialogHeader = 3718 (&HE86) |
EventReasonEnum | Description |
Const adRsnAddNew = 1 | |
Const adRsnClose = 9 | |
Const adRsnDelete = 2 | |
Const adRsnFirstChange = 11 | |
Const adRsnMove = 10 | |
Const adRsnMoveFirst = 12 | |
Const adRsnMoveLast = 15 | |
Const adRsnMoveNext = 13 | |
Const adRsnMovePrevious = 14 | |
Const adRsnRequery = 7 | |
Const adRsnResynch = 8 | |
Const adRsnUndoAddNew = 5 | |
Const adRsnUndoDelete = 6 | |
Const adRsnUndoUpdate = 4 | |
Const adRsnUpdate = 3 |
EventStatusEnum | Description |
Const adStatusCancel = 4 | |
Const adStatusCantDeny = 3 | |
Const adStatusErrorsOccurred = 2 | |
Const adStatusOK = 1 | |
Const adStatusUnwantedEvent = 5 |
ExecuteOptionEnum | Description |
Const adAsyncExecute = 16 (&H10) | |
Const adAsyncFetch = 32 (&H20) | |
Const adAsyncFetchNonBlocking = 64 (&H40) | |
Const adExecuteNoRecords = 128 (&H80) | |
Const adOptionUnspecified = -1 (&HFFFFFFFF) | (undocumented) |
Field | Description |
Property ActualSize As Long | |
Property Attributes As Long | |
Property DataFormat As Unknown | |
Property DefinedSize As Long | |
Property Name As String | |
Property NumericScale As Byte | |
Property OriginalValue | |
Property Precision As Byte | |
Property Properties As Properties | |
Property Status As Long | |
Property Type As DataTypeEnum | |
Property UnderlyingValue | |
Property Value | |
Sub AppendChunk(ByVal Data) | |
Function GetChunk(ByVal Length As Long) |
Field15 | Description |
Property ActualSize As Long | |
Property Attributes As Long | |
Property DefinedSize As Long | |
Property Name As String | |
Property NumericScale As Byte | |
Property OriginalValue | |
Property Precision As Byte | |
Property Properties As Properties | |
Property Type As DataTypeEnum | |
Property UnderlyingValue | |
Property Value | |
Sub AppendChunk(ByVal Data) | |
Function GetChunk(ByVal Length As Long) |
Field20 | Description |
Property ActualSize As Long | |
Property Attributes As Long | |
Property DataFormat As Unknown | |
Property DefinedSize As Long | |
Property Name As String | |
Property NumericScale As Byte | |
Property OriginalValue | |
Property Precision As Byte | |
Property Properties As Properties | |
Property Type As DataTypeEnum | |
Property UnderlyingValue | |
Property Value | |
Sub AppendChunk(ByVal Data) | |
Function GetChunk(ByVal Length As Long) |
FieldAttributeEnum | Description |
Const adFldCacheDeferred = 4096 (&H1000) | |
Const adFldFixed = 16 (&H10) | |
Const adFldIsChapter = 8192 (&H2000) | |
Const adFldIsCollection = 262144 (&H40000) | |
Const adFldIsDefaultStream = 131072 (&H20000) | |
Const adFldIsNullable = 32 (&H20) | |
Const adFldIsRowURL = 65536 (&H10000) | |
Const adFldKeyColumn = 32768 (&H8000) | |
Const adFldLong = 128 (&H80) | |
Const adFldMayBeNull = 64 (&H40) | |
Const adFldMayDefer = 2 | |
Const adFldNegativeScale = 16384 (&H4000) | |
Const adFldRowID = 256 (&H100) | |
Const adFldRowVersion = 512 (&H200) | |
Const adFldUnknownUpdatable = 8 | |
Const adFldUnspecified = -1 (&HFFFFFFFF) | (undocumented) |
Const adFldUpdatable = 4 |
FieldEnum | Description |
Const adDefaultStream = -1 (&HFFFFFFFF) | |
Const adRecordURL = -2 (&HFFFFFFFE) |
Fields | Description |
Property Count As Long | |
Property Item(ByVal Index) As Field | |
Sub _Append(ByVal Name As String, ByVal Type As DataTypeEnum, [ByVal DefinedSize As Long], [ByVal Attrib As FieldAttributeEnumadFldUnspecified]) | (undocumented) |
Sub Append(ByVal Name As String, ByVal Type As DataTypeEnum, [ByVal DefinedSize As Long], [ByVal Attrib As FieldAttributeEnumadFldUnspecified], [ByVal FieldValue]) | |
Sub CancelUpdate | |
Sub Delete(ByVal Index) | |
Sub Refresh | |
Sub Resync([ByVal ResyncValues As ResyncEnumadResyncAllValues]) | |
Sub Update |
Fields15 | Description |
Property Count As Long | |
Property Item(ByVal Index) As Field | |
Sub Refresh |
Fields20 | Description |
Property Count As Long | |
Property Item(ByVal Index) As Field | |
Sub _Append(ByVal Name As String, ByVal Type As DataTypeEnum, [ByVal DefinedSize As Long], [ByVal Attrib As FieldAttributeEnumadFldUnspecified]) | (undocumented) |
Sub Delete(ByVal Index) | |
Sub Refresh |
FieldStatusEnum | Description |
Const adFieldAlreadyExists = 26 (&H1A) | |
Const adFieldBadStatus = 12 | |
Const adFieldCannotComplete = 20 (&H14) | |
Const adFieldCannotDeleteSource = 23 (&H17) | |
Const adFieldCantConvertValue = 2 | |
Const adFieldCantCreate = 7 | |
Const adFieldDataOverflow = 6 | |
Const adFieldDefault = 13 | |
Const adFieldDoesNotExist = 16 (&H10) | |
Const adFieldIgnore = 15 | |
Const adFieldIntegrityViolation = 10 | |
Const adFieldInvalidURL = 17 (&H11) | |
Const adFieldIsNull = 3 | |
Const adFieldOK = 0 | |
Const adFieldOutOfSpace = 22 (&H16) | |
Const adFieldPendingChange = 262144 (&H40000) | |
Const adFieldPendingDelete = 131072 (&H20000) | |
Const adFieldPendingInsert = 65536 (&H10000) | |
Const adFieldPendingUnknown = 524288 (&H80000) | |
Const adFieldPendingUnknownDelete = 1048576 (&H100000) | |
Const adFieldPermissionDenied = 9 | |
Const adFieldReadOnly = 24 (&H18) | |
Const adFieldResourceExists = 19 (&H13) | |
Const adFieldResourceLocked = 18 (&H12) | |
Const adFieldResourceOutOfScope = 25 (&H19) | |
Const adFieldSchemaViolation = 11 | |
Const adFieldSignMismatch = 5 | |
Const adFieldTruncated = 4 | |
Const adFieldUnavailable = 8 | |
Const adFieldVolumeNotFound = 21 (&H15) |
FilterGroupEnum | Description |
Const adFilterAffectedRecords = 2 | |
Const adFilterConflictingRecords = 5 | |
Const adFilterFetchedRecords = 3 | |
Const adFilterNone = 0 | |
Const adFilterPendingRecords = 1 | |
Const adFilterPredicate = 4 | (undocumented) |
GetRowsOptionEnum | Description |
Const adGetRowsRest = -1 (&HFFFFFFFF) |
IRecFields | Description |
Sub ADOCheck |
IsolationLevelEnum | Description |
Const adXactBrowse = 256 (&H100) | |
Const adXactChaos = 16 (&H10) | |
Const adXactCursorStability = 4096 (&H1000) | |
Const adXactIsolated = 1048576 (&H100000) | |
Const adXactReadCommitted = 4096 (&H1000) | |
Const adXactReadUncommitted = 256 (&H100) | |
Const adXactRepeatableRead = 65536 (&H10000) | |
Const adXactSerializable = 1048576 (&H100000) | |
Const adXactUnspecified = -1 (&HFFFFFFFF) |
LineSeparatorEnum | Description |
Const adCR = 13 | |
Const adCRLF = -1 (&HFFFFFFFF) | |
Const adLF = 10 |
LockTypeEnum | Description |
Const adLockBatchOptimistic = 4 | |
Const adLockOptimistic = 3 | |
Const adLockPessimistic = 2 | |
Const adLockReadOnly = 1 | |
Const adLockUnspecified = -1 (&HFFFFFFFF) | (undocumented) |
MarshalOptionsEnum | Description |
Const adMarshalAll = 0 | |
Const adMarshalModifiedOnly = 1 |
MoveRecordOptionsEnum | Description |
Const adMoveAllowEmulation = 4 | |
Const adMoveDontUpdateLinks = 2 | |
Const adMoveOverWrite = 1 | |
Const adMoveUnspecified = -1 (&HFFFFFFFF) |
ObjectStateEnum | Description |
Const adStateClosed = 0 | |
Const adStateConnecting = 2 | |
Const adStateExecuting = 4 | |
Const adStateFetching = 8 | |
Const adStateOpen = 1 |
Parameter | Description |
Property Attributes As Long | |
Property Direction As ParameterDirectionEnum | |
Property Name As String | |
Property NumericScale As Byte | |
Property Precision As Byte | |
Property Properties As Properties | |
Property Size As Long | |
Property Type As DataTypeEnum | |
Property Value | |
Sub AppendChunk(ByVal Val) |
ParameterAttributesEnum | Description |
Const adParamLong = 128 (&H80) | |
Const adParamNullable = 64 (&H40) | |
Const adParamSigned = 16 (&H10) |
ParameterDirectionEnum | Description |
Const adParamInput = 1 | |
Const adParamInputOutput = 3 | |
Const adParamOutput = 2 | |
Const adParamReturnValue = 4 | |
Const adParamUnknown = 0 |
Parameters | Description |
Property Count As Long | |
Property Item(ByVal Index) As _Parameter | |
Sub Append(ByVal Object As Object) | |
Sub Delete(ByVal Index) | |
Sub Refresh |
PersistFormatEnum | Description |
Const adPersistADTG = 0 | |
Const adPersistXML = 1 |
PositionEnum | Description |
Const adPosBOF = -2 (&HFFFFFFFE) | |
Const adPosEOF = -3 (&HFFFFFFFD) | |
Const adPosUnknown = -1 (&HFFFFFFFF) |
Properties | Description |
Property Count As Long | |
Property Item(ByVal Index) As Property | |
Sub Refresh |
Property | Description |
Property Attributes As Long | |
Property Name As String | |
Property Type As DataTypeEnum | |
Property Value |
PropertyAttributesEnum | Description |
Const adPropNotSupported = 0 | |
Const adPropOptional = 2 | |
Const adPropRead = 512 (&H200) | |
Const adPropRequired = 1 | |
Const adPropWrite = 1024 (&H400) |
Record | Description |
Property ActiveConnection | |
Property Fields As Fields | |
Property Mode As ConnectModeEnum | |
Property ParentURL As String | |
Property Properties As Properties | |
Property RecordType As RecordTypeEnum | |
Property Source | |
Property State As ObjectStateEnum | |
Sub Cancel | |
Sub Close | |
Sub DeleteRecord(ByVal Source As String, ByVal Async As Boolean) | |
Sub Open(ByVal Source, ByVal ActiveConnection, ByVal Mode As ConnectModeEnum, [ByVal CreateOptions As RecordCreateOptionsEnumadFailIfNotExists], [ByVal Options As RecordOpenOptionsEnumadOpenRecordUnspecified], ByVal UserName As String, ByVal Password As String) | |
Function CopyRecord([ByVal Source As String], [ByVal Destination As String], ByVal UserName As String, ByVal Password As String, [ByVal Options As CopyRecordOptionsEnumadCopyUnspecified], ByVal Async As Boolean) As String | |
Function GetChildren As _Recordset | |
Function MoveRecord([ByVal Source As String], [ByVal Destination As String], ByVal UserName As String, ByVal Password As String, [ByVal Options As MoveRecordOptionsEnumadMoveUnspecified], ByVal Async As Boolean) As String |
RecordCreateOptionsEnum | Description |
Const adCreateCollection = 8192 (&H2000) | |
Const adCreateNonCollection = 0 | |
Const adCreateOverwrite = 67108864 (&H4000000) | |
Const adCreateStructDoc = -2147483648 (&H80000000) | |
Const adFailIfNotExists = -1 (&HFFFFFFFF) | |
Const adOpenIfExists = 33554432 (&H2000000) |
RecordOpenOptionsEnum | Description |
Const adDelayFetchFields = 32768 (&H8000) | |
Const adDelayFetchStream = 16384 (&H4000) | |
Const adOpenAsync = 4096 (&H1000) | |
Const adOpenRecordUnspecified = -1 (&HFFFFFFFF) | |
Const adOpenSource = 8388608 (&H800000) |
Recordset | Description |
Property AbsolutePage As PositionEnum | |
Property AbsolutePosition As PositionEnum | |
Property ActiveCommand As Object | |
Property ActiveConnection | |
Property BOF As Boolean | |
Property Bookmark | |
Property CacheSize As Long | |
Property Collect(ByVal Index) | (undocumented) |
Property CursorLocation As CursorLocationEnum | |
Property CursorType As CursorTypeEnum | |
Property DataMember As String | |
Property DataSource As Unknown | |
Property EditMode As EditModeEnum | |
Property EOF As Boolean | |
Property Fields As Fields | |
Property Filter | |
Property Index As String | |
Property LockType As LockTypeEnum | |
Property MarshalOptions As MarshalOptionsEnum | |
Property MaxRecords As Long | |
Property PageCount As Long | |
Property PageSize As Long | |
Property Properties As Properties | |
Property RecordCount As Long | |
Property Sort As String | |
Property Source | |
Property State As Long | |
Property Status As Long | |
Property StayInSync As Boolean | |
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) | (undocumented) |
Sub _xSave(ByVal FileName As String, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) | (undocumented) |
Sub AddNew([ByVal FieldList], [ByVal Values]) | |
Sub Cancel | |
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Sub CancelUpdate | |
Sub Close | |
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent]) | |
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start]) | |
Sub Move(ByVal NumRecords As Long, [ByVal Start]) | |
Sub MoveFirst | |
Sub MoveLast | |
Sub MoveNext | |
Sub MovePrevious | |
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1]) | |
Sub Requery([ByVal Options As Long-1]) | |
Sub Resync([ByVal AffectRecords As AffectEnumadAffectAll], [ByVal ResyncValues As ResyncEnumadResyncAllValues]) | |
Sub Save(ByVal Destination, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) | |
Sub Seek(ByVal KeyValues, [ByVal SeekOption As SeekEnumadSeekFirstEQ]) | |
Sub Update([ByVal Fields], [ByVal Values]) | |
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Function _xClone As _Recordset | (undocumented) |
Function Clone([ByVal LockType As LockTypeEnumadLockUnspecified]) As _Recordset | |
Function CompareBookmarks(ByVal Bookmark1, ByVal Bookmark2) As CompareEnum | |
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields]) | |
Function GetString([ByVal StringFormat As StringFormatEnumadClipString], [ByVal NumRows As Long-1], ByVal ColumnDelimeter As String, ByVal RowDelimeter As String, ByVal NullExpr As String) As String | |
Function NextRecordset([RecordsAffected]) As _Recordset | |
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean | |
Sub EndOfRecordset(fMoreData As Boolean, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub FetchComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub FieldChangeComplete(ByVal cFields As Long, ByVal Fields, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub MoveComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub RecordChangeComplete(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub RecordsetChangeComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillChangeField(ByVal cFields As Long, ByVal Fields, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillChangeRecord(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillChangeRecordset(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillMove(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) |
Recordset15 | Description |
Property AbsolutePage As PositionEnum | |
Property AbsolutePosition As PositionEnum | |
Property ActiveConnection | |
Property BOF As Boolean | |
Property Bookmark | |
Property CacheSize As Long | |
Property Collect(ByVal Index) | (undocumented) |
Property CursorLocation As CursorLocationEnum | |
Property CursorType As CursorTypeEnum | |
Property EditMode As EditModeEnum | |
Property EOF As Boolean | |
Property Fields As Fields | |
Property Filter | |
Property LockType As LockTypeEnum | |
Property MarshalOptions As MarshalOptionsEnum | |
Property MaxRecords As Long | |
Property PageCount As Long | |
Property PageSize As Long | |
Property Properties As Properties | |
Property RecordCount As Long | |
Property Sort As String | |
Property Source | |
Property State As Long | |
Property Status As Long | |
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) | (undocumented) |
Sub AddNew([ByVal FieldList], [ByVal Values]) | |
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Sub CancelUpdate | |
Sub Close | |
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent]) | |
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start]) | |
Sub Move(ByVal NumRecords As Long, [ByVal Start]) | |
Sub MoveFirst | |
Sub MoveLast | |
Sub MoveNext | |
Sub MovePrevious | |
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1]) | |
Sub Requery([ByVal Options As Long-1]) | |
Sub Update([ByVal Fields], [ByVal Values]) | |
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Function _xClone As _Recordset | (undocumented) |
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields]) | |
Function NextRecordset([RecordsAffected]) As _Recordset | |
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean |
Recordset20 | Description |
Property AbsolutePage As PositionEnum | |
Property AbsolutePosition As PositionEnum | |
Property ActiveCommand As Object | |
Property ActiveConnection | |
Property BOF As Boolean | |
Property Bookmark | |
Property CacheSize As Long | |
Property Collect(ByVal Index) | (undocumented) |
Property CursorLocation As CursorLocationEnum | |
Property CursorType As CursorTypeEnum | |
Property DataMember As String | |
Property DataSource As Unknown | |
Property EditMode As EditModeEnum | |
Property EOF As Boolean | |
Property Fields As Fields | |
Property Filter | |
Property LockType As LockTypeEnum | |
Property MarshalOptions As MarshalOptionsEnum | |
Property MaxRecords As Long | |
Property PageCount As Long | |
Property PageSize As Long | |
Property Properties As Properties | |
Property RecordCount As Long | |
Property Sort As String | |
Property Source | |
Property State As Long | |
Property Status As Long | |
Property StayInSync As Boolean | |
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) | (undocumented) |
Sub _xSave(ByVal FileName As String, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) | (undocumented) |
Sub AddNew([ByVal FieldList], [ByVal Values]) | |
Sub Cancel | |
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Sub CancelUpdate | |
Sub Close | |
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent]) | |
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start]) | |
Sub Move(ByVal NumRecords As Long, [ByVal Start]) | |
Sub MoveFirst | |
Sub MoveLast | |
Sub MoveNext | |
Sub MovePrevious | |
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1]) | |
Sub Requery([ByVal Options As Long-1]) | |
Sub Resync([ByVal AffectRecords As AffectEnumadAffectAll], [ByVal ResyncValues As ResyncEnumadResyncAllValues]) | |
Sub Update([ByVal Fields], [ByVal Values]) | |
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Function _xClone As _Recordset | (undocumented) |
Function Clone([ByVal LockType As LockTypeEnumadLockUnspecified]) As _Recordset | |
Function CompareBookmarks(ByVal Bookmark1, ByVal Bookmark2) As CompareEnum | |
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields]) | |
Function GetString([ByVal StringFormat As StringFormatEnumadClipString], [ByVal NumRows As Long-1], ByVal ColumnDelimeter As String, ByVal RowDelimeter As String, ByVal NullExpr As String) As String | |
Function NextRecordset([RecordsAffected]) As _Recordset | |
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean |
Recordset21 | Description |
Property AbsolutePage As PositionEnum | |
Property AbsolutePosition As PositionEnum | |
Property ActiveCommand As Object | |
Property ActiveConnection | |
Property BOF As Boolean | |
Property Bookmark | |
Property CacheSize As Long | |
Property Collect(ByVal Index) | (undocumented) |
Property CursorLocation As CursorLocationEnum | |
Property CursorType As CursorTypeEnum | |
Property DataMember As String | |
Property DataSource As Unknown | |
Property EditMode As EditModeEnum | |
Property EOF As Boolean | |
Property Fields As Fields | |
Property Filter | |
Property Index As String | |
Property LockType As LockTypeEnum | |
Property MarshalOptions As MarshalOptionsEnum | |
Property MaxRecords As Long | |
Property PageCount As Long | |
Property PageSize As Long | |
Property Properties As Properties | |
Property RecordCount As Long | |
Property Sort As String | |
Property Source | |
Property State As Long | |
Property Status As Long | |
Property StayInSync As Boolean | |
Sub _xResync([ByVal AffectRecords As AffectEnumadAffectAll]) | (undocumented) |
Sub _xSave(ByVal FileName As String, [ByVal PersistFormat As PersistFormatEnumadPersistADTG]) | (undocumented) |
Sub AddNew([ByVal FieldList], [ByVal Values]) | |
Sub Cancel | |
Sub CancelBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Sub CancelUpdate | |
Sub Close | |
Sub Delete([ByVal AffectRecords As AffectEnumadAffectCurrent]) | |
Sub Find(ByVal Criteria As String, [ByVal SkipRecords As Long], [ByVal SearchDirection As SearchDirectionEnumadSearchForward], [ByVal Start]) | |
Sub Move(ByVal NumRecords As Long, [ByVal Start]) | |
Sub MoveFirst | |
Sub MoveLast | |
Sub MoveNext | |
Sub MovePrevious | |
Sub Open(ByVal Source, ByVal ActiveConnection, [ByVal CursorType As CursorTypeEnumadOpenUnspecified], [ByVal LockType As LockTypeEnumadLockUnspecified], [ByVal Options As Long-1]) | |
Sub Requery([ByVal Options As Long-1]) | |
Sub Resync([ByVal AffectRecords As AffectEnumadAffectAll], [ByVal ResyncValues As ResyncEnumadResyncAllValues]) | |
Sub Seek(ByVal KeyValues, [ByVal SeekOption As SeekEnumadSeekFirstEQ]) | |
Sub Update([ByVal Fields], [ByVal Values]) | |
Sub UpdateBatch([ByVal AffectRecords As AffectEnumadAffectAll]) | |
Function _xClone As _Recordset | (undocumented) |
Function Clone([ByVal LockType As LockTypeEnumadLockUnspecified]) As _Recordset | |
Function CompareBookmarks(ByVal Bookmark1, ByVal Bookmark2) As CompareEnum | |
Function GetRows([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields]) | |
Function GetString([ByVal StringFormat As StringFormatEnumadClipString], [ByVal NumRows As Long-1], ByVal ColumnDelimeter As String, ByVal RowDelimeter As String, ByVal NullExpr As String) As String | |
Function NextRecordset([RecordsAffected]) As _Recordset | |
Function Supports(ByVal CursorOptions As CursorOptionEnum) As Boolean |
RecordsetEventsVt | Description |
Sub EndOfRecordset(fMoreData As Boolean, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub FetchComplete(ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub FetchProgress(ByVal Progress As Long, ByVal MaxProgress As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub FieldChangeComplete(ByVal cFields As Long, ByVal Fields, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub MoveComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub RecordChangeComplete(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub RecordsetChangeComplete(ByVal adReason As EventReasonEnum, ByVal pError As Error, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillChangeField(ByVal cFields As Long, ByVal Fields, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillChangeRecord(ByVal adReason As EventReasonEnum, ByVal cRecords As Long, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillChangeRecordset(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) | |
Sub WillMove(ByVal adReason As EventReasonEnum, adStatus As EventStatusEnum, ByVal pRecordset As _Recordset) |
RecordStatusEnum | Description |
Const adRecCanceled = 256 (&H100) | |
Const adRecCantRelease = 1024 (&H400) | |
Const adRecConcurrencyViolation = 2048 (&H800) | |
Const adRecDBDeleted = 262144 (&H40000) | |
Const adRecDeleted = 4 | |
Const adRecIntegrityViolation = 4096 (&H1000) | |
Const adRecInvalid = 16 (&H10) | |
Const adRecMaxChangesExceeded = 8192 (&H2000) | |
Const adRecModified = 2 | |
Const adRecMultipleChanges = 64 (&H40) | |
Const adRecNew = 1 | |
Const adRecObjectOpen = 16384 (&H4000) | |
Const adRecOK = 0 | |
Const adRecOutOfMemory = 32768 (&H8000) | |
Const adRecPendingChanges = 128 (&H80) | |
Const adRecPermissionDenied = 65536 (&H10000) | |
Const adRecSchemaViolation = 131072 (&H20000) | |
Const adRecUnmodified = 8 |
RecordTypeEnum | Description |
Const adCollectionRecord = 1 | |
Const adSimpleRecord = 0 | |
Const adStructDoc = 2 |
ResyncEnum | Description |
Const adResyncAllValues = 2 | |
Const adResyncUnderlyingValues = 1 |
SaveOptionsEnum | Description |
Const adSaveCreateNotExist = 1 | |
Const adSaveCreateOverWrite = 2 |
SchemaEnum | Description |
Const adSchemaAsserts = 0 | |
Const adSchemaCatalogs = 1 | |
Const adSchemaCharacterSets = 2 | |
Const adSchemaCheckConstraints = 5 | |
Const adSchemaCollations = 3 | |
Const adSchemaColumnPrivileges = 13 | |
Const adSchemaColumns = 4 | |
Const adSchemaColumnsDomainUsage = 11 | |
Const adSchemaConstraintColumnUsage = 6 | |
Const adSchemaConstraintTableUsage = 7 | |
Const adSchemaCubes = 32 (&H20) | |
Const adSchemaDBInfoKeywords = 30 (&H1E) | |
Const adSchemaDBInfoLiterals = 31 (&H1F) | |
Const adSchemaDimensions = 33 (&H21) | |
Const adSchemaForeignKeys = 27 (&H1B) | |
Const adSchemaHierarchies = 34 (&H22) | |
Const adSchemaIndexes = 12 | |
Const adSchemaKeyColumnUsage = 8 | |
Const adSchemaLevels = 35 (&H23) | |
Const adSchemaMeasures = 36 (&H24) | |
Const adSchemaMembers = 38 (&H26) | |
Const adSchemaPrimaryKeys = 28 (&H1C) | |
Const adSchemaProcedureColumns = 29 (&H1D) | |
Const adSchemaProcedureParameters = 26 (&H1A) | |
Const adSchemaProcedures = 16 (&H10) | |
Const adSchemaProperties = 37 (&H25) | |
Const adSchemaProviderSpecific = -1 (&HFFFFFFFF) | |
Const adSchemaProviderTypes = 22 (&H16) | |
Const adSchemaReferentialConstraints = 9 | |
Const adSchemaReferentialContraints = 9 | (undocumented) |
Const adSchemaSchemata = 17 (&H11) | |
Const adSchemaSQLLanguages = 18 (&H12) | |
Const adSchemaStatistics = 19 (&H13) | |
Const adSchemaTableConstraints = 10 | |
Const adSchemaTablePrivileges = 14 | |
Const adSchemaTables = 20 (&H14) | |
Const adSchemaTranslations = 21 (&H15) | |
Const adSchemaTrustees = 39 (&H27) | |
Const adSchemaUsagePrivileges = 15 | |
Const adSchemaViewColumnUsage = 24 (&H18) | |
Const adSchemaViews = 23 (&H17) | |
Const adSchemaViewTableUsage = 25 (&H19) |
SearchDirection | Description |
Const adSearchBackward = -1 (&HFFFFFFFF) | |
Const adSearchForward = 1 |
SearchDirectionEnum | Description |
Const adSearchBackward = -1 (&HFFFFFFFF) | |
Const adSearchForward = 1 |
SeekEnum | Description |
Const adSeekAfter = 8 | |
Const adSeekAfterEQ = 4 | |
Const adSeekBefore = 32 (&H20) | |
Const adSeekBeforeEQ = 16 (&H10) | |
Const adSeekFirstEQ = 1 | |
Const adSeekLastEQ = 2 |
Stream | Description |
Property Charset As String | |
Property EOS As Boolean | |
Property LineSeparator As LineSeparatorEnum | |
Property Mode As ConnectModeEnum | |
Property Position As Long | |
Property Size As Long | |
Property State As ObjectStateEnum | |
Property Type As StreamTypeEnum | |
Sub Cancel | |
Sub Close | |
Sub CopyTo(ByVal DestStream As _Stream, [ByVal CharNumber As Long-1]) | |
Sub Flush | |
Sub LoadFromFile(ByVal FileName As String) | |
Sub Open(ByVal Source, [ByVal Mode As ConnectModeEnumadModeUnknown], [ByVal Options As StreamOpenOptionsEnumadOpenStreamUnspecified], ByVal UserName As String, ByVal Password As String) | |
Sub SaveToFile(ByVal FileName As String, [ByVal Options As SaveOptionsEnumadSaveCreateNotExist]) | |
Sub SetEOS | |
Sub SkipLine | |
Sub Write(ByVal Buffer) | |
Sub WriteText(ByVal Data As String, [ByVal Options As StreamWriteEnumadWriteChar]) | |
Function Read([ByVal NumBytes As Long-1]) | |
Function ReadText([ByVal NumChars As Long-1]) As String |
StreamOpenOptionsEnum | Description |
Const adOpenStreamAsync = 1 | |
Const adOpenStreamFromRecord = 4 | |
Const adOpenStreamUnspecified = -1 (&HFFFFFFFF) |
StreamReadEnum | Description |
Const adReadAll = -1 (&HFFFFFFFF) | |
Const adReadLine = -2 (&HFFFFFFFE) |
StreamTypeEnum | Description |
Const adTypeBinary = 1 | |
Const adTypeText = 2 |
StreamWriteEnum | Description |
Const adWriteChar = 0 | |
Const adWriteLine = 1 | |
Const stWriteChar = 0 | (undocumented) |
Const stWriteLine = 1 | (undocumented) |
StringFormatEnum | Description |
Const adClipString = 2 |
XactAttributeEnum | Description |
Const adXactAbortRetaining = 262144 (&H40000) | |
Const adXactAsyncPhaseOne = 524288 (&H80000) | (undocumented) |
Const adXactCommitRetaining = 131072 (&H20000) | |
Const adXactSyncPhaseOne = 1048576 (&H100000) | (undocumented) |