EPUB | CHM | PDF

TMySQLDataSet.Methods.ApplyUpdates

Top Previous Next

Writes a dataset's pending cached updates to the database.

Syntax:

procedure ApplyUpdates;

Description:

Call ApplyUpdates to write a dataset's pending cached updates to a database. This method passes cached data to the database for storage, but the changes are not committed to the database. An application must explicitly call the database component's Commit method to commit the changes to the database if the write is successful, or call the database's Rollback method to undo the changes if there is an error.

Following a successful write to the database, and following a successful call to the database's Commit method, an application should call the CommitUpdates method to clear the cached update buffer.

note The preferred method for updating datasets is to call a database component's ApplyUpdates method rather than to call each individual dataset's ApplyUpdates method. The database component's ApplyUpdates method takes care of committing and rolling back transactions and clearing the cache when the operation is successful.