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.