ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
CtCursorOptions (Property)
In french: CxOptionsCurseur
OLE DBAvailable only with this kind of connection
The CtCursorOptions property gets the cursor type used when connecting to an external database.
The cursor type is defined using HDescribeConnection or HOpenConnection.
Example
// Get the cursor type used to traverse through data // via "MyConnection"Info(MyConnection.CtCursorOptions)
Syntax
<Cursor type> = <File name/connection>.CtCursorOptions
<Cursor type>: Integer constant
Returns the cursor type used. This parameter can correspond to one or more of the following constants:
Cursor location
hClientCursorCursor managed by MDAC. Generally, it offers more features than a server-side cursor. A client-side cursor is always static.
hServerCursorCursor managed by the database. This cursor can easily reflect changes made to data by other users.
Cursor type
hDynamicCursorThis cursor offers many features, but consumes a lot of memory. This cursor supports all types of scrolling. You can access all insert, update and delete operations made by other users.
hForwardOnlyCursorThis cursor is fast and consumes little memory. The cursor can only move forward and be scrolled from the first to the last record. Changes made by other users are not visible.
hOpenKeysetCursorThis cursor handles a fixed set of records. Only the key of each record is stored and not the actual record (consumes less memory). Deleted records cannot be accessed. Changes made by other users are visible (but added records are not).
hStaticCursorMakes a copy of all query records in memory (high memory consumption). All types of scrolling are supported.
Lock modes
hReadOnlyCursorThe record set manipulated cannot be modified.
hOptimisticCursorThe record is locked when it is updated
hPessimisticCursorThe record is locked as soon as it is edited.
Remark: If no constant was specified in HDescribeConnection, this parameter is set to 0.
Caution: some types of cursors may not be supported by all the OLE DB providers.
<File name/connection>: Character string
Remarks
The CtCursorOptions property is used to get the cursor type used in a connection. This property is kept for backward compatibility. It is recommended to use the CursorOptions property.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/14/2024

Send a report | Local help