TCustomMSDataSet.CursorType Property

Cursor types supported by SQL Server.




property CursorType: TMSCursorType default ctDefaultResultSet;


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-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback