TMyDataSetOptions.CheckRowVersion Property

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

Class

TMyDataSetOptions

Syntax

property CheckRowVersion: boolean default False;

Remarks

Use the CheckRowVersion property to determine whether a dataset checks for rows modifications made by another user on automatic generation of SQL statement for update or delete data. If CheckRowVersion is True and DataSet has timestamp field when only this field is added into WHERE clause of generated SQL statement. If CheckRowVersion is True, but there is no TIMESTAMP field, then all nonblob fields will be added to WHERE clause. The default value is False.

If you want to add a field, for example TIMESTAMP , to the WHERE clause, you must declare it in the table as follows: F_TIMESTAMP timestamp not null default current_timestamp on update current_timestamp . If there are no such TIMESTAMP fields in the table, or if they are not declared as described above, all fields (except fields of type BLOB ) will be added to the WHERE clause for comparison. If the table contains several such TIMESTAMP fields, only the last declared field of this type will be included in the query.