List of Figures
Table of content
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.
Table of content
Advantage Database Server: The Official Guide
BUY ON AMAZON
Similar book on Amazon
High-Speed Signal Propagation[c] Advanced Black Magic
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Inside Network Security Assessment: Guarding Your IT Infrastructure
Tools Used for Assessments and Evaluations
Security Incident Response Team (SIRT)
The Complete Cisco VPN Configuration Guide
PIX Deployment Scenarios
Data Structures and Algorithms in Java
Packages and Access Levels
An Introduction to Design Patterns in C++ with Qt 4
Part I: Introduction to C++ and Qt 4
Example Project: Using QApplication and QLabel
Safer Typecasting Using ANSI C++ Typecasts
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 90 Introduction
Article 100 Definitions
Article 280 Surge Arresters
Example No. D2(b) Optional Calculation for One-Family Dwelling, Air Conditioning Larger than Heating [See 220.82(A) and 220.82(C)]
Annex E. Types of Construction
Microsoft WSH and VBScript Programming for the Absolute Beginner
Overview of the Windows Script Host
Constants, Variables, and Arrays
Using Procedures to Organize Scripts
Appendix B Built-In VBScript Functions
flylib.com © 2008-2017.
If you may any questions please contact us: email@example.com
to find out more.