ADO Data Control Constants
Keywords: ADO Data Control Constants
Appearance Constants
Constant Value Description adFlatBevel 0 Flat bevel ad3Dbevel 1 3D bevel
BOFAction Constants
Constant Value Description adDoMoveFirst 0 Move to the first record adStayBOF 1 Remain at the beginning
CommandType Constants
Constant Value Description adCmdText 1 Text adCmdTable 2 Table adCmdStoredProc 4 Stored procedure adCmdUnknown 8 Unknown
Mode Constants
Constant Value Description adModeUnknown 0 Unknown adModeRead 1 Read adModeWrite 2 Write adModeReadWrite 3 Read/Write adModeShareDenyRead 4 DenyRead adModeShareDenyWrite 8 DenyWrite adModeShareExclusive 12 Exclusive adModeShareDenyNone 16 DenyNone
ConnectionString Constants
Constant Value Description adConnectStringTypeUnknown 0 Unknown. adOLEDB 1 OLEDB connection string. adOLEDBFile 2 Use OLEDB file. adODBC 3 Use ODBC.
CursorLocation Constants
Constant Value Description adUseServer 2 Use server cursors adUseClient 3 Use client batch cursors
CursorType Constants
Constant Value Description adOpenKeyset 1 Keyset Cursor adOpenDynamic 2 Dynamic Cursor adOpenStatic 3 Static Cursor
Note ForwardOnly cursors are not available for the ADO Data Control.
EOFAction Constants
Constant Value Description adDoMoveLast 0 Move to last record adStayEOF 1 Stay at the EOF adDoAddNew 2 Add a new record
EventReason Constants
Constant Value Description adRsnAddNew 1 New record to be added. adRsnDelete 2 Record deleted. adRsnUpdate 3 Record to be updated. adRsnUndoUpdate 4 Undo update. adRsnUndoAddNew 5 Undo add new record. adRsnUndoDelete 6 Undo delete. adRsnRequery 7 Requery adRsnResynch 8 Resynchronize adRsnClose 9 Close adRsnMove 10 Move
EventStatus Constants
Constant Value Description adStatusOK 1 OK adStatusErrorsOccurred 2 Errors occurred. adStatusCantDeny 3 adStatusCancel 4 Cancel adStatusUnwantedEvent 5
LockType Constants
Constant Value Description adLockUnspecified -1 Unspecified LockType adLockReadOnly 1 ReadOnly LockType adLockPessimistic 2 Pessimistic LockType adLockOptimistic 3 Optimistic LockType adLockBatchOptimistic 4 BatchOptimistic LockType
Orientation Constants
Constant Value Description adHorizontal 0 Horizontal orientation adVertical 1 Vertical orientation
Article ID: W14661Filename: ADO Data Control Constants.txt