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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Introduction to Computer Programming
Characters, Strings, and Text Output
Making Programs Think Branching Statements and Subroutines
Loading and Saving Information Using Files
Multiplayer Programming The Crazy Carnage Game
Qshell for iSeries
Running Qshell
Using Parameters and Variables
The Integrated File System
Commands
Scripts - Debugging, Signals, and Traps
Introduction to 80x86 Assembly Language and Computer Architecture
Branching and Looping
Bit Manipulation
The Assembly Process
Appendix A Hexadecimal/ASCII conversion
Appendix B Useful MS-DOS Commands
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 8. Generate Links to Google Maps in a Spreadsheet
Hack 17. Map the News
Hacks 2941: Introduction
Hack 49. Generate Geocoded RSS from Any Google Map
Hack 52. Put a Map and HTML into Your Info Windows
AutoCAD 2005 and AutoCAD LT 2005. No Experience Required
Getting to Know AutoCAD
Basic Commands to Get Started
Gaining Drawing Strategies: Part 2
Using Layers to Organize Your Drawing
Managing External References
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Command-Line SQL*Plus
Running SQL Queries
Executing the Statement in the Buffer
Working with PL/SQL
Prompting for Values
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