Dynamic Select Sample

The sample shows how to use the Dynamic Select feature to decrease network traffic and server load, retrieving only needed columns.

Examine the code

• Take a look at the TClientForm.btLoadClick event handler to see how you can fill DataSet using the Dynamic Select feature.
• Look at the TClientForm.btUpdateClick event handler to see how updates of the local DataSet can be applied to the back-end server database.
  Note that Update operation always uses the DynamicSelect mode of the previous Fill operation.

Getting started

• Run the Sample Server.
• Run the Dynamic Select Sample.
• Try to fill and update DataSet using the Dynamic Select feature.
• Look at the server log, to see the SQL command used on the server and estimate the amount of data sent to the client application.
• Try to fill and update DataSet not using the Dynamic Select feature.
• Look at the server log again to see the amount of data sent to the client application by the server.