TsgcWSPServer_DatasetProperties › UpdateMode

UpdateMode Property

Strategy used to match an incoming update against a row in the server dataset.

Syntax

property UpdateMode: TwsDatasetUpdateMode read FUpdateMode write FUpdateMode;

Default Value

Remarks

Controls how the server locates the affected row when a client sends an update or delete. upWhereAll (the default) requires every old field value to match, mimicking optimistic locking; upWhereKeyOnly matches on the primary key fields only; upWhereChanged matches on the primary key plus the fields actually being changed; upRefreshAll ignores row matching and rebroadcasts the entire dataset when it is refreshed.

Example

oProtocol.UpdateMode := upWhereKeyOnly;

Back to Properties