The aim of this book is to teach cross-platform database programming to Delphi 6 or Kylix programmers. The book will assume the reader has a basic understanding of databases, such as what tables, rows, columns, fields, indexes, etc. are. It will also assume the reader has a working knowledge of Delphi and/or Kylix.
A thorough investigation of cross-platform database development using dbExpress will follow the introduction. Eric will cover topics ranging from setting up a database connection to single- and multi-tiered database applications. Along the way, he will present code snippets and small sample applications to illustrate the points being made. Also, a complete database application will be presented which will compile and run under either Delphi or Kylix, and will contain such discussed features as disconnected datasets.
(NOTE: Each chapter concludes with a Summary.)
Who This Book Is For. How This Book Is Organized. Conventions Used in This Book. Contacting the Author.
Connecting to and Disconnecting from a Database. Retrieving Database Metadata. Executing DDL and DML Statements. Transaction Support. Providing Feedback During SQL Operations.
What Are dbExpress Datasets? Types of Datasets. Data Manipulation. BLOB Support. Parameterized Queries. Ordering Data Returned from the Server. Master/Detail Relationships. Retrieving Schema Information.
What Is a Client Dataset? Advantages and Disadvantages of Client Datasets. Creating Client Datasets. Populating and Manipulating Client Datasets. Navigating Client Datasets. Client Dataset Indexes. Filters and Ranges. Searching.
Dataset Events. Disabling Data-Aware Components. BLOBs. Nested Datasets. Undo Support. Cloning Data from Another Client Dataset. Maintained Aggregates. Miscellaneous Properties.
What Are Data-Aware Components? TDataSource. Common Data-Aware Component Characteristics. Simple Data-Aware Components. VCL-Only Data-Aware Controls. Lookup Data-Aware Controls. TDBNavigator. Creating Your Own Data-Aware Components. Sample Application
TDBGrid. TClientDataSetGrid. TDBCtrlGrid. Third-Party Data-Aware Grids.
What Is a Dataset Provider? Connecting to a Dataset. Resolving Changes to Data. Provider Options. Provider Events. Changing Field Values on the Server. Intercepting Data. Optional Parameters. Master/Detail Relationships. Providing and Resolving Data from Stored Procedures and Joins. Connecting to a Local Database.
What Is DataSnap? Creating the Application Server. Creating the Client Application. A Complete Example. The Briefcase Model. Stateless Servers. Sharing a Connection Between Multiple Client DataSets. Brokering Connections Between Multiple Servers.
What Is ConMan? Database Structure. Overview of the Code. The Server Application. The Client Application. Room for Improvement.
Redistributable Files. Licensing Issues. CD-ROM-Based Applications.
What Is dbExpress Plus? For More Information.