CursorOptions (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

See also

HFSQL properties

CursorOptions (Property)

In french: OptionsCurseur

Available only with these kinds of connection

..CursorOptions is used to manage the type of cursor used during a connection (Native Accesses, OLE DB, ...). You can:

Find out the type of cursor used for a connection (Native Accesses, OLE DB, ...).
Define the type of cursor used for the connection (Native Accesses, OLE DB, ...). In this case, if the connection is currently opened, it will be closed and re-opened with the new parameters during the first access to a file that is using this connection.

Notes:

The connection can correspond to:
- a connection described in the data model editor,
- a connection described by HConnect, HDescribeConnection or HOpenConnection.
- a connection described by a Connection variable.
The cursors are ignored in HFSQL Client/Server.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Example

MyConnection is Connection
// Describe the connection
MyConnection..User = "USER"
MyConnection..Password = "PASSWORD"
MyConnection..Server = "MYSERVER"
MyConnection..Database = "Database"
MyConnection..Provider = hAccessHFClientServer
MyConnection..Access = hOReadWrite
MyConnection..ExtendedInfo = "Extended information"
MyConnection..CursorOptions = hServerCursor

HOpenConnection(MyConnection)

Syntax

Finding out the type of cursor Hide the details

<Type of cursor> = <Connection name>..CursorOptions

<Type of cursor>: Integer constant

Returns the type of cursor used. This parameter can correspond to one or more of the following constants:
Location of cursors
hClientCursor Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor.
hServerCursor Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.
Type of cursor
hDynamicCursor Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users.
hForwardOnlyCursor Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible.
hOpenKeysetCursor Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions).
hStaticCursor Retrieves a copy of all the query records in memory (consumes a lot of memory). All types of moves are allowed.
Lock modes
hReadOnlyCursor The set of records cannot be modified.
hOptimisticCursor The record is locked when it is updated
hPessimisticCursor The record is locked as soon as it becomes in edit to be modified.
Note: If no constant was specified in HDescribeConnection or in the connection, this parameter is set to 0.
Caution: Some types of cursors may not be supported by all the OLE DB providers or by all the native accesses.

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

Modifying the type of cursor Hide the details

<Connection name>..CursorOptions = <Type of cursor>

<Connection name>: Character string (with or without quotes)

Name of connection used. This name was defined:
in the data model editor,
by HDescribeConnection or HOpenConnection,
by the Connection type.

<Type of cursor>: Integer constant

Returns the type of cursor used. This parameter can correspond to one or more of the following constants:
Location of cursors
hClientCursor Cursor managed by MDAC. Offers more features than a server cursor. A client cursor must necessarily be a static cursor.
hServerCursor Cursor managed by the database. This cursor can easily apply the changes performed by the other users to the data.
Type of cursor
hDynamicCursor Cursor offering a lot of features but consuming a lot of memory. This cursor allows all types of moves. It allows you to access all the modifications, additions and deletions performed by the other users.
hForwardOnlyCursor Fast cursor consuming little memory. The move is performed from the first record to the last one. The data modified by the other users is not visible.
hOpenKeysetCursor Cursor that handles a fixed set of records. Only the keys corresponding to the record are stored and not the records (consumes less memory). The deleted records can no longer be accessed. The modifications performed by the other users are visible (but not the additions).
hStaticCursor Retrieves a copy of all the query records in memory (consumes a lot of memory). All types of moves are allowed.
Lock modes
hReadOnlyCursor The set of records cannot be modified.
hOptimisticCursor The record is locked when it is updated
hPessimisticCursor The record is locked as soon as it becomes in edit to be modified.
Caution: Some types of cursors may not be supported by all the OLE DB providers or by all the native accesses.

Remarks

..CtCursorOptions allows you to find out the type of cursor used during a connection. This property is kept for backward compatibility. We recommend that you use ..CursorOptions.