Visual Basic Reference
DefaultCursorType Property (Data Control)
See Also Example Applies To
Controls what type of cursor driver is used on the connection (ODBCDirect only) created by the Data control.
Syntax
object.DefaultCursorType [ = value ]
The DefaultCursorType property syntax has these parts:
Part | Description |
object | An object expression that evaluates to an object in the Applies To list. |
value | An integer constant or value that specifies a type of cursor driver, as described in Settings. |
Settings
The settings for value are:
Setting | Value | Description |
vbUseDefaultCursor | 0 | Let the ODBC driver determine which type of cursors to use. |
vbUseODBCCursor | 1 | Use the ODBC cursor library. This option gives better performance for small result sets, but degrades quickly for larger result sets. |
vbUseServerSideCursor | 2 | Use server side cursors. For most large operations this gives better performance, but might cause more network traffic. |
Remarks
Use this property when the DefaultType property of the Data control is set to dbUseODBC. Refer to the DefaultCursorDriver property of the Workspace object for more information.
Data Type
Integer