Functions > Enum Functions > DaoCursorDriverEnum()

Purpose

Returns a 2-dimensional array with all the values of the CursorDriver Enum.

Description

Every row in this array has 2 values:

•	The numeric value of the Enum value

•	A text representation of this value

This array can be used to validate values, and to print a ,meaningful description of the values during debugging

You can pass this array tro the DaoEnum2Str() function to convert the value of an Enum to a string

Constant

Description

dbUseDefaultCursor

(Default) Uses server-side cursors if the server supports them; otherwise use the ODBC Cursor Library.

dbUseODBCCursor

Always uses the ODBC Cursor Library. This option provides better performance for small result sets, but degrades quickly for larger result sets.

dbUseServerCursor

Always uses server-side cursors. For most large operations this option provides better performance, but might cause more network traffic.

dbUseClientBatchCursor

Always uses the client batch cursor library. This option is required for batch updates.

dbUseNoCursor

Opens all cursors (that is, Recordset objects) as forward-only type, read-only, with a rowset size of 1. Also known as "cursorless queries."

Returns

Array