1 The AVS/Express Database Kit 1.1 Introduction 3-2 1.2 The Design of the Database Kit 3-3 The Database Library 3-5 The Database-Independent Layer 3-8 The Database-Specific Modules 3-8 1.3 Using Modules and Macros in AVS/Express Applications 3-9 1.4 Constructing SQL Statements 3-10 1.5 Connecting and Disconnecting 3-12 The Connect/Disconnect Operation 3-12 Specifying Input Values 3-12 Environment Variables 3-14 Connect Strings 3-14 1.6 Querying a Database 3-16 Steps in Querying a Database 3-16 Data Rows and Data Columns 3-17 The Query Operation 3-18 Programming Considerations 3-18 1.7 MS Developer Studio Integration 3-41 1.8 Normalization on Only Visible Object 3-41 1.9 Modifying Row Data in a Table 3-42 Steps in Modifying Row Data in a Table 3-42 Programming Considerations 3-43 1.10 Performing Miscellaneous SQL Operations 3-45 Steps in Performing a Miscellaneous Operation 3-45 Programming Considerations 3-45 1.11 Ending Transactions 3-47 Programming Considerations 3-47 1.12 Performing Support Operations 3-49 Constructing SQL Statements 3-49 Displaying and Saving Query Output 3-50 Programming Considerations 3-50 1.13 Handling Errors 3-52 Database Kit Messages and Codes 3-52 SQL Messages and Codes 3-53 Error-Offset Information 3-54 2 Using the Database Kit Macro Interfaces 2.1 Using the Connect Interface 4-2 Connecting to a Database 4-2 The Connect Interface 4-3 Menus 4-4 Input Fields 4-5 Output Fields 4-6 2.2 Using the Query Interface 4-8 Querying a Database 4-8 The Query Interface 4-11 The Statement Window and the Clear Button 4-12 Menus 4-13 Tools 4-15 Output Fields 4-17 Query Components: Quick Reference 4-18 2.3 Using the Manipulate Interface 4-21 Performing an SQL Operation 4-21 The Manipulate Interface 4-22 The Statement Window and the Clear Button 4-23 Menus 4-24 Tools 4-26 Output Fields 4-27 Manipulate Components: Quick Reference 4-28 2.4 Using the Secondary Windows 4-30 The Query Control Window 4-30 The Query Output Types Window 4-34 The Query Statistics Window 4-36 The Output Window 4-38 The Connection Information Window 4-40 The List Windows 4-41 The Error Window 4-42 2.5 Using the Tools Interface 4-44 3 Database-Specific Usage 3.1 Oracle-Specific Usage Notes 5-2 Local and Remote Oracle Connects 5-2 Supplying Connection Information 5-2 Mapping Oracle Datatypes to Database Kit Datatypes 5-4 Fetch-Processing Buffer Contents 5-5 Building the Oracle Database-Specific Module 5-5 3.2 Open Database Connectivity-specific Usage Notes 5-7 ODBC Libraries 5-7 Connecting to ODBC Compliant Server 5-7 Mapping ODBC Datatypes to Database Kit Datatypes 5-8 4 Database Kit Messages and Codes 4.1 Introduction 6-2 4.2 Message and Code Descriptions 6-3 Connected 6-3 DB ERROR: A fatal database error has occurred in the server 6-3 DB ERROR: Cannot allocate memory for connection descriptor 6-4 DB ERROR: Functionality not present 6-4 DB ERROR: Insufficient memory for request 6-5 DB ERROR: Invalid request 6-5 DB ERROR: Invalid statement 6-6 DB ERROR: Recoverable database error 6-7 Disconnected 6-7 5 Tutorial:Using the Database Kit 5.1 Start AVS/Express 7-2 5.2 Connect to Your Database 7-4 5.3 Set up the Sample Database Table 7-6 5.4 Extract the Data from the SALES1 Database Table 7-8 5.5 Bring the Data into the 3D Viewer 7-11 5.6 Clean Up 7-13
Copyright © 2001 Advanced Visual Systems Inc. All rights reserved.
