Borland® Delphi™ 6 Developer's Guide

Designing Editable dbExpress Applications

Up to now, we have discussed dbExpress in the context of unidirectional/read-only datasets. The only exception is the example using a TSQLDataset component to execute a stored procedure that adds data to a table. Another method to make datasets editable as with a bidirectional dataset is to use cached updates. To do so, this requires the use of another component, TSQLClientDataset.

TSQLClientDataset

TSQLClientDataset is a component that contains an internal TSQLDataset and TProvider component. The internal TSQLDataset gives the TSQLClientDataset the fast data access benefits of dbExpress. The internal TSQLProvider gives the TSQLClientDataset the bidirectional navigation and ability to edit data.

Using ...