TMSDataSetOptions.CheckRowVersion Property

Used to determine whether dataset checks for rows modifications made by another user on automatic generation of SQL statement for update or delete data.

Class

TMSDataSetOptions

Syntax

property CheckRowVersion: boolean default False;

Remarks

Use the CheckRowVersion property to determine whether dataset checks for rows modifications made by another user on automatic generation of SQL statement for update or delete data. If the CheckRowVersion property is False and DataSet has keyfields, the WHERE clause of SQL statement is generated basing on these keyfields. If there is no primary key and no Identity field, then all non-BLOB fields will take part in generating SQL statements. If CheckRowVersion is True and DataSet has TIMESTAMP field, only this field is included into the WHERE clause of the generated SQL statement. Otherwise, all non-BLOB fields are included. All mentioned fields refer to the current TMSQuery.UpdatingTable. The default value is False.

The CheckRowVersion option requires enabled TCustomMSDataSet.Options.