TDAUpdateMode
Overview
The TDAUpdateMode enumeration describes how the data row to be updated or deleted is located in the underlying database. This parameter can be set for every table in the server Schema individually via properties of the corresponding Business Processor.
In most cases updWhereKeyOnly is the best choice, because every data row in a data table can be uniquely identitifed using its primary key's values. However sometimes server have to ensure that datarow it tries to update was not changed after the updating client app acquired it. In this case the updWhereAll value should be used.
Location
- Unit: uDABusinessProcessor.pas
| Value | Description |
|---|---|
| updWhereAll | All fields defined for the data table will be used to locate records for UPDATEs and DELETEs |
| updWhereKeyAndUserDefined | The fields from the primary key (PK) of the data table plus those listed in the business processor's UserUpdateFields property will be used to locate records for UPDATEs and DELETEs. |
| updWhereKeyOnly | Only the fields from the primary key (PK) of the data table will be used to locate records for UPDATEs and DELETEs. |
| updWhereUserDefined | Only the fields listed in the business processor's UserUpdateFields property will be used to locate records for UPDATEs and DELETEs. |