Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
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: W14661
Filename: ADO Data Control Constants.txt
File Created: 2001:02:21:13:03:54
Last Updated: 2001:02:21:13:03:54