List of Figures

Chapter 1: Introduction to Advantage Database Server

Figure 1-1: Use the Advantage Configuration Utility to view statistics for and to configure your ADS server.

Figure 1-2: The Installation Info page of the Advantage Configuration Utility

Figure 1-3: The Database Settings page of the Advantage Configuration Utility

Figure 1-4: The File Locations page of the Advantage Configuration Utility

Figure 1-5: The Communications page of the Advantage Configuration Utility

Figure 1-6: The Misc. Settings page of the Advantage Configuration Utility

Figure 1-7: The main screen of the Advantage Data Architect

Figure 1-8: The ANSI Collation Utility

Chapter 2: Creating Tables

Figure 2-1: The Creating Table dialog box of the Advantage Data Architect

Figure 2-2: The Creating Table dialog box with the structure of a new table defined

Figure 2-3: The newly created table in the Table Browser

Figure 2-4: Use the Open Table(s) dialog box to display an existing ADS table in the Table Browser.

Figure 2-5: If you do not supply a valid password for an encrypted free table, its data is scrambled.

Figure 2-6: The Table Browser displaying data after a valid password has been entered.

Figure 2-7: You change an existing table’s structure using the View\Modify Table Structure dialog box.

Figure 2-8: The View\Modify Table Structure dialog box after the size of the Last Name field was changed and the Last Access field was added.

Figure 2-9: The Advantage Data Import dialog box

Figure 2-10: ADO requires an ADO connection string to connect to data.

Figure 2-11: The BDE requires a BDE alias to connect to data.

Figure 2-12: Use the Select Destination page to specify the directory path where imported table(s) are stored.

Figure 2-13: Click Import to begin the data importation.

Figure 2-14: The exported data from the CUST.ADT in CSV format.

Figure 2-15: Use the Tables to Code dialog box to generate table and index creation code that you can use in your client applications.

Figure 2-16: Use the Output Code window to save the generated code.

Chapter 3: Defining Indexes

Figure 3-1: The Index Management dialog box

Figure 3-2: Use the Create New Index page to define indexes.

Figure 3-3: You can view and remove indexes using the View Index Structures page of the Index Management dialog box.

Figure 3-4: Setting the index to CUSTOMER ID sorts the customer records by the Customer ID field.

Figure 3-5: An optimized filter displays a subset of records in the table.

Figure 3-6: The Active Customers conditional index shows only active customers, sorting these records by Date Account Opened and in descending order.

Figure 3-7: The CUSTOMER.ADT table opened in the Table Browser

Figure 3-8: The Create New FTS Index page of the Index Management dialog box

Figure 3-9: A SQL query using full text search in the Native SQL Utility

Figure 3-10: The default settings used for the Notes FTS index order are visible on the View Index Structures page of the Index Management dialog box.

Chapter 4: Understanding and Using Data Dictionaries

Figure 4-1: The data dictionary properties dialog box in the Advantage Database Manager

Figure 4-2: The DemoDictionary data dictionary in the Advantage Database Manager

Figure 4-3: The CUSTOMER and EMPLOYEE tables have been bound to the DemoDictionary data dictionary.

Figure 4-4: You display the data dictionary properties dialog box by right-clicking the data dictionary node in the tree view, and selecting Properties.

Figure 4-5: A total of six tables have been bound to this data dictionary.

Figure 4-6: The Group dialog box allows you to define access rights for a group as well as to display existing properties for the group.

Figure 4-7: The User dialog box displays the properties for the user selected in the Advantage Database Manager tree view.

Figure 4-8: Use the Table Rights dialog box to customize a user’s rights as well as to view effective permissions.

Figure 4-9: The table properties dialog box for the EMPLOYEE table

Figure 4-10: Use the Dictionary Differentiator to compare two data dictionaries.

Figure 4-11: Use the Object Differences dialog box to compare your data dictionaries.

Chapter 5: Defining Constraints and Referential Integrity

Figure 5-1: The Fields dialog box for the CUSTOMER table in the DemoDictionary data dictionary

