FireDAC.TFDMemTable.CachedUpdates Sample

From RAD Studio Code Examples
Jump to: navigation, search

This sample demonstrates how to use the TFDMemTable class to retrieve data from database and manage the cached updates.

Location

You can find the CachedUpdates sample project at:

  • Start | Programs | Embarcadero RAD Studio Alexandria | Samples and then navigate to:
    • Object Pascal\Database\FireDAC\Samples\Comp Layer\TFDMemTable\CachedUpdates
  • Subversion Repository:
    • You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.

Description

The CachedUpdates sample shows you how to work with the TFDMemTable class. To this end, TFDMemTable retrieves data from a database through TFDTableAdapter and TFDCommand. Then, the sample uses some methods and properties of TFDTableAdapter in order to implement some features related with the management of Cached Updates.

How to Use the Sample

  1. Navigate to the location given above and open CDS_CachedUpdates.dproj.
  2. Press F9 or choose Run > Run.
  3. Click on the Use Connection Definition combo box and select an option.
    • Modify the tables and interact with the provided buttons.

Files

File in Delphi Contains

CDS_CachedUpdates.dproj
CDS_CachedUpdates.dpr

The project itself.

fCachedUpdates.pas
fCachedUpdates.fmx

The main form.

Implementation

This sample uses three main components:

When you run the application, click on the Use Connection Definition combo box and select an option in order to define a connection. When you select an item of the combo box, the Active property is set to True in order to open a dataset and read data from a database. Then, the sample displays a table using a TDBGrid component. Once the TDBGrid is filled, you can interact with the sample. Each of the following buttons implements an OnClick event to do what is described below:

  • The RevertRecord button uses the RevertRecord method to undo changes to the current record and remove it from the dataset changes log.
  • The UndoLastChange button uses the UndoLastChange method to undo the last modification to the dataset records and remove the change from the dataset change log.
  • The CancelUpdates button uses the CancelUpdates method to remove all records from the change log and restore the dataset rows to their prior editing state.
  • The ApplyUpdates button uses the ApplyUpdates method to apply changes for all records in the dataset change journal to the database.
Note: These methods may be used only when the CachedUpdates property is set to True. To check it, select the DataSource1 object attached to the TFDMemTable named cdsOrders and see the CachedUpdates property of the DataSet property on the Object Inspector.

Uses

See Also

Samples