| True DataControl 8.0 Reference > True DataControl Control > TData Control Properties > CursorType Property |
CursorType Property
Sets the cursor type to use for the underlying recordset.
TData.CursorType = value
Read/Write at run time and design time. Property applies to TData control.
|
Values |
Description |
|
1 |
adOpenKeyset |
|
2 |
adOpenDynamic |
|
3 |
adOpenStatic (default) |
This property determines the type of cursor used for the SourceRecordset in data source mode (DataMode = 0 - DataSource).
1 – adOpenKeyset - Keyset cursor. Data changes made by other users to rows of your recordset are visible to your recordset, but you can't see records that other users add and delete.
2 – adOpenDynamic - Dynamic cursor. Additions, changes, and deletions by other users are visible.
3 – adOpenStatic - Static cursor. Additions, changes, or deletions by other users are not visible.
CursorType is a standard ADO recordset property. It can be set at any time during the control’s lifetime, but it will take effect only if set at design time, in WillOpenData event or after the Refresh method is called.
Notes: At design time, this property is not available in property pages and must be set in the Visual Basic Properties window.
The CursorType property affects SourceRecordset only. The TData control’s Recordset always has the 3 – adOpenStatic setting.
See Also