Figure 5-2: The Fields dialog box for the PRODUCTS table

Figure 5-3: The properties dialog box for the CUSTOMER table

Figure 5-4: The CUSTOMER ID index has been selected as the primary index using the table properties dialog box.

Figure 5-5: The newly defined RI object is displayed in an ER diagram.

Figure 5-6: The EMPLOYEE table now appears in the ER diagram, although it is not yet part of an RI definition.

Figure 5-7: The RI Object Name page of the Referential Integrity Creation dialog box

Figure 5-8: The Update/Delete rules page of the Referential Integrity Creation dialog box

Chapter 6: Working with Views

Figure 6-1: Creating a new view

Figure 6-2: After a view has been created, you can select and open it.

Figure 6-3: A result set returned by a view in the Table Browser

Figure 6-4: The Native SQL Utility

Figure 6-5: A SQL SELECT statement that selects all fields from a view.

Figure 6-6: The Sales by Employee view in the Table Browser

Figure 6-7: The Link dialog box

Chapter 7: Creating Advantage Extended Procedures (AEPs)

Figure 7-1: A new C# AEP project opened in Visual Studio .NET 2003

Figure 7-2: The Advantage Extended Procedure dialog box

Figure 7-3: The results of a stored procedure shown in the Native SQL Utility

Chapter 8: Defining Triggers

Figure 8-1: The CUST_BAK and EMP_BAK tables have been added to the data dictionary.

Figure 8-2: You use the Triggers dialog box to create SQL script triggers.

Figure 8-3: The Archive Employee trigger in the Triggers dialog box

Figure 8-4: The Restore Customer trigger in the Triggers dialog box

Figure 8-5: A new trigger project in Visual Studio .NET

Figure 8-6: Registering a DLL-based trigger

Figure 8-7: Registering a COM or .NET class library trigger

Chapter 9: Introduction to Using Advantage SQL

Figure 9-1: The Advantage Query Builder

Figure 9-2: A query being prepared in the modeling area

Figure 9-3: Generated SQL appears in the SQL pane of the work area.

Figure 9-4: The result set selected by the SQL statement shown in Figure 9-3.

Figure 9-5: The Native SQL Utility

Figure 9-6: Options dialog box for SQL queries

Figure 9-7: The results of a query displayed in the results pane

Figure 9-8: The ODBC SQL Utility

Figure 9-9: A query has been executed from the ODBC SQL Utility.

Chapter 10: Using SQL to Perform Common Database Operations

Figure 10-1: Concatenated string fields include trailing spaces.

Chapter 12: Using ADS from Delphi

Figure 12-1: The Delphi_TDataSet project’s main form

Figure 12-2: A range limits the records available in a table.

Chapter 13: Using ADS from Java

Figure 13-1: The MainFrame JFrame class in the JBuilder designer

Figure 13-2: The JTable obtains its data from ResultTableModel.

Figure 13-3: Use the Connection property editor to reference the Advantage JDBC Driver.

Chapter 14: Using ADS from Visual Basic and ADO

Figure 14-1: The VB_ADO project in Visual Studio

Figure 14-2: Setting the connection properties of an empty UDL file

Figure 14-3: Records returned from a query are displayed in a data grid.

Figure 14-4: A filter has been applied to a Recordset.

Chapter 15: Using the Advantage .NET Data Provider

Figure 15-1: The CS_ADONET project in Visual Studio

Figure 15-2: The results of a SELECT query displayed in a DataGrid

Chapter 16: Using ADS with ODBC, PHP, and DBI/Perl

Figure 16-1: The Advantage StreamlineSQL ODBC Driver Setup dialog box

Figure 16-2: The home page for the PHP Web site

Figure 16-3: The Web page returned by showtables.php

Figure 16-4: The output from showproducts.php

Appendix A: ADS Installation and Other Setup Issues

Figure A-1: The Windows Registry Editor

Figure A-2: The new entry in the Windows registry

Figure A-3: Selecting the Microsoft LoopAback Adapter

Figure A-4: Detailed information about an error is displayed in the Advantage help index.