IconAdvantage Database Server
IconIntroduction
IconWhat's New in Advantage 10.1
IconBugs Fixed in 10.10.0.6
IconWhat's New in Advantage 10
IconEffects of Upgrading to Version 10
IconWhat's New in Advantage 9
IconEffects of Upgrading to Version 9.1
IconEffects of Upgrading to Version 9.0
IconWhat's New in Advantage 8.1
IconEffects of Upgrading to Version 8.1
IconWhat's New in Advantage 8.0
IconEffects of Upgrading from a Version Prior to v8.0
IconSupported Operating Systems and Platforms
IconAdvantage Database Server Overview
IconThe Advantage Product Family
IconAdvantage Data Architect
IconImportant Notes
IconKnown Problems
IconInstalling the Advantage Database Server
IconSystem Requirements
IconInstalling and Starting the Advantage Database Server for Windows
IconInstalling and Loading the Advantage Database Server for NetWare
IconInstalling and Starting the Advantage Database Server for Linux
IconPerforming Silent Installs
IconPerforming Simple Upgrades, Expansions and Replication Activation
IconInstalling and Running the Advantage Database Server on a Windows Cluster
IconInstalling Multiple Instances on a Single Server
IconInstalling Multiple Instances on a Single Server in Windows
IconAdvantage Database Server Configuration
IconOverview
IconAdvantage Database Server Configuration for Windows
IconAdvantage Database Server Configuration for NetWare
IconAdvantage Database Server Configuration for Linux
IconAdvantage Database Server Configuration Parameter Settings List
IconAdvantage Management Information
IconAdvantage Database Server NLM Screen
IconAdvantage Database Server NLM Management Utility
IconAdvantage Configuration Utility for Windows
IconAdvantage Management Utility
IconAdvantage Management API
IconAdvantage Internet Server
IconIntroduction and Initial Setup
IconAdvantage Internet Server Overview
IconAdvantage Internet Server System Requirements
IconLicensing
IconSetting up Advantage for the Internet
IconClient-Side Settings
IconSpecifying the Advantage Internet Server Location
IconConnecting Clients Through the Internet to Advantage
IconServer-Side Settings
IconIP
IconManaging Internet Users
IconWatch Dog
IconEnabling Internet Access on a Per User Basis
IconMaximum Failed Login Attempts
IconAdvantage Internet Server Security
IconInternet Security Levels
IconDenial of Service Attacks
IconAuthentication
IconPerformance Factors
IconGeneral Performance Factors
IconPerformance Factors Relative to Non-Client/Server
IconAdvantage Concepts
IconAdvantage Functionality
IconClient/Server Technology
IconMulti-Threading and Multiple Processors
IconExpress Queue
IconDatabase Security
IconAdvantage Locking Modes
IconSingle Application Scalability
IconAdvantage Data Dictionary
IconAdvantage Data Dictionary Upgrades
IconAdvantage Data Dictionary User Permissions
IconEffective Permissions vs Explicit Permissions
IconCommunications Compression
IconTriggers
IconFull Text Search
IconReferential Integrity
IconCallback Functionality
IconFIPS
IconEncryption
IconStrong Encryption Usage Overview
IconCommunications Encryption
IconTLS Certificates
IconTLS Certificate Script
IconReduced File Handle Usage
IconAdvantage Optimized Filters
IconRead-Ahead Record Caching
IconAdvantage Expression Engine
IconTransaction Processing System (TPS)
IconAdvantage Transaction Processing System Overview
IconAdvantage Transaction Processing System Features
IconAdvantage Transaction Processing System Limitations
IconUnpredictable Results with TPS
IconAdvantage TPS Error Conditions
IconAdvantage TPS Behavioral Changes
IconIntegrating TPS into Advantage Applications
IconUsing Transactions in an Application
IconSQL Transaction Processing Statements
IconNesting Transactions
IconTransaction-Free Tables
IconDisabling Database Logins
IconCase Insensitive Field Type
IconTemporary Tables
IconServer-Side Aliases
IconNetwork Attached Storage (NAS) Devices
IconStored Procedures
IconDLL Caching
IconRowVersion and ModTime Field Types
IconSQL Debugger
IconEvents (Notifications)
IconDatabase Roles
IconTemporary File Pooling
IconTable Data Caching
IconUnicode Support
IconAdvantage Extended Procedures
IconAdvantage Extended Procedures
IconWhat is an Advantage Extended Procedure?
IconCreating an Advantage Extended Procedure
IconExecuting an Advantage Extended Procedure
IconTesting and Debugging an Advantage Extended Procedure
IconTips and Tricks
IconAEP Interface Version Comparison
IconTDataSet Descendant Tutorial
IconAdvantage Extended Procedures - TDataSet Descendant Tutorial
IconTask 1:  Copy Test Data and Application
IconTask 2:  Create Your AEP Source File
IconTask 3:  Define Your AEP EntryPoint
IconTask 4:  Add Startup and Shutdown Functions
IconTask 5:  Implement Your Procedure Logic
IconTask 6:  Register Your Procedure in the Data Dictionary
IconTask 7:  Test Your Procedure
IconVisual Basic Tutorial
IconAdvantage Extended Procedures - Visual Basic Tutorial
IconTask 1:  Copy Test Data and Application
IconTask 2:  Create Your AEP Project
IconTask 3:  Define Your AEP Function
IconTask 4:  Add Startup and Shutdown Functions
IconTask 5:  Implement Your Procedure Logic
IconTask 6:  Build and Register Your Procedure for COM Usage
IconTask 7:  Register Your Procedure in the Data Dictionary
IconTask 8:  Test Your Procedure
IconBackup
IconOnline Backup
IconThe adsbackup Utility
IconBackup and Restore Canned Procedures
IconDifferential Backups
IconBackup and Restore Options
IconBackup and Restore Canned Procedure Result Sets
IconReplication
IconReplication Overview
IconGetting Started with Replication
IconReplication Scenarios
IconReplication Options
IconHow Replication Works Internally
IconConnection Pooling Usage
IconTransactions and Replication
IconReferential Integrity and Replication
IconTriggers and Replication
IconForwarding and Loop Detection
IconOffline Targets
IconSecurity
IconAuto-Updating Fields
IconModifying Subscription Information
IconReplication and Deleted Records
IconAdvantage Error Log and Replication
IconFrequently Asked Questions
IconAdvantage Development Notes
IconAdvantage Server Types
IconIndex Page Size
IconADS.INI File Support
IconRegistry Settings that affect Advantage Communication
IconNull Field Values
IconCollation Support
IconAdvantage Internet Connector
IconAdvantage Linux Development Notes
IconLinux Shared Objects
IconSamba Configuration
IconLock Offset Configuration
IconLinux Rights Checking
IconNFS Mounts
IconLinux Case Sensitivity
IconLog Files
IconLinux 6060 Errors
IconLinux ANSI/OEM Translations
IconAdvantage ISAM Concepts
IconIndexed Sequential Access Method (ISAM) Overview
IconAdvantage ISAM File Types
IconMovement Operations
IconData Update Visibility
IconFilters
IconRelations (Master/Detail Relationships)
IconTypes of Indexes
IconBinary Indexes
IconIndex Scopes (Ranges)
IconTable Sharing Modes
IconISAM Locking
IconAdvantage File Formats
IconAdvantage File Formats Overview
IconXbase Format
IconXbase File Format Specifications
IconAdvantage Proprietary Format
IconAdvantage Proprietary File Format Specifications
IconChoosing a File Format
IconXbase File Format
IconSharing Data with Non-Advantage Applications
IconPrefer to Use the Record Deletion Status as a Filter
IconPrefer Traditional Xbase Unique Index Behavior
IconAdvantage Proprietary File Format
IconLong Field Names and Long Index Names
IconMore Characters in Field Names and Index Names
IconAdditional Field Data Types
IconTrue Unique Indexes for Primary Key Support
IconDeleted Records are Invisible and Automatically Reused
IconFile Size Support Greater Than 4 Gigabytes
IconData Type Independent Expression Concatenation Operator
IconMore Efficient Memo Block Size
IconBetter Performance for Certain Operations
IconMore Suited for Future Enhancements
IconSupport for NULL Values
IconAdvantage SQL
IconAdvantage SQL Engine
IconSQL Debugger
IconSupported SQL Grammar
IconSupported SQL Statements
IconAdvantage SQL Grammar
IconSQL Literals
IconSQL Operators
IconParameters in SQL Statements
IconSQL Statement Limits
IconSupported Data Types in the Advantage SQL Engine
IconSupported Aggregate (column) Functions
IconCASE
IconROWID
IconComments
IconSupported Scalar Functions
IconROWNUM
IconReserved Keywords
IconSQL Performance
IconCursor Types
IconIndexes and SQL Performance
IconLimitations with Static Cursors
IconIndexing the Appropriate Fields
IconLimiting Records Read by the Client
IconReusing Prepared Queries
IconPopulating Static Cursors
IconSmall Result Sets with Large Tables
IconSubqueries
IconSQL Functionality
IconNULL Values
IconAssociating Indexes with Tables
IconUse of Non-Standard Characters in Names
IconUsing Table Names with Paths
IconUsing Tables from Multiple Data Dictionaries
IconJoins Across Servers
IconMemo Field Limitations
IconIndexes with Expressions
IconViews
IconUsing the LIKE Operator
IconHow the Advantage SQL Engine Differs from the BDE
IconProcessing Heuristics
IconIOTA Table
IconUsing Temporary Tables in SQL Statements
IconSQL Execution Plan
IconSQL Query Logging
IconUSER DEFINED FUNCTION
IconSystem Variables
IconExact Numeric vs Approximate Numeric
IconLimiting Query Results
IconFunctions to Convert Hexadecimal Values
IconSystem Views
IconUsing SQL to Retrieve Metadata
IconViews
IconSystem Views
Iconsystem.columns
Iconsystem.ansi_columns
Iconsystem.dictionary
Iconsystem.effectivepermissions
Iconsystem.fts
Iconsystem.functions
Iconsystem.ansi_functions
Iconsystem.indexes
Iconsystem.indexfiles
Iconsystem.links
Iconsystem.objects
Iconsystem.packages
Iconsystem.permissions
Iconsystem.publicationarticles
Iconsystem.ansi_publicationarticles
Iconsystem.publications
Iconsystem.relations
Iconsystem.storedprocedures
Iconsystem.ansi_storedprocedures
Iconsystem.subscriptions
Iconsystem.tables
Iconsystem.ansi_tables
Iconsystem.triggers
Iconsystem.ansi_triggers
Iconsystem.usergroups
Iconsystem.usergroupmembers
Iconsystem.users
Iconsystem.views
Iconsystem.ansi_views
IconSystem Procedures
IconUsing SQL to Modify Data Dictionaries
IconUsing SQL to Access Management Information
IconUsing SQL to Manage Tables
IconMiscellaneous System Procedures
IconProcedures
Iconsp_AddIndexFileToDatabase
Iconsp_AddTableToDatabase
Iconsp_AddUserToGroup
Iconsp_BackupDatabase
Iconsp_BackupFreeTables
Iconsp_CancelQuery
Iconsp_CreateArticle
Iconsp_CreateEvent
Iconsp_CreateGroup
Iconsp_CreateIndex
Iconsp_CreateLink
Iconsp_CreatePublication
Iconsp_CreateReferentialIntegrity
Iconsp_CreateSubscription
Iconsp_CreateUser
Iconsp_DecryptTable
Iconsp_DisableQueryLogging
Iconsp_DisableTriggers
Iconsp_DropAllEvents
Iconsp_DropArticle
Iconsp_DropEvent
Iconsp_DropGroup
Iconsp_DropLink
Iconsp_DropPublication
Iconsp_DropReferentialIntegrity
Iconsp_DropSubscription
Iconsp_DropUser
Iconsp_EnableQueryLogging
Iconsp_EnableTriggers
Iconsp_EncryptTable
Iconsp_GetApplicationID
Iconsp_GetCollations
Iconsp_GetColumns
Iconsp_GetRecordCRC
Iconsp_GetSecurityInfo
Iconsp_GetSQLKeywords
Iconsp_GetSQLStatements
Iconsp_GetTableEncryptionType
Iconsp_GetTables
Iconsp_IgnoreTransactions
Iconsp_ModifyArticleProperty
Iconsp_ModifyDatabase
Iconsp_ModifyFieldProperty
Iconsp_ModifyGroupProperty
Iconsp_ModifyIndexProperty
Iconsp_ModifyLink
Iconsp_ModifyProcedureProperty
Iconsp_ModifyPublicationProperty
Iconsp_ModifySubscriptionProperty
Iconsp_ModifyTableProperty
Iconsp_ModifyUserProperty
Iconsp_ModifyViewProperty
Iconsp_MoveDDObjectFile
Iconsp_PackTable
Iconsp_ProcessReplicationQueues
Iconsp_Reindex
Iconsp_RemoveIndexFile
Iconsp_RemoveUserFromGroup
Iconsp_RenameDDObject
Iconsp_RestoreDatabase
Iconsp_RestoreFreeTables
Iconsp_SetApplicationID
Iconsp_SetDDEncryptionType
Iconsp_SetRequestPriority
Iconsp_SignalEvent
Iconsp_ViewQueryLogging
Iconsp_WaitForAnyEvent
Iconsp_WaitForEvent
Iconsp_ZapTable
Iconsp_mgGetActivityInfo
Iconsp_mgGetAllIndexes
Iconsp_mgGetAllLocks
Iconsp_mgGetAllTables
Iconsp_mgGetCommStats
Iconsp_mgGetConfigInfo
Iconsp_mgGetConfigMemory
Iconsp_mgGetConnectedUsers
Iconsp_mgGetIndexUsers
Iconsp_mgGetInstallInfo
Iconsp_mgGetLockOwner
Iconsp_mgGetServerType
Iconsp_mgGetTableIndexes
Iconsp_mgGetTableUsers
Iconsp_mgGetUsageInfo
Iconsp_mgGetUserIndexes
Iconsp_mgGetUserLocks
Iconsp_mgGetUserTables
Iconsp_mgGetWorkerThreadActivity
Iconsp_mgKillUser
Iconsp_mgResetCommStats
IconSQL PSM (SCRIPT)
IconSQL Script Overview
IconDECLARE
IconAssignment
IconIF
IconWHILE
IconOPEN, CLOSE, FETCH
IconEXECUTE IMMEDIATE
IconTRY ... CATCH ... FINALLY ...
IconRAISE
IconRETURN
IconCACHE
IconParameters
IconUsing SQL Script to Write Stored Procedures
IconDebugging SQL Script
IconDebugging SQL Script Overview
IconSQL Debugging Statements
IconDEBUG BEGIN
IconDEBUG END
IconDEBUG DATABASE
IconDEBUG CONNECTION
IconDEBUG BREAK POINT
IconDEBUG WAIT
IconDEBUG RUN
IconDEBUG BREAK
IconDEBUG REMOVE BREAK POINT
IconSQL Debugging Tables
Icon::DEBUG_CONNECTIONS
Icon::DEBUG_STATEMENTS
Icon::DEBUG_STACK
Icon::DEBUG_BREAKS
Icon::DEBUG_SOURCES
Icon::DEBUG_VARIABLES
IconTech Tips
IconAdvantage Tech Tips
IconBest Practices
IconOnline Backup Permissions
IconSQL
IconTDataSet Descendant (Delphi/C++Builder)
IconVisual Studio
IconVisual FoxPro
IconADO and OLE DB
IconUsing the OLE DB Provider with ADO
IconPerforming Index Operations with OLE DB
IconEnhance Your Advantage ADO Application
IconCrystal Reports
IconNotifications/Events
IconReplication
IconStored Procedures
IconTriggers
IconVisual FoxPro
IconGetting Started with Visual FoxPro
IconRemote Views
IconCursor Adapters
IconSQL Pass Through
IconVisual FoxPro Codepages
IconTroubleshooting and Technical Support
IconTroubleshooting
IconADSSupport Capture Utility
IconAdvantage Troubleshooting Tools
IconNon-Advantage Troubleshooting Tools
IconError and Diagnostic Logs
IconAutomatic Version Checking
IconAvoiding ANSI Collation Mismatch Errors
IconAvoiding OEM Collation Mismatch Errors
Iconwww.AdvantageDatabase.com
IconTroubleshooting in the NetWare Environment
IconTroubleshooting in the Windows Environment
IconTroubleshooting in the Linux Environment
IconInstallation of the Advantage ODBC Driver
IconAdvantage CA-Visual Objects RDD Error Object
IconAdvantage CA-Visual Objects RDD General Protection Faults
IconAdvantage CA-Visual Objects RDD Run Time Problems
IconTroubleshooting Advantage Internet Connections
Iconadsdump Files
IconReplication: Frequently Asked Questions
IconTechnical Support
IconTechnical Support   (U.S. and Canada)
Iconwww.AdvantageDatabase.com
IconNetworking Issues
IconNetworking Protocols Used by the Advantage Database Server
IconAdvantage Database Server Discovery
IconAdvantage Client Communication Layer
IconAdvantage Communication Transport Layer
IconAdvantage Communications Troubleshooting
IconWorkstation Configuration
IconAdvantage Client Engine
IconIntroduction
IconAdvantage Client Engine Architecture
IconSystem Requirements
IconDeveloping Advantage Client Engine Applications
IconFile Requirements
IconSupported File Formats
IconDistributing an Advantage Client Engine-Enabled Application
IconIntegrating the Advantage Client Engine Into Your Application
IconUsing SQL with the Advantage Client Engine
IconCapturing Errors and Error Recovery
IconAPI Reference
IconAPI Conventions
IconDriver Functions
IconTable Functions
IconData Manipulation Functions
IconSQL Functions
IconAdvantage Data Dictionary Functions
IconAdvantage Optimized Filter Functions
IconAdvantage Encryption Functions
IconAdvantage Management API Functions
IconAdvantage Client Engine Transaction Processing APIs
IconExample Code
IconExamples
IconAdvantage Client Engine API TPS Examples
IconAdvantage Local Server Merge Module
IconAdvantage Local Server Merge Module for Developers
IconAdvantage TDataSet Descendant
IconIntroduction and Installation
IconProduct Overview
IconInstalling the Advantage TDataSet Descendant
IconInstalling the Advantage Database Server
IconDeveloping and Distributing Applications
IconDelphi Architecture Overview
IconAdvantage TDataSet Descendant Architecture
IconAdvantage Components for Delphi
IconDifferences Between Advantage and Native Delphi Functionality
IcondbExpress and DataSnap Notes
IconProgrammatically Selecting Advantage Server Types
IconDeveloping a Sample Advantage-Enabled Delphi Application
IconTask 1: Perform Data Conversion Using the Advantage Data Architect
IconTask 2: Create a Simple Browser
IconTask 3: Increase Insert/Edit Functionality
IconTask 4: Add Filter Functionality
IconTask 5: Add Search Functionality
IconTask 6: Add Active Index Selection
IconTask 7: Add Index Creation Capability
IconTask 8: Add Range Functionality
IconTask 9: Add FindKey/FindNearest Functionality
IconBest Advantage Programming Practices
IconOptimizing Performance
IconDatabase Aliases and the ADS.INI File
IconDistributing Advantage TDataSet Descendant Applications
IconHow the Advantage TDataSet Descendant is Built into your Application
IconTransaction Processing with the Advantage TDataSet Descendant
IconAdvantage Components
IconTAdsConnection
IconTAdsTable
IconTAdsQuery
IconTAdsStoredProc
IconTAdsSettings
IconTAdsEvent
IconTAdsEvent Properties
IconTAdsEvent.Active
IconTAdsEvent.AdsConnection
IconTAdsEvent.Events
IconTAdsEvent.EventTimeout
IconTAdsEvent.PollInterval
IconTAdsEvent Events
IconTAdsEvent.OnLog
IconTAdsEvent.OnNotification
IconTAdsBatchMove
IconEADSDatabaseError
IconTAdsBlobStream
IconTAdsStringField
IconTAdsBcdField
IconTAdsAEPSessionMgr
IconTAdsDictionary
IconAdvantage Extended Methods
IconAdvanced Property Editors
IconOverview
IconCreate or Alter Table Editor
IconSQL Property Editor
IconManaging Multiple Versions
IconOverview
IconTDataSet Versions Supported
IconOverview of the Switch Process
IconBackup Functionality
IconCustom TDataSet Versions
IconSilent Mode
IconTroubleshooting
IconConverting Existing Delphi Applications
IconAdvantage Data Architect
IconData Conversion Using Advantage Data Architect
IconConverting Existing Delphi Applications to use the Advantage TDataSet Descendant
IconRecord Locking Modes (pessimistic vs. optimistic)
IconAdding Management Capabilities
IconManagement Capabilities Overview
IconAdvantage Management APIs
IconAdvantage Management API Examples
IconDirectly Accessing the Advantage Client Engine
IconWhen to Make Direct Calls to the Advantage Client Engine
IconHow to Use the Advantage Client Engine
IconUsing the Advantage ODBC Driver with Delphi
IconUsing the Advantage ODBC Driver with Delphi
IconUsing the TDataSet with Lazarus
IconOverview of Lazarus Support
IconGetting Started with the TDataSet Descendant for Lazarus
IconBuilding Triggers and Extended Procedures
IconUsing Lazarus on Linux
IconAdvantage Data Architect
IconAdvantage Data Architect Overview
IconQuick Start
IconRedistributing Advantage Data Architect
IconSource Code
IconTables
IconOpening Tables
IconCreating a New Table
IconTable Browser
IconImporting Data into the Advantage Tables
IconExporting Table Data
IconExporting Advantage Tables to Code
IconSchema Templates
IconDatabases
IconOpening a Database
IconCreating or Modifying a Database
IconDeleting a Database
IconDatabase Aliases
IconDeveloping Databases Using the ER Diagramming Tool
IconRefreshing the Active Database
IconAdding Existing Tables to a Database
IconRemoving Tables from a Database
IconDisabling Database Logins using ARC
IconUsers
IconCreating or Modifying a User
IconSetting User Permissions
IconDeleting a User
IconChanging Password
IconGroups
IconCreating or Modifying a Group
IconAdding/Removing Users to/from a Group
IconSetting Group Permissions
IconDeleting a Group
IconStored Procedures
IconCreating or Modifying a Stored Procedure
IconDeleting a Stored Procedure
IconViews
IconCreating or Modifying a View
IconDeleting a View
IconReferential Integrity (RI) Objects
IconCreating or Modifying an RI Object
IconDeleting an RI Object
IconTriggers
IconCreating or Modifying a Trigger
IconDeleting a Trigger
IconLinks
IconCreating a Dictionary Link
IconUser Defined Functions
IconCreating or Modifying a User Defined Function
IconDeleting a User Defined Function
IconCreating or Modifying a Package
IconDeleting a Package
IconReplication
IconCreating or Modifying a Publication
IconDeleting a Publication
IconCreating or Modifying a Subscription
IconDeleting a Subscription
IconUsing SQL with Advantage Data Architect
IconSQL Utility
IconSQL Link Manager
IconAdvantage Query Builder
IconAdvantage Utilities
IconAdvantage Environment Check Utility
IconField Mapping Utility
IconAdvantage Management Utility
IconOverview
IconViewing Database Activity Information
IconViewing Installation Information
IconViewing Connected Users
IconViewing Open Files
IconViewing Configuration Parameters Affecting Memory
IconViewing Configuration Parameters Not Affecting Memory
IconViewing Communication Statistics
IconViewing Active Queries
IconManually Refreshing the Current View
IconChanging the Refresh Rate
IconSQL Debugger
IconOverview
IconDebugger Menu
IconSetting Breakpoints
IconDebugging a Script
IconDebugging a Database Object
IconDebugging an External Application
IconControlling Script Execution
IconModifying Database Objects in the Editor
IconInspecting Variable Data
IconInspecting the Call Stack
IconChanging Keyboard Shortcuts
IconChanging the Default Window Layout
IconAdvantage Crystal Reports
IconOverview
IconCrystal Reports Overview
IconRequirements
IconRequirements
IconUsing the Advantage Crystal Reports Driver
IconDefining a Database Alias for use with Crystal Reports
IconCreating a New Report
IconCreating a New Report in Crystal 6 and 7
IconCreating a New Report in Crystal 8
IconCreating a New Report in Crystal 9 and newer
IconConverting Existing Reports
IconConverting Existing ODBC Reports in Crystal 6 through 8
IconConverting Existing BDE Reports in Crystal 6 through 8
IconChanging a TCrpe Report Alias at Runtime
IconChanging a TCrpe Report Alias at Runtime
IconProviding an External Advantage Connection Handle
IconProviding an External Advantage Connection Handle to the Advantage Crystal Reports Driver
IconConfiguring Crystal Reports at Runtime
IconConfiguring Crystal Reports at Runtime
IconConfiguration
IconLocking Mode
IconCharacter Type
IconRights Checking Mode
IconShowing Deleted DBF Records
IconServer Type
IconCollation
IconReport Distribution
IconReport Distribution
IconKnown Issues
IconKnown Issues
IconAdvantage Developer's Guide
IconAbout the Authors
IconAcknowledgements
IconIntroduction
IconAbout This Book
IconWho Is This Book For
IconImportant Notes
IconPart I - Advantage and Advantage Data Architect
IconPart I Advantage and the Advantage Data Architect
IconChapter 1 - Introduction
IconIntroduction to Advantage Database Server
IconOverview of Advantage Database Server
IconADS Is High Performance
IconADS Is Low Maintenance
IconADS Is a Remote Database Server
IconAdvantage Database Server Versus Advantage Local Server
IconReducing Network Traffic
IconImproved Performance
IconAvailable Transactions
IconImproved Stability
IconWhen to Use the Advantage Local Server
IconAdvantage Tools
IconThe Advantage Configuration Utility
IconThe AdsStamp Utility
IconAdvantage Data Architect
IconAdvantage ANSI Collation Utility
IconBuilding Database Applications Using Advantage
IconCreating the Database
IconCreating the Client Applications
IconFeatures Added in Advantage 8
IconImpressive Backwards Compatibility
IconUpdated Advantage Data Architect
IconOnline Backup
IconReplication Support
IconEnhanced SQL Scripts
IconQuery Logging
IconUser Defined Functions
IconGeneral Improvements to Advantage SQL
IconEnhanced Security
IconServer-Side Aliases
IconTransaction Savepoints
IconNew Field Types
IconApplication Identification
IconPerformance Improvements
IconEnhanced Support for .NET Development
IconImproved Visual Studio 2005 Integration
IconUpdated Crystal Report Driver
IconTCP/IP Support for All Clients
IconChapter 2 - Creating Tables
IconCreating Tables
IconADS Supported Table Types
IconDBF Formats
IconThe Advantage Proprietary (ADT) Format
IconFree Tables Versus Database Tables
IconCreating ADS Tables
IconWorking with Tables
IconOpening a Previously Created Table
IconNavigating and Editing Data in a Table
IconOther Table Support Features
IconData Security
IconTable Maintenance
IconImporting and Exporting Data
IconExporting Table Structures As Code
IconChapter 3 - Defining Indexes
IconDefining Indexes
IconOverview of Index Files
IconWhy Create Indexes?
IconTypes of Index Orders
IconCreating Indexes
IconTesting Indexes
IconIndexes and Performance
IconHow Many Indexes Should You Define?
IconScopes, Seeks, and AOFs
IconFull Text Search Indexes
IconCreating FTS Index Orders
IconTesting FTS Index Orders
IconOptions for FTS Index Orders
IconChapter 4 - Understanding Dictionaries
IconUnderstanding and Using Data Dictionaries
IconData Dictionary Overview
IconCreating a Data Dictionary
IconAdding Tables to a Data Dictionary
IconOpening a Data Dictionary
IconAdding Existing Tables to a Data Dictionary
IconRemoving a Table from a Data Dictionary
IconData Dictionaries and Table Encryption
IconEnabling Table Encryption
IconEncrypting Database Tables
IconBinding Tables with Table Encryption Enabled
IconImplementing Security with Data Dictionaries
IconDefining Users and Groups
IconAdding Users
IconChecking User Rights
IconUnderstanding Groups
IconUsing Access Rights and Groups
IconChanging Objects and Permissions
IconHow Field-Level Permissions Are Enforced
IconCommunication and Index Encryption
IconInternet Access and Security
IconDictionary Links
IconCreating Dictionary Links
IconThe SQL Link Manager
IconOther Dictionary Operations
IconRenaming and Moving Dictionary Objects
IconComparing Data Dictionaries
IconChapter 5 - Constraints and RI
IconDefining Constraints and Referential Integrity
IconUnderstanding Constraints
IconAlternatives to Constraints
IconAdvantages of Constraints
IconCreating Constraints
IconDefining Field-Level Properties
IconDefining Table-Level Properties
IconDefining Referential Integrity Constraints
IconThe RI Visual Designer
IconComments About Constraints and Referential Integrity
IconUsing Field-Level Constraints
IconUsing Record-Level Constraints
IconUsing Referential Integrity
IconChapter 6 - Views
IconWorking with Views
IconOverview of Views
IconCreating Editable Views
IconTesting a View
IconMaking Views Accessible
IconChanging a View
IconViews That Use Views
IconModularizing Operations with Views
IconViews As Temporary Tables
IconSelecting Record Subsets from Views
IconViews That Use Other Database Tables
IconQualifying a Table Using a Dictionary Path
IconQualifying a Table Using Data Dictionary Links
IconChapter 7 - Stored Procedures
IconCreating Stored Procedures
IconOverview of Stored Procedures
IconStored Procedures Versus Advantage Extended Procedures
IconThe Structure of AEPs
IconThe Structure of SQL Stored Procedures
IconWriting Stored Procedures
IconCreating and Installing SQL Stored Procedures
IconCreating AEPs Using Delphi
IconCreating AEPs Using C# with Visual Studio .NET
IconCreating AEPs Using VB.NET
IconCreating AEPs Using Visual Basic 6
IconUsing Stored Procedures
IconInstalling AEPs
IconTesting AEPs
IconDebugging Stored Procedures
IconDeploying Stored Procedures
IconChapter 8 - Triggers
IconDefining Triggers
IconOverview of Triggers
IconBEFORE Triggers
IconINSTEAD OF Triggers
IconAFTER Triggers
IconON CONFLICT Triggers
IconCreating Triggers
IconTriggers and Transactions
IconTrigger Priority
IconTriggers and Performance
IconGetting Started with Triggers
IconExample Triggers
IconWriting Triggers in SQL
IconCreating Triggers in Delphi
IconCreating Triggers in C# with Visual Studio .NET
IconCreating Triggers in VB.NET with Visual Studio .NET
IconUsing Triggers
IconCreating the Sample Table
IconRegistering Triggers
IconTesting the New Trigger
IconUpdating and Deleting Triggers
IconDebugging Triggers
IconDeploying Triggers
IconDisabling Triggers
IconChapter 9 - Backups
IconBacking Up and Restoring Data
IconWhat Gets Backed Up
IconCreating a Backup
IconCreating a Backup from the Advantage Data Architect
IconCreating a Backup Using System Stored Procedures
IconCreating a Backup Using AdsBackup.exe
IconThe Backup Result Table
IconRestoring from a Backup
IconRestoring Data Using the Advantage Data Architect
IconRestoring Data Using the System Stored Procedures
IconRestoring Data Using the AdsBackup.exe Command-Line Utility
IconChapter 10 - Replication
IconImplementing Replication
IconOverview of Advantage Replication
IconBasic Replication Strategies
IconUnidirectional Replication
IconBi-Directional Replication
IconHub and Spoke Replication
IconConfiguring Replication
IconCreating the Publication
IconCustomizing a Publication
IconCreating the Subscription
IconReplication Example
IconAdditional Replication Issues
IconConfiguring Replication Errors
IconReplication and Triggers
IconReplication and Connections
IconPart II - Advantage SQL
IconAdvantage SQL
IconChapter 11 - Introduction to Advantage SQL
IconIntroduction to Using Advantage SQL
IconOverview of Advantage SQL Queries
IconField Names and Table Names
IconField Aliases and Table Aliases
IconKeywords
IconSQL Literals
IconOperators in SQL Statements
IconSQL Scalar Functions
IconParameters in SQL Statements
IconUser Defined Functions
IconComments
IconSQL Scripts
IconAdditional Advantage SQL Topics
IconSQL Statement Dimensions
IconLive Cursors Versus Static Cursors
IconTemporary Tables
IconUsing Subqueries
IconQuery Tools
IconThe SQL Utility
IconThe Query Builder
IconQuery Logging
IconThe SQL Execution Plan
IconChapter 12 - SQL to Perform Common Tasks
IconUsing SQL to Perform Common Database Operations
IconCreating and Modifying Objects
IconCreating Tables and Indexes
IconSelecting Data
IconSelecting and Expressions
IconConditional Selection
IconSorting Data
IconGrouping Data
IconMultitable Queries
IconFull Text Search Queries
IconChanging Data
IconInserting Records
IconUpdating Records
IconDeleting Records
IconUsing Transactions
IconTransaction Savepoints
IconAutomatic Transactions
IconChapter 13 - SQL Scripting Language
IconThe Advantage SQL Scripting Language
IconWriting SQL Scripts
IconDeclaring Variables
IconAssignment
IconFlow Control
IconUsing Cursors
IconExecuting SQL Without a Cursor
IconException Handling
IconCaching Script Semantics
IconUser Defined Functions
IconUser Defined Functions and Packages
IconCreating a Package
IconCreating a User Defined Function
IconCalling a User Defined Function
IconChapter 14 - System Management and Metadata
IconSystem Management and Metadata
IconSystem Tables
IconGetting Dictionary Information
IconGetting Table-Related Information
IconGetting User and Group Information
IconGetting Other Object Information
IconOther System Tables
IconDictionary-Related SQL Statements
IconCreating a Data Dictionary
IconGranting Rights
IconRevoking Rights
IconSystem Stored Procedures
IconExecuting Stored Procedures
IconUsage Information and Control
IconData Dictionary Management
IconTable Information and Maintenance
IconGeneral Information and Control
IconPart III - Accessing Advantage Data
IconAccessing ADS Data
IconChapter 15 - Using Advantage from Delphi
IconUsing Advantage from Delphi
IconAdvantage and Delphi
IconUnderstanding the TDataSet Descendants
IconPerforming Basic Tasks with Advantage and Delphi
IconConnecting to Data
IconAccessing an ADS Table
IconReading and Writing Data
IconExecuting a Query
IconUsing a Parameterized Query
IconCalling a Stored Procedure
IconNavigational Actions with Advantage and Delphi
IconSetting an Index
IconFinding a Record Based on Data
IconSetting a Range
IconSetting a Filter
IconScanning a Result Set
IconAdministrative Operations with Advantage and Delphi
IconCreating a Table and Granting Rights to It
IconChanging a User Password
IconChapter 16 - Advantage and Java
IconAdvantage and Java
IconADS and Java
IconPerforming Basic Tasks with ADS and Java
IconConnecting to Data
IconExecuting a Query
IconUsing a Parameterized Query
IconReading and Writing Data
IconCalling a Stored Procedure
IconNavigational Actions with ADS and Java
IconScanning a Result Set
IconAdministrative Operations with ADS and Java
IconCreating a Table and Granting Rights to It
IconChanging a User Password
IconChapter 17 - MDAC, OLE DB, ADO
IconMDAC, OLE DB, ADO, Visual Basic, and Advantage
IconMDAC, OLE DB, ADO, Visual Basic, and Advantage
IconPerforming Basic Tasks with Advantage and ADO
IconConnecting to Data
IconExecuting a Query
IconUsing a Parameterized Query
IconReading and Writing Data
IconCalling a Stored Procedure
IconNavigational Actions with Advantage and ADO
IconSetting an Index
IconFinding a Record Based on Data
IconSetting a Filter
IconScanning a Result Set
IconAdministrative Operations with Advantage and ADO
IconCreating a Table and Granting Rights to It
IconChanging a User Password
IconChapter 18 - The .NET Data Provider
IconAdvantage and the Advantage .NET Data Provider
IconAdvantage and ADO.NET
IconMaking ADO.NET Better
IconSuperior ADO.NET 1.1 Support
IconFull ADO.NET 2.0 Support
IconAdvanced Visual Studio 2005 Integration
IconA Note About the Examples
IconPerforming Basic Tasks with ADS and ADO.NET
IconConnecting to Data
IconExecuting a Query
IconUsing a Parameterized Query
IconReading and Writing Data
IconCalling a Stored Procedure
IconNavigational Actions with Advantage and ADO.NET
IconScanning a Result Set
IconAdministrative Operations with ADS and ADO.NET
IconCreating a Table and Granting Rights to It
IconChanging a User Password
IconChapter 19 - ODBC, PHP, DBI/Perl
IconUsing Advantage with ODBC, PHP, and DBI/Perl
IconAccessing Advantage Using the Advantage ODBC Driver
IconWho Should Use the Advantage ODBC Driver
IconConnecting to Advantage Using the Advantage ODBC Driver
IconAccessing Advantage Using the Advantage PHP Extension
IconA Sample PHP Web Site
IconConnecting to Advantage Using PHP
IconUsing Parameterized Queries in PHP
IconGetting Tables from Result Sets Using PHP
IconEditing Data
IconScanning Result Sets
IconCalling a Stored Procedure
IconAccessing Data Using the Advantage DBI Driver (for Perl)
IconAppendixes
IconAppendix A - Installation
IconInstalling Advantage Database Server and the Sample Database and Code
IconDownloading and Installing
IconDatabase and Code Samples
IconDownloading and Installing the Sample Database and Code
IconThis Book's Errata Web Page
IconAppendix B - Troubleshooting and Other Issues
IconTroubleshooting and Other Issues
IconGetting Information About Advantage Error Codes
IconThe Error Table
IconExclusive Locks and Cursor Caching
IconServer-Side Aliases
IconDefining Server-Side Aliases
IconChanging AdsServer.Ini
IconAdvantage .NET Data Provider
IconIntroduction
IconProduct Overview
IconQuick Start
IconSystem Requirements
IconName Space
IconClass Summary
IconReferencing the Advantage .NET Data Provider
IconTransaction Support in the Advantage .NET Data Provider
IconDirect Table Access in ADO.NET
IconImportant Notes
Icon64-bit Notes
IconKnown Problems
IconInstallation and Distribution
IconInstalling the Advantage .NET Data Provider
IconDistributing the Advantage .NET Data Provider
IconRegistering the Advantage .NET Data Provider
IconDeveloping .NET Applications
IconAdvantage .NET Data Provider Data Types
IconAdvantage .NET Data Provider and Multi-Threading
IconAdvantage .NET Data Provider and Connection Pooling
Icon.NET Data Providers and Code Portability
IconEntity Framework Support
IconEntity Framework Support
IconUnsupported Entity Framework Functionality
IconLimitations of the Automated Entity Framework Tools
IconEntity Framework Quick Start
IconEntity Framework Quick Start Overview
IconCreate Sample Database
IconCreate an Entity Model
IconDisplay Records using LINQ
IconAdsCommand Class
IconOverview
IconAdsCommand Constructors
IconOverview
IconAdsCommand Constructor()
IconAdsCommand Constructor( string )
IconAdsCommand Constructor( string, AdsConnection )
IconAdsCommand Constructor( string, AdsConnection, AdsTransaction )
IconAdsCommand Properties
IconOverview
IconAdsCommand.Cancelled
IconAdsCommand.CommandText
IconAdsCommand.CommandTimeout
IconAdsCommand.CommandType
IconAdsCommand.Connection
IconAdsCommand.LastAutoinc
IconAdsCommand.Parameters
IconAdsCommand.Progress
IconAdsCommand.TimedOut
IconAdsCommand.Transaction
IconAdsCommand.UpdatedRowSource
IconAdsCommand Methods
IconOverview
IconAdsCommand.Cancel
IconAdsCommand.CreateParameter
IconAdsCommand.ExecuteExtendedReader
IconAdsCommand.ExecuteExtendedReader( CommandBehavior )
IconAdsCommand.ExecuteNonQuery
IconAdsCommand.ExecuteReader
IconAdsCommand.ExecuteReader( CommandBehavior )
IconAdsCommand.ExecuteScalar
IconAdsCommand.Prepare
IconAdsCommand.DeriveParameters
IconAdsCommand.VerifySQL
IconAdsCommand_Unprepare
IconAdsCommand Events
IconAdsCommand.ProgressMessage
IconAdsCommandBuilder Class
IconOverview
IconAdsCommandBuilder Constructors
IconOverview
IconAdsCommandBuilder Constructor ()
IconAdsCommandBuilder Constructor( AdsDataAdapter )
IconAdsCommandBuilder Properties
IconOverview
IconAdsCommandBuilder.DataAdapter
IconAdsCommandBuilder.QuotePrefix
IconAdsCommandBuilder.QuoteSuffix
IconAdsCommandBuilder.RequirePrimaryKey
IconAdsCommandBuilder.UsePKOnlyInWhereClause
IconAdsCommandBuilder.UseRowversionOnlyInWhereClause
IconAdsCommandBuilder Methods
IconOverview
IconAdsCommandBuilder.DeriveParameters
IconAdsCommandBuilder.GetDeleteCommand
IconAdsCommandBuilder.GetInsertCommand
IconAdsCommandBuilder.GetUpdateCommand
IconAdsCommandBuilder.RefreshSchema
IconAdsConnection Class
IconOverview
IconAdsConnection Constructors
IconOverview
IconAdsConnection Constructor()
IconAdsConnection Constructor( string )
IconAdsConnection Properties
IconOverview
IconAdsConnection.ConnectionHandle
IconAdsConnection.ConnectionString
IconAdsConnection.ConnectionTimeout
IconAdsConnection.Database
IconAdsConnection.DataSource
IconAdsConnection.DateFormat
IconAdsConnection.DDVersionMajor
IconAdsConnection.DDVersionMinor
IconAdsConnection.Epoch
IconAdsConnection.IsConnectionAlive
IconAdsConnection.IsDictionaryConn
IconAdsConnection.ServerName
IconAdsConnection.ServerTime
IconAdsConnection.ServerType
IconAdsConnection.ServerVersion
IconAdsConnection.State
IconAdsConnection Methods
IconOverview
IconAdsConnection.BeginTransaction()
IconAdsConnection.BeginTransaction( IsolationLevel )
IconAdsConnection.ChangeDatabase
IconAdsConnection.Close
IconAdsConnection.CloseCachedTables
IconAdsConnection.CreateCommand
IconAdsConnection.EnlistTransaction
IconAdsConnection.FlushConnectionPool()
IconAdsConnection.FlushConnectionPool( string )
IconAdsConnection.GetDDObjects
IconAdsConnection.GetTableNames
IconAdsConnection.Open
IconAdsConnection.SetCursorCache
IconAdsConnection.SetTableCache
IconAdsConnection Enumerations
IconOverview
IconAdsConnection.AdsObjectType
IconAdsConnection Events
IconOverview
IconAdsConnection.InfoMessage
IconAdsConnection.StateChange
IconAdsConnectionStringBuilder Class
IconOverview
IconAdsConnectionStringBuilder Constructors
IconOverview
IconAdsConnectionStringBuilder Constructor()
IconAdsConnectionStringBuilder Constructor ( string )
IconAdsConnectionStringBuilder Properties
IconOverview
IconAdsConnectionStringBuilder.ConnectionString
IconAdsConnectionStringBuilder Data Source Properties
IconAdsConnectionStringBuilder Methods
IconOverview
IconAdsConnectionStringBuilder.Clear
IconAdsConnectionStringBuilder.Remove
IconAdsDataAdapter Class
IconOverview
IconAdsDataAdapter Constructors
IconOverview
IconAdsDataAdapter Constructor()
IconAdsDataAdapter Constructor( AdsCommand )
IconAdsDataAdapter Constructor( String, AdsConnection )
IconAdsDataAdapter Constructor( String, String )
IconAdsDataAdapter Properties
IconOverview
IconAdsDataAdapter.DeleteCommand
IconAdsDataAdapter.InsertCommand
IconAdsDataAdapter.MissingMappingAction
IconAdsDataAdapter.MissingSchemaAction
IconAdsDataAdapter.SelectCommand
IconAdsDataAdapter.UpdateCommand
IconAdsDataAdapter.TableMappings
IconAdsDataAdapter Methods
IconOverview
IconAdsDataAdapter.CreateRowUpdatedEvent
IconAdsDataAdapter.CreateRowUpdatingEvent
IconAdsDataAdapter.Fill
IconAdsDataAdapter.FillSchema
IconAdsDataAdapter.GetFillParameters
IconAdsDataAdapter.OnFillError
IconAdsDataAdapter.OnRowUpdated
IconAdsDataAdapter.OnRowUpdating
IconAdsDataAdapter.Update
IconAdsDataAdapter Events
IconOverview
IconAdsDataAdapter.FillError
IconAdsDataReader Class
IconOverview
IconAdsDataReader Properties
IconOverview
IconAdsDataReader.Depth
IconAdsDataReader.FieldCount
IconAdsDataReader.HasRows
IconAdsDataReader.IsClosed
IconAdsDataReader.IsStatic
IconAdsDataReader.Item
IconAdsDataReader.RecordsAffected
IconAdsDataReader.RecordCache
IconAdsDataReader Methods
IconOverview
IconAdsDataReader.Close
IconAdsDataReader.GetBoolean
IconAdsDataReader.GetByte
IconAdsDataReader.GetBytes()
IconAdsDataReader.GetBytes(int, long, byte[], int, int)
IconAdsDataReader.GetChar
IconAdsDataReader.GetChars
IconAdsDataReader.GetData
IconAdsDataReader.GetDataTypeName
IconAdsDataReader.GetDateTime
IconAdsDataReader.GetDecimal
IconAdsDataReader.GetDouble
IconAdsDataReader.GetFieldType
IconAdsDataReader.GetFloat
IconAdsDataReader.GetGuid
IconAdsDataReader.GetInt16
IconAdsDataReader.GetInt32
IconAdsDataReader.GetInt64
IconAdsDataReader.GetName
IconAdsDataReader.GetOrdinal
IconAdsDataReader.GetSchemaTable
IconAdsDataReader.GetString
IconAdsDataReader.GetTimeSpan
IconAdsDataReader.GetValue
IconAdsDataReader.GetValues
IconAdsDataReader.IsDBNull
IconAdsDataReader.NextResult
IconAdsDataReader.Read
IconAdsException Class
IconOverview
IconAdsException Properties
IconOverview
IconAdsException.Message
IconAdsException.Number
IconAdsException.State
IconAdsExtendedReader Class
IconOverview
IconAdsExtendedReader Properties
IconOverview
IconAdsExtendedReader.ActiveIndex
IconAdsExtendedReader.AdsActiveHandle
IconAdsExtendedReader.AdsHandle
IconAdsExtendedReader.BOF
IconAdsExtendedReader.EncryptionPassword
IconAdsExtendedReader.EOF
IconAdsExtendedReader.Filter
IconAdsExtendedReader.IndexCondition
IconAdsExtendedReader.IndexExpression
IconAdsExtendedReader.IsIndexCompound
IconAdsExtendedReader.IsIndexCustom
IconAdsExtendedReader.IsIndexDescending
IconAdsExtendedReader.IsIndexPrimaryKey
IconAdsExtendedReader.IsIndexUnique
IconAdsExtendedReader.Item
IconAdsExtendedReader.LastAutoinc
IconAdsExtendedReader.LogicalRecordNumber
IconAdsExtendedReader.PartialMatch
IconAdsExtendedReader.Progress
IconAdsExtendedReader.RecordNumber
IconAdsExtendedReader.RelativeKeyPosition
IconAdsExtendedReader Methods
IconOverview
IconAdsExtendedReader.AppendRecord
IconAdsExtendedReader.Cancel
IconAdsExtendedReader.ClearRange
IconAdsExtendedReader.CompareBookmarks
IconAdsExtendedReader.ConvertTable
IconAdsExtendedReader.CopyTable
IconAdsExtendedReader.CopyTableStructure
IconAdsExtendedReader.CreateIndex
IconAdsExtendedReader.DecryptTable
IconAdsExtendedReader.DeleteIndex
IconAdsExtendedReader.DeleteRecord
IconAdsExtendedReader.EncryptTable
IconAdsExtendedReader.GetBookmark
IconAdsExtendedReader.GetIndexNames
IconAdsExtendedReader.GetRecordCount
IconAdsExtendedReader.GotoBOF
IconAdsExtendedReader.GotoBookmark
IconAdsExtendedReader.GotoBottom
IconAdsExtendedReader.GotoTop
IconAdsExtendedReader.IsRecordDeleted
IconAdsExtendedReader.IsRecordLocked
IconAdsExtendedReader.IsTableLocked
IconAdsExtendedReader.LockRecord
IconAdsExtendedReader.LockTable
IconAdsExtendedReader.OpenIndex
IconAdsExtendedReader.PackTable
IconAdsExtendedReader.ReadPrevious
IconAdsExtendedReader.RecallAllRecords
IconAdsExtendedReader.RecallRecord
IconAdsExtendedReader.Reindex
IconAdsExtendedReader.Seek
IconAdsExtendedReader.SetBoolean
IconAdsExtendedReader.SetByte
IconAdsExtendedReader.SetBytes
IconAdsExtendedReader.SetChars
IconAdsExtendedReader.SetDateTime
IconAdsExtendedReader.SetDecimal
IconAdsExtendedReader.SetDouble
IconAdsExtendedReader.SetFloat
IconAdsExtendedReader.SetInt16
IconAdsExtendedReader.SetInt32
IconAdsExtendedReader.SetInt64
IconAdsExtendedReader.SetRange
IconAdsExtendedReader.SetString
IconAdsExtendedReader.SetTimeSpan
IconAdsExtendedReader.SetValue
IconAdsExtendedReader.UnlockRecord
IconAdsExtendedReader.UnlockTable
IconAdsExtendedReader.WriteRecord
IconAdsExtendedReader.ZapTable
IconAdsExtendedReader Enumerations
IconOverview
IconAdsExtendedReader.FilterOption
IconAdsExtendedReader.IndexOptions
IconAdsExtendedReader.SeekType
IconAdsExtendedReader.TableType
IconAdsExtendedReader Events
IconOverview
IconAdsExtendedReader.ProgressMessage
IconAdsFactory Class
IconOverview
IconAdsFactory Fields
IconOverview
IconAdsFactory.Instance
IconAdsFactory Methods
IconOverview
IconAdsFactory.CreateCommand
IconAdsFactory.CreateCommandBuilder
IconAdsFactory.CreateConnection
IconAdsFactory.CreateConnectionStringBuilder
IconAdsFactory.CreateDataAdapter
IconAdsFactory.CreateParameter
IconAdsParameter Class
IconOverview
IconAdsParameter Constructors
IconOverview
IconAdsParameter Constructor ()
IconAdsParameter Constructor ( int, object )
IconAdsParameter Constructor ( string, DbType )
IconAdsParameter Constructor ( string, DbType, int )
IconAdsParameter Constructor ( string, DbType, int, ParameterDirection, Boolean, Byte, Byte, st
IconAdsParameter Constructor ( string, DbType, int, string )
IconAdsParameter Constructor ( string, DbType, string, DataRowVersion )
IconAdsParameter Constructor ( string, object )
IconAdsParameter Properties
IconOverview
IconAdsParameter.DbType
IconAdsParameter.Direction
IconAdsParameter.Index
IconAdsParameter.IsNull
IconAdsParameter.IsNullable
IconAdsParameter.ParameterName
IconAdsParameter.Precision
IconAdsParameter.Scale
IconAdsParameter.Size
IconAdsParameter.SourceColumn
IconAdsParameter.SourceVersion
IconAdsParameter.Value
IconAdsParameterCollection Class
IconOverview
IconAdsParameterCollection Properties
IconOverview
IconAdsParameterCollection.Count
IconAdsParameterCollection.Item ( int )
IconAdsParameterCollection.Item ( string )
IconAdsParameterCollection Methods
IconOverview
IconAdsParameterCollection.Add( object )
IconAdsParameterCollection.Add( AdsParameter )
IconAdsParameterCollection.Add( string, DbType )
IconAdsParameterCollection.Add( string, object )
IconAdsParameterCollection.Add( string, DbType, int, string )
IconAdsParameterCollection.Add( int, object )
IconAdsParameterCollection.Clear
IconAdsParameterCollection.Contains
IconAdsParameterCollection.IndexOf
IconAdsParameterCollection.RemoveAt( int )
IconAdsParameterCollection.RemoveAt( string )
IconAdsTransaction Class
IconOverview
IconAdsTransaction Properties
IconOverview
IconAdsTransaction.Connection
IconAdsTransaction.IsolationLevel
IconAdsTransaction Methods
IconOverview
IconAdsTransaction.Commit
IconAdsTransaction.CreateSavepoint
IconAdsTransaction.Rollback
IconAdsInfoMessageEventArgs Class
IconOverview
IconAdsInfoMessageEventArgs Properties
IconOverview
IconAdsInfoMessageEventArgs.Message
IconAdsInfoMessageEventArgs.Number
IconAdvantage Error Guide
IconAdvantage Error Codes
Icon1xxx Errors
IconAdvantage 1xxx Error Codes
Icon15xx Errors
IconAdvantage 15xx Error Codes
Icon2xxx Errors
IconAdvantage 2xxx Error Codes
Icon3xxx Errors
IconAdvantage 30xx Error Codes
IconAdvantage 31xx Error Codes
IconAdvantage 32xx Error Codes
IconAdvantage 33xx Error Codes
IconAdvantage 34xx Error Codes
IconAdvantage 35xx Error Codes
Icon4xxx Errors
IconAdvantage 4xxx Error Codes
Icon5xxx Errors
IconAdvantage 5xxx Error Codes
Icon6xxx Errors
IconAdvantage 60xx Error Codes
IconAdvantage 61xx Error Codes
IconAdvantage 62xx Error Codes
IconAdvantage 63xx Error Codes
IconAdvantage 64xx Error Codes
IconAdvantage 66xx Error Codes
IconAdvantage 67xx Error Codes
IconAdvantage 68xx Error Codes
Icon7xxx Errors
IconAdvantage 7xxx Error Codes
Icon8xxx Errors
IconAdvantage 8xxx Error Codes
Icon9xxx Errors
IconAdvantage 9xxx Error Codes
IconWindows Server OS Errors
IconWindows Server OS Errors
IconNetWare Server OS Errors
IconNetWare Server OS Errors
IconOpenSSL Errors
IconSSL Errors
IconX509 Certificate Errors
IconAdvantage JDBC Driver
IconQuick Start Guide Overview
IconConnecting to a Database
IconSetting the Classpath
IconRegistering the Driver
IconPassing the Connection URL
IconAbout the JDBC Driver
IconAdvantage JDBC Driver
IconConnecting Through the JDBC Driver Manager
IconConnection String Properties
IconError Handling
IconAdvantage JDBC Driver Directory Structure
IconData Types
IconResult Sets
IconSupported Functionality
IconCallableStatement Object
IconConnection Object
IconDatabaseMetaData Object
IconDriver Object
IconPreparedStatement Object
IconResultSet Object
IconResultSetMetaData Object
IconStatement Object
IconAdditional methods available to the ADSStatement object
IconTransaction Processing in JDBC
IconUnsupported Functionality
IconUnsupported Functionality
IconAdvantage ODBC Driver
IconIntroduction
IconProduct Overview
IconImportant Notes
IconTroubleshooting
IconInstallation and Distribution
IconData Source Setup for Windows
IconData Source Setup for Linux
IconODBC Data Source Entries for Windows
IconODBC Data Source Entries for Linux
IconODBC Data Source Keys
IconDistributing Advantage ODBC Applications
IconUsing the Advantage ODBC Driver with SQL
IconAdvantage ODBC Driver with SQL
IconDatabase Directory
IconIndex Types
IconLocking
IconDeleted Records
IconCharacter Sets
IconDriver Boundaries
IconIndex Optimizations
IconODBC Driver SQL Grammar
IconAPI Special Characteristics
IconData Type Mapping
IconODBC API Conformance
IconAdvantage OLE DB Provider (for ADO)
IconIntroduction
IconProduct Overview
IconSystem Requirements
IconInstallation and Distribution
IconInstalling the Advantage OLE DB Provider
IconDistributing the Advantage OLE DB Provider
IconAdvantage Data Architect Utility
IconInstalling the Advantage Database Server
IconUsing the Advantage OLE DB Provider with ADO
IconOverview of Advantage OLE DB Provider with ADO
IconConnection String Parameters (Advantage OLE DB Provider)
IconConnection Object Information
IconProvider-Specific Connection Properties for ADO
IconRecordset Object Information
IconProvider-Specific Recordset Properties for ADO
IconCommand Object Information
IconProgrammatically Selecting Advantage Server Types
IconSetting the Date Format
IconLow Level OLE DB Information
IconData Source Objects
IconData Source Objects Overview
IconSupported Data Source Object Interfaces
IconData Source Properties
IconData Source Information Properties
IconProvider-Specific Data Source Information Properties
IconInitialization Properties (Advantage OLE DB Provider)
IconProvider-Specific Initialization Properties
IconProvider-Specific Initialization Properties for ADO
IconSessions
IconSessions Overview
IconSupported Session Object Interfaces
IconSession Properties
IconProvider-Specific Session Properties
IconRowsets
IconRowsets Overview
IconCreating a Rowset with IOpenRowset
IconCreating Rowsets with ICommand::Execute
IconSupported Rowset Object Interfaces
IconRowset Properties
IconProvider-Specific Rowset Properties
IconRecord Caching
IconUpdating Data in Rowsets
IconBookmarks
IconIndexes
IconViews (OLE DB)
IconViews Overview
IconView Properties
IconSupported View Object Interfaces
IconCommands
IconCommands Overview
IconSupported Command Object Interfaces
IconCommand Syntax
IconCommand Parameters
IconPreparing Commands
IconBLOBs and Storage Objects
IconStorage Objects Overview
IconSupported Storage Object Interfaces
IconData Types
IconData Types Overview
IconData Type Mapping in Rowsets and Parameters
IconTransactions
IconSupporting Local Transactions
IconErrors
IconErrors Overview
IconError Object Interfaces Supported
IconReturn Codes
IconSchema Rowsets
IconSchema Rowsets Overview
IconSchema Rowset Support in the Advantage OLE DB Provider
IconUnsupported Functionality
IconSummary of Unsupported Functionality
IconAdvantage PHP Extension
IconProduct Overview
IconImportant Notes
IconLinux Installation Notes
IconWindows Installation Notes
IconWorking with Unicode
IconExtension Functions
IconExtension Functions
Iconads_autocommit
Iconads_close
Iconads_close_all
Iconads_commit
Iconads_connect
Iconads_cursor
Iconads_do
Iconads_error
Iconads_errormsg
Iconads_exec
Iconads_execute
Iconads_fetch_array
Iconads_fetch_into
Iconads_fetch_row
Iconads_field_len
Iconads_field_name
Iconads_field_num
Iconads_field_precision
Iconads_field_scale
Iconads_field_type
Iconads_free_result
Iconads_longreadlen
Iconads_num_fields
Iconads_num_rows
Iconads_pconnect
Iconads_prepare
Iconads_result
Iconads_result_all
Iconads_rollback
IconAdvantage Visual Objects and Vulcan.NET RDD
IconIntroduction
IconProduct Overview
IconFile Requirements
IconInstalling the Optional Advantage Extended Libraries
IconDistributing Advantage Visual Objects and Vulcan.NET Applications
IconDeveloping Visual Objects and Vulcan.NET Applications
IconAdvantage RDDs
IconCreating your Application with the Advantage Libraries
IconUsing RDDSetDefault to Specify the Advantage RDD
IconTransaction Processing with Advantage Visual Objects and Vulcan.NET
IconConnecting to an Advantage Data Dictionary with Visual Objects and Vulcan.NET
IconUsing the Advantage Local Server
IconUsing the Advantage SQL Engine
IconApplication Development Notes (for Visual Objects and Vulcan.NET)
IconUpdating the Advantage RDD for Vulcan.NET (AdvantageRDD.dll)
IconAdvanced  Functions
IconOverview
IconBLOB Functions
IconAX_AXSLocking()
IconAX_BLOB2File()
IconAX_File2BLOB()
IconAX_GetAceIndexHandle()
IconAX_GetAceTableHandle()
IconAX_GetAceStmtHandle()
IconAX_IsServerLoaded()
IconAX_PercentIndexed()
IconAX_RightsCheck()
IconAX_SetCollation()
IconAX_SetConnectionHandle()
IconAX_SetExactKeyPos()
IconAX_SetPassword()
IconAX_SetServerType()
IconAX_SetSQLTablePasswords()
IconAX_SetSQLTimeout()
IconAX_Transaction()
IconAX_UsingClientServer()
IconDirectly Accessing the Advantage Client Engine
IconWhen to Make Direct Calls to the Advantage Client Engine
IconHow to use the Advantage Client Engine
IconUsing the Advantage AXSQL RDDs
IconIntroduction
IconUnsupported Functionality
IconThe AdsSQLServer Class
IconAXSQL Requirements
IconStatic vs. Live Cursors
IconAXSQLNTX and Index Optimization
IconAXSQL Refresh Functionality
IconAX_GetAceTableHandle and AX_GetAceIndexHandle
IconAdvantage with R&R ReportWorks
IconIntroduction
IconUsage and Settings
IconAdvantage Web Development
IconPython
IconAdvantage Python Driver
IconDjango
IconAdvantage Django Backend

© 2011 Sybase iAnywhere