Delphi 2 - Delphi Client/Server Suite 2.0 Client/Server Database Architecture

By: Lance Devin

Abstract: Delphi Client /Server Suite incorporates integrated technologies that help solve your business needs.

Delphi Client / Server Suite 2.0
Client/Server Database Architecture (cont.)

C. Database Controls

Delphi Client / Server Suite 2.0 provides over 15 database visualization controls so that applications can take on an appealing and functional design. These controls are easy to use and because they are object oriented, completely extensible and customizable. Database controls such as Edits, Memos, and Database Grids can perform sophisticated Client / Server operations without requiring code. In addition, all database controls will take on the extended field attributes defined in the Scaleable Database Dictionary so that consistent user interface and data validation can be applied across applications.

Delphi Client / Server Suite 2.0 has over 15 Database GUI Controls

New to Delphi Client / Server Suite 2.0 are the Multi-Object Grid, an enhanced DataGrid with codeless lookup functionality, and enhanced database list and combo boxes. These controls offer the flexibility to convey information to the user in a way that corresponds to the business need and application requirements.

1. Multi-Object Grid

The multi-object grid allows the developer to place other database controls into a single row of this grid. CheckBoxes, Edits and so forth can be stacked or visually placed where you like, and with full replication. The flexibility and simplicity of conveying information in this way adds to the presentation of information and productivity of users.

Delphi Client / Server Suite 2.0's new Multi-Object Grid allows the developer to design a custom window of information

2. Enhanced DataGrid with Codeless Lookups

Applications like Executive Information Systems and Decision Support Systems require consistent data for accurate reporting of daily operations. The new DataGrid in Delphi Client / Server Suite 2.0 allows for codeless lookups between tables which ensures data validation and consistency. Drop down lists can now be used to supply information from one table to store in another. The developer can now create a data entry model that provides for consistent data entry.

Delphi Client / Server Suite 2.0's new codeless lookups in the enhanced datagrid.

The DataGrid has also been enhanced to be independent of the Dataset. This provides the flexibility to use different grids to look at the same table, query or stored procedure in different ways. The developer can apply column attributes such as position, fonts, colors, headers, width, etc. to highlight important information and to convey different messages about the data.

3. DataListBox and DataComboBox

The DataListBox and the DataComboBox seamlessly link information between multiple Datasources whether they be queries, stored procedures or tables. Developers can now codelessly order pick lists so that users can find data more easily and enhance their productivity. Client / Server applications rely on normalized, validated and coherent data so that important business decisions can be made accurately.

D. ReportSmith

ReportSmith turns data into information that assists in making every day business decisions. ReportSmith can directly access the Delphi Datasets offering easy integration. This allows client/server developers to create complex database reports against extremely large quantities of data. ReportSmith supports columnar, crosstab, form, or mailing label reports, offering the flexibility to view data typically found in executive information systems and decision support systems.

One language can control all aspects of Client / Server applications reducing the learning curve of your developers. By sharing the Delphi data connection from within ReportSmith, developers are able to control the content, sort order, and grouping of a report with code.

ReportSmith offers high volume Client / Server reporting

E. QuickReport

Delphi Client / Server Suite 2.0 also includes QuickReport, an integrated set of Delphi components that rapidly creates columnar, master­detail, and label reports. While Report Smith is optimized for large volumes of data that are typically found in corporate client/server applications, QuickReport is optimized for smaller volumes of data and simpler reporting styles.

QuickReport integrates data reporting into Delphi Client / Server Suite 2.0 applications.

QuickReport is comprised of eleven components that intuitively allow the developer to create report bands, attach to Delphi datasets, and then finally lay out report fields. Printing, Previewing, and Page Orientation are invoked with simple object methods making it easy to incorporate reports into your client / server applications. QuickReport also makes it possible to preview reports in your application so that you can see the information as it would appear on paper. This allows you to look at the information in new ways.

F. Implementation

The Database Component Architecture in Delphi Client / Server Suite 2.0 is an object oriented implementation of the Borland Database Engine. Each object has a modular and tight component API that manages a single aspect of Client / Server database applications. In comparison to a single object/window that manages all aspects of the application, Delphi's componentization offers a degree of isolation between the database and the GUI with the benefits of a shorter learning curve and easier maintenance.

Delphi's Component Architecture eases code maintenance.

  • Session and Database components maintain information to manage transactions and changes to the database server for each connection.

  • Datasets (e.g. query, stored procedure and table) allow the developer to control the communication between Delphi and the Borland Database Engine by providing over 15 events with which to interact.

  • Datasources manage the interaction of the data record with all the GUI data controls.

  • Over 15 data visualization (GUI) controls manage the presentation of data.

This discrete object model provides control of database operations. The programmer can apply scope to business rules and manage every aspect of the Client / Server application. Business rules can be applied at the GUI, the Data Record, the Table, the Database, the Database Server or any combination of the above to provide the most modular and flexible application.

Server Response from: ETNASC04