|
|
|
|
|
CtCursorOptions (Property) In french: CxOptionsCurseur
Available only with this kind of connection
The CtCursorOptions property gets the cursor type used when connecting to an external database.
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 | hClientCursor | Cursor managed by MDAC. Generally, it offers more features than a server-side cursor. A client-side cursor is always static. | hServerCursor | Cursor managed by the database. This cursor can easily reflect changes made to data by other users. | Cursor type | hDynamicCursor | This 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. | hForwardOnlyCursor | This 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. | hOpenKeysetCursor | This 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). | hStaticCursor | Makes a copy of all query records in memory (high memory consumption). All types of scrolling are supported. | Lock modes | hReadOnlyCursor | The record set manipulated cannot be modified. | hOptimisticCursor | The record is locked when it is updated | hPessimisticCursor | The record is locked as soon as it is edited. | Note: If no constant has been specified in function HDescribeConnection, this parameter is set to 0.Caution: not all OLE DB providers support all cursor types. <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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|