Advantage Database Server: The Official Guide
Advantage Database Server: The Official Guide
ISBN: 0072230843
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 129
Pages: 129
Authors: Cary Jensen, Loy Anderson
- Table of Contents
- BackCover
- Advantage Database Server - The Official Guide
- Introduction
- Who This Book Is For
- Part I: ADS and the Advantage Data Architect
- Chapter 1: Introduction to Advantage Database Server
- Advantage Database Server Versus Advantage Local Server
- Advantage Tools
- Building Database Applications Using ADS
- Features Added in ADS Version 7
- Chapter 2: Creating Tables
- ADS Supported Table Types
- Creating ADS Tables
- Working with Tables
- Other Table Support Features
- Chapter 3: Defining Indexes
- Overview of Index Files
- Creating Indexes
- Testing Indexes
- Indexes and Performance
- Full Text Search Indexes
- Chapter 4: Understanding and Using Data Dictionaries
- Creating a Data Dictionary
- Adding Tables to a Data Dictionary
- Data Dictionaries and Table Encryption
- Implementing Security with Data Dictionaries
- Comparing Data Dictionaries
- Chapter 5: Defining Constraints and Referential Integrity
- Advantages of Constraints
- Creating Constraints
- Defining Referential Integrity Constraints
- Update and Delete Rules
- Comments About Constraints and Referential Integrity
- Chapter 6: Working with Views
- Overview of Views
- Creating Editable Views
- Views That Use Views
- Selecting Record Subsets from Views
- Views That Use Other Database Tables
- Chapter 7: Creating Advantage Extended Procedures (AEPs)
- Overview of Stored Procedures
- The Structure of AEPs
- Writing AEPs
- Using AEPs
- Chapter 8: Defining Triggers
- Overview of Triggers
- Creating Triggers
- Example Triggers
- Using Triggers
- Part II: Using Advantage SQL
- Chapter 9: Introduction to Using Advantage SQL
- Overview of Advantage SQL Queries
- Additional ADS SQL Topics
- Advantage SQL Utilities
- Chapter 10: Using SQL to Perform Common Database Operations
- Creating and Modifying Objects
- Selecting Data
- Changing Data
- Using Transactions
- Chapter 11: Using SQL to Access Metadata and Managed Data Dictionaries
- System Tables
- Dictionary-Related SQL Statements
- System Stored Procedures
- Part III: Accessing ADS Data
- Chapter 12: Using ADS from Delphi
- ADS and Delphi
- Performing Basic Tasks with ADS and Delphi
- Navigational Actions with ADS and Delphi
- Administrative Operations with ADS and Delphi
- Chapter 13: Using ADS from Java
- Performing Basic Tasks with ADS and Java
- Navigational Actions with ADS and Java
- Administrative Operations with ADS and Java
- The Advantage JDBC Driver and JBuilder s DataExpress
- Chapter 14: Using ADS from Visual Basic and ADO
- MDAC, OLE DB, ADO, and ADS
- Performing Basic Tasks with ADS and ADO
- Navigational Actions with ADS and ADO
- Administrative Operations with ADS and ADO
- Chapter 15: Using the Advantage .NET Data Provider
- ADS and ADO.NET
- Performing Basic Tasks with ADS and ADO.NET
- Navigational Actions with ADS and ADO.NET
- Administrative Operations with ADS and ADO.NET
- Chapter 16: Using ADS with ODBC, PHP, and DBIPerl
- Accessing ADS Using the Advantage PHP Extension
- A Sample PHP Web Site
- Accessing Data Using the Advantage DBI Driver (for Perl)
- Part: IV: Appendixes
- Appendix A: ADS Installation and Other Setup Issues
- Running ADS Without a Network
- Getting Information About Advantage Error Codes
- The Error Table
- Exclusive Locks and Cursor Caching
- Appendix B: Installing the Code Samples
- Installing the Sample Database and Code
- Downloading the Code Samples
- Appendix C: Book Web Support Site
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_Y
- Index_Z
- List of Figures
- List of Tables
- List of Listings
Advantage Database Server: The Official Guide
ISBN: 0072230843
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 129
Pages: 129
Authors: Cary Jensen, Loy Anderson