Set Options to customize how the provider communicates with client datasets. Options is a set that specifies 

Whether nested detail sets and BLOB data are included in data packets or fetched separately. 

Whether data packets include field component properties such as formats, display names, and maximum & minimum values. 

Whether data packets are provided on a read-only basis, and whether specific types of changes (insertions, edits, or deletions) are disabled. 

Whether changes to master table fields should cause corresponding updates to detail tables. 

Whether a single update can affect multiple server records. 

Whether the client's records are refreshed when it applies updates. 

Whether the client can send SQL statements that override the provider's dataset.

Data 

ApplyUpdates 

Overriding the Dataset On the Application Server 

Setting Options That Influence the Data Packets