SDAC

TCustomMSDataSet.CursorType Property

Cursor types supported by SQL Server.

Class

TCustomMSDataSet

Syntax

property CursorType: TMSCursorType default ctDefaultResultSet;

Remarks

Depending on the text of the SQL statement cursor type and the value of the TCustomDADataSet.ReadOnly property when Options is True, cursor type can be modified while opening a dataset. To learn more about implicit conversion of cursors, refer to MSDN .

ctStatic, ctKeyset and ctDynamic cursors are server cursors. So the TCustomDADataSet.FetchRows, FetchAll, TMemDataSet.CachedUpdates properties don't have any influence on such cursors and only the Options.CursorUpdate option does.

To learn how to choose cursor type, refer to MSDN .

The default value is ctDefaultResultSet.

See Also

© 1997-2019 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback