Chapter 4: Using the Database Classes

• 4.1 Introduction
• 4.2 Getting Connected
• 4.3 Managing Connections
• 4.3.1 RWDBDatabase and RWDBConnection
• 4.3.2 Explicit and Implicit Connections
• 4.3.3 Connection Pools
• 4.3.4 Alternatives for Managing Connections
• 4.3.5 Transaction Processing with RWDBConnection
• 4.3.6 Transaction Control and Locking
• 4.4 Tables
• 4.4.1 Database Tables
• 4.4.2 Reading Tables: Class RWDBReader
• 4.4.3 Memory Tables
• 4.4.4 Result Tables
• 4.4.5 Summary
• 4.5 Expressions, Criterions, and Assignments
• 4.6 Selecting Data
• 4.6.1 Selecting Data from a Single Table
• 4.6.2 Joins
• 4.6.3 Outer Joins
• 4.6.4 Ordering and Grouping
• 4.6.5 Aggregates, Expressions, and Functions
• 4.6.6 Self-Joins
• 4.6.7 Subqueries
• 4.6.8 Summary
• 4.7 Inserting Data
• 4.7.1 Inserting Values
• 4.7.2 Inserting with a Selector
• 4.7.3 Inserting with a Reader
• 4.7.4 Getting Results from an Inserter
• 4.7.5 A Note About Connections
• 4.7.6 Summary
• 4.8 Updating Data
• 4.9 Deleting Data
• 4.10 Stored Procedures
• 4.11 Cursors
• 4.12 Summary

©Copyright 2000, Rogue Wave Software, Inc.
Contact Rogue Wave about documentation or support issues.