TMSDataSetOptions.UniqueRecords Property

Used to specify whether to query additional keyfields from the server.

Class

TMSDataSetOptions

Syntax

property UniqueRecords: boolean default True;

Remarks

Use the UniqueRecords property to specify whether to query additional keyfields from the server. If UniqueRecords is False, keyfields aren't queried from the server when they are not included in the query explicitly. For example, the result of the query execution "SELECT ShipName FROM Orders" holds the only field - ShipName. When used with the TCustomDADataSet.ReadOnly property set to True, the UniqueRecords option gives insignificant advantage of performance. But in this case SQLRefresh will be generated in simplified way. If UniqueRecord is True, keyfields needed for the complete automatic generation of SQLInsert, SQLUpdate, SQLDelete or SQLRefresh statements are queried from the server implicitly. For example, the result of query execution "SELECT ShipName FROM Orders" holds at least two fields - ShipName and OrderID. The default value is False. Has effect only for the TCustomMSDataSet.CursorType cursor.