DefaultCursorType Property (Data Control)
TOC
Collapse the table of content
Expand the table of content

Visual Basic Reference

Visual Studio 6.0

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

Show:
© 2016 Microsoft