Data.Win.ADODB.TCursorType

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

TCursorType = (ctUnspecified, ctOpenForwardOnly, ctKeyset, ctDynamic,
ctStatic);

C++

enum DECLSPEC_DENUM TCursorType : unsigned char { ctUnspecified, ctOpenForwardOnly, ctKeyset, ctDynamic, ctStatic };

Properties

Type Visibility Source Unit Parent
enum public
Data.Win.ADODB.pas
Data.Win.ADODB.hpp
Data.Win.ADODB Data.Win.ADODB

Description

TCursorType valies indicate the type of cursor to use for a recordset.

Use TCursorType values to indicate the type of cursor to use when a recordset is opened.

The constants of TCursorType correspond with the CursorTypeEnum values for the CursorType property of the ADO recordset object. See the Microsoft Data Access SDK help for information on these values and their effects.

TCursorType consists of the five constants summarized in the following table:



Cursor Type Meaning

ctUnspecified

A specific cursor type has not yet been specified.

ctOpenForwardOnly

Forward-only cursor in which you can only scroll forward; better performance because only requires single through recordset.

ctKeyset

Keyset cursor; records added by other users are not visible; records deleted by other users are inaccessible.

ctDynamic

Dynamic cursor; data modifications, deletions, and insertions by other users are visible; scrolling forward and back allowed.

ctStatic

Static cursor; static copy of records; data changes by other users not visible; used mostly for reporting.



Note: Only ctStatic is supported if the CursorLocation property of the ADO dataset component is set to clUseClient.

Note: If the requested cursor type is not supported by the provider, the provider may return another cursor type. This alternate cursor type is reflected in the CursorType property after the recordset is opened.

See Also