Visual Basic: ADO Data Control
ADO Data Control Constants
See Also
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 |