Flylib.com
Advantage Database Server: The Official Guide
Advantage Database Server: The Official Guide
ISBN: 0072230843
EAN: 2147483647
Year: 2002
Pages: 129
Authors:
Cary Jensen
,
Loy Anderson
BUY ON AMAZON
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
Year: 2002
Pages: 129
Authors:
Cary Jensen
,
Loy Anderson
BUY ON AMAZON
SQL Tips & Techniques (Miscellaneous)
Using Data Control Language (DCL) to Setup Database Security
Performing Multiple-table Queries and Creating SQL Data Views
Retrieving and Manipulating Data Through Cursors
Understanding Triggers
Repairing and Maintaining MS-SQL Server Database Files
The CISSP and CAP Prep Guide: Platinum Edition
Security Architecture and Design
Operations Security
Application Security
Initiation of the System Authorization Process
Appendix F Security Control Catalog
Oracle Developer Forms Techniques
Timers and Displaying a Clock
Using Form and Global Variables
Advanced Forms Programming
Summary
Programmatically Canceling a Query
Mapping Hacks: Tips & Tools for Electronic Cartography
Hacks 1-13
Hack 12. Create a Distance Grid in Excel
Hack 23. Explore David Rumseys Historical Maps
Hack 38. Add Location to Weblogs and RSS Feeds
Hack 82. Find Nearby Things Using U.S. ZIP Codes
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hacks 1016: Introduction
Hack 24. Search for Events by Location
Hack 33. Why Your Cell Phone Doesnt Work There
Hack 41. How Google Maps Got Me Out of a Traffic Ticket
Hack 61. Use the Right Developers Key Automatically
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #1: Delight Your Customers with Speed and Quality
Key #2: Improve Your Processes
When Companies Start Using Lean Six Sigma
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies