DB Interface Module User's Guide
Topic Index
Click on one of the letters below to jump immediately to that section of the index.
A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | R | S | T | U | V | W
access libraries [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
[in 4.2 Getting a Connection]
and asynchronous behavior [in 12.7 Asynchronous Calls in the DB Interface Module]
access module [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
access modules [in 2.1 Basic Architecture]
adding constraints [in 4.5.4.2 Adding or Dropping Constraints]
aggregate functions [in 5.3.6 Aggregates, Expressions, and Functions]
alternatives
for connection management [in 4.3.4 Alternatives for Managing Connections]
architecture [in 1.2 Features and Benefits]
assignments [in 5.5 Updating Data]
[in 5.2 Expressions, Criterions, and Assignments]
asString() method
example [in 5.9 asString() Methods in the Data Manipulation Classes]
in data manipulation classes [in 5.9 asString() Methods in the Data Manipulation Classes]
output [in 5.9 asString() Methods in the Data Manipulation Classes]
asynchronous API [in 12.1 Definition]
connections [in 12.2 Architectural Overview]
example [in 12.5 Asynchronous Usage Example]
functions [in 12.7 Asynchronous Calls in the DB Interface Module]
processing [in 12.1 Definition]
asynchronous calls
completions [in 12.3 Handling Asynchronous Call Completions]
many on a single connection [in 12.7.1 Running Many Asynchronous Calls on a Single RWDBConnection]
performance issues [in 12.7.2 Performance Issues]
restrictions [in 12.7 Asynchronous Calls in the DB Interface Module]
with C++ datatype returns [in 12.6 Handling C++ Datatype Returns from an Asynchronous Call]
asynchronous readers [in 12.8 Asynchronous RWDBReaders]
auto-generate
and identity column constraint [in 4.5.2.3 Identity Column Constraints]
autocommit mode [in 4.3.5 Transaction Processing with RWDBConnection]
bulk reads and writes [in 8.1 The Bulk Classes]
cache manager
how to use [in 9.4.2 Using the Cache Manager]
lifetime requirement [in 9.4.2 Using the Cache Manager]
multithreading [in 9.4.2 Using the Cache Manager]
caching options
RWDBInserter [in 9.3.1 Caching with RWDBInserter]
RWDBReader [in 9.3.2 Caching with RWDBReader]
caching
cache manager example [in 9.4.7 Example]
classes involved in DB metadata caching [in 9.4 Metadata Caching and the Cache Manager]
clearing the in-memory cache [in 9.4.5 The In-Memory Cache Manager]
database insertion and retrieval [in 9.1 Caching and Performance]
[in 9.2 A Database Client Perspective]
database performance implications [in 9.1 Caching and Performance]
error handling [in 9.4.3 Error Handling in the Cache Manager]
how metadata caching works [in 9.4.1 Types of Cacheable Data]
implementing a cache manager [in 9.4.6 Implementing a Cache Manager]
in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
keeping cache data current [in 9.4.4 Keeping the Cache Up-To-Date]
lifetime requirement for cache manager [in 9.4.2 Using the Cache Manager]
local vs global metadata cache [in 9.4 Metadata Caching and the Cache Manager]
metadata caching in the database client [in 9.2 A Database Client Perspective]
metadata in DB [in 9.1 Caching and Performance]
multithreading and the cache manager [in 9.4.2 Using the Cache Manager]
persisting the in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
restrictions on database insertion and retrieval [in 9.3.3 Restrictions On Caching with RWDBReader, RWDBInserter]
result schemas [in 9.3.4 Result Schema Caching]
RWDBEnvironmentHandle [in 9.3.4 Result Schema Caching]
using the cache manager [in 9.4.2 Using the Cache Manager]
cascade
referential action [in 4.5.3.2 Foreign Key Constraints]
[in 4.5.4.1.2 Creating a Foreign Key Constraint]
CHAR [in 13.2 Character Sets]
character sets
compatibility between [in 13.2.1 National Character Sets and C++ Data Types]
for internationalization [in 13.2.1 National Character Sets and C++ Data Types]
character string data
and RWBasicUString [in 13.2.1 National Character Sets and C++ Data Types]
and RWCString [in 13.2.1 National Character Sets and C++ Data Types]
and RWDBMBString [in 13.2.1 National Character Sets and C++ Data Types]
and RWWString [in 13.2.1 National Character Sets and C++ Data Types]
check conditions
and RWExpr [in 4.5.4.1.3 Creating Unique and Check Constraints]
using RWDBCriterion [in 5.2.1 RWDBCriterion]
check constraints [in 4.5.3.4 Check Table Constraints]
and check condition [in 4.5.4.1.3 Creating Unique and Check Constraints]
[in 5.2.1 RWDBCriterion]
example [in 4.5.4.1.3 Creating Unique and Check Constraints]
fetching [in 4.5.4.3.3 Unique and Check Constraints]
classes
by category [in 3.1 Kinds of Classes]
concrete [in 2.4 Reference Semantics]
data types [in 3.1.1 Datatype Classes]
database [in 3.1.2 Database Classes]
expression [in 3.1.4 Expression Classes]
summary of [in 3.2 Summary of Classes]
tracing [in 3.1.7 Utility and Diagnostics Classes]
[in 3.1.7 Utility and Diagnostics Classes]
without status [in 6.2 Checking Status with Class RWDBStatus]
clearCache() method [in 9.4.4 Keeping the Cache Up-To-Date]
column constraints
cacheable as metadata [in 9.4.1 Types of Cacheable Data]
default [in 4.5.2.2 Default Column Constraints]
identity column [in 4.5.2.3 Identity Column Constraints]
not null [in 4.5.2.1 Not Null Constraints]
types supported [in 4.5.2 Column Level Constraints]
complex queries [in 5.3.5 Ordering and Grouping]
concrete data types [in 2.4 Reference Semantics]
connection management
alternatives [in 4.3.4 Alternatives for Managing Connections]
connection pools [in 4.3.3 Connection Pools]
explicit and implicit connections [in 4.3.2 Explicit and Implicit Connections]
RWDBDatabase and RWDBConnection [in 4.3.1 RWDBDatabase and RWDBConnection]
the process [in 4.3.1 RWDBDatabase and RWDBConnection]
transaction processing [in 4.3.5 Transaction Processing with RWDBConnection]
connection parameters
access library name [in 4.2 Getting a Connection]
database name [in 4.2 Getting a Connection]
password [in 4.2 Getting a Connection]
server name [in 4.2 Getting a Connection]
user name [in 4.2 Getting a Connection]
connection pools
changing pool size [in 4.3.3 Connection Pools]
defined [in 4.3.3 Connection Pools]
connections
and RWDBManager [in 4.2 Getting a Connection]
asynchronous [in 12.2 Architectural Overview]
disabling implicit [in 4.3.3 Connection Pools]
establishing [in 20.5.1 The Main Routine]
explicit [in 5.5 Updating Data]
[in 4.3.2 Explicit and Implicit Connections]
[in 5.4.5 A Note About Connections]
implicit [in 4.3.2 Explicit and Implicit Connections]
logging on [in 4.2 Getting a Connection]
managing [in 4.3 Managing Connections]
shared [in 11.4 Sharing an RWDBConnection]
synchronous [in 12.2 Architectural Overview]
constraints
adding [in 4.5.4.2 Adding or Dropping Constraints]
architecture of classes [in 4.5.1 Table Constraints Classes]
check [in 4.5.3.4 Check Table Constraints]
dropping [in 4.5.4.2 Adding or Dropping Constraints]
fetching [in 4.5.4.3 Fetching Table Constraints]
foreign key [in 4.5.3.2 Foreign Key Constraints]
identity column [in 4.5.2.3 Identity Column Constraints]
on tables [in 4.5.3 Table Level Constraints]
primary key [in 4.5.3.1 Primary Key Constraints]
table [in 4.5 Table Constraints]
unique [in 4.5.3.3 Unique Table Constraints]
constructing
a complex criterion [in 5.2.1 RWDBCriterion]
a complex RWDBCriterion [in 5.2.2 RWDBCriterion and RWDBExpr]
a query [in 5.2.1 RWDBCriterion]
RWDBCursors [in 5.8.1 Instantiating an RWDBCursor]
copy on write [in 2.4 Reference Semantics]
core library [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
correlated subquery [in 5.3.8 Subqueries]
criterions [in 5.2 Expressions, Criterions, and Assignments]
cursors [in 5.8 Cursors]
alternative access attributes [in 5.8.1 Instantiating an RWDBCursor]
binding variables [in 5.8.2 Bind Operations]
binding variables out of order [in 5.8.2 Bind Operations]
deleting rows [in 5.8.5 Delete Operation]
fetching rows [in 5.8.3 Fetch Operation]
updating rows [in 5.8.6 Update Operation]
wide variation [in 5.8 Cursors]
Data Definition Language
and internationalization [in 13.2.6 Data Definition Language]
data formatting [in 13.3 Data Formatting]
data model
architecture [in 7.2 The SourcePro DB Solution]
database layer [in 7.2 The SourcePro DB Solution]
[in 7.3 The Database Layer]
layers [in 7.2 The SourcePro DB Solution]
pointer layer [in 7.5 The Pointer Layer]
[in 7.2 The SourcePro DB Solution]
summary [in 7.6 Summary]
value layer [in 7.2 The SourcePro DB Solution]
[in 7.4 The Value Layer]
data types
binary large objects [in 3.1.1 Datatype Classes]
character data [in 3.1.1 Datatype Classes]
date and time values [in 3.1.1 Datatype Classes]
date values [in 3.1.1 Datatype Classes]
for internationalization [in 13.2 Character Sets]
multibyte character data [in 3.1.1 Datatype Classes]
national character set [in 13.2 Character Sets]
problems with diverse [in 7.1 The Problem of Diverse Data Types]
standard character set [in 13.2 Character Sets]
time periods [in 3.1.1 Datatype Classes]
database classes [in 3.1.2 Database Classes]
database client
metadata caching [in 9.2 A Database Client Perspective]
database connectivity
required for SourcePro DB [in 1.3.3 Database Connectivity]
database data caching
cache manager example [in 9.4.7 Example]
classes involved in metadata caching [in 9.4 Metadata Caching and the Cache Manager]
clearing the in-memory cache [in 9.4.5 The In-Memory Cache Manager]
during database insertion and retrieval [in 9.1 Caching and Performance]
effect on performance [in 9.1 Caching and Performance]
error handling [in 9.4.3 Error Handling in the Cache Manager]
how metadata caching works [in 9.4.1 Types of Cacheable Data]
implementing a cache manager [in 9.4.6 Implementing a Cache Manager]
in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
keeping cache data current [in 9.4.4 Keeping the Cache Up-To-Date]
lifetime requirement for cache manager [in 9.4.2 Using the Cache Manager]
local vs global metadata cache [in 9.4 Metadata Caching and the Cache Manager]
metadata caching [in 9.1 Caching and Performance]
metadata caching in the client [in 9.2 A Database Client Perspective]
multithreading and the cache manager [in 9.4.2 Using the Cache Manager]
persisting the in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
restrictions on insertion and retrieval [in 9.3.3 Restrictions On Caching with RWDBReader, RWDBInserter]
result schemas [in 9.3.4 Result Schema Caching]
RWDBEnvironmentHandle [in 9.3.4 Result Schema Caching]
RWDBInserter options [in 9.3.1 Caching with RWDBInserter]
RWDBReader options [in 9.3.2 Caching with RWDBReader]
using the cache manager [in 9.4.2 Using the Cache Manager]
database differences [in 5.2.2 RWDBCriterion and RWDBExpr]
database errors [in 6.5.1 Kinds of Errors]
[in 6.5.1 Kinds of Errors]
interpreting [in 6.5.2 Capturing Database-Dependent Information]
database layer [in 7.2 The SourcePro DB Solution]
[in 7.3 The Database Layer]
database table [in 4.4 Tables]
database() [in 4.2 Getting a Connection]
database-independent classes [in 11.5 Database-Independent Classes]
deadlock [in 11.3 Sharing Objects of the DB Interface Module Among Threads]
default column constraints [in 4.5.2.2 Default Column Constraints]
defaultify, referential action [in 4.5.3.2 Foreign Key Constraints]
deleting data [in 5.6 Deleting Data]
DLL [in 4.2 Getting a Connection]
double indexing [in 4.4.6 Summary]
dropping constraints [in 4.5.4.2 Adding or Dropping Constraints]
early binding [in 7.3 The Database Layer]
error handlers [in 6.3 Error Handlers]
[in 6.5 More About Error Handlers]
in RWDBManager [in 6.3 Error Handlers]
error handling [in 6.1 Overview]
in the cache manager [in 9.4.3 Error Handling in the Cache Manager]
simple [in 6.2 Checking Status with Class RWDBStatus]
error model [in 3.1.7 Utility and Diagnostics Classes]
ways to report errors [in 6.1 Overview]
error reporting
checking status [in 6.2 Checking Status with Class RWDBStatus]
error handlers [in 6.3 Error Handlers]
example framework [in 16.1 Introduction]
example of metadata caching [in 9.4.7 Example]
Example Program 1 [in 4.2 Getting a Connection]
Example Program 2 [in 4.4.2 Reading Tables: Class RWDBReader]
Example Program 3 [in 5.3.1 Selecting Data from a Single Table]
Example Program 4 [in 5.3.2 Joins]
Example Program 5 [in 5.7.3 Complex Stored Procedure Example]
examples
check constraints [in 4.5.4.1.3 Creating Unique and Check Constraints]
creating an identity column [in 4.5.2.3.1 Creating an identity column]
foreign key constraint [in 4.5.4.1.2 Creating a Foreign Key Constraint]
primary key constraints [in 4.5.4.1.1 Creating a Primary Key Constraint]
unique constraints [in 4.5.4.1.3 Creating Unique and Check Constraints]
execute()
produces an RWDBResult [in 4.4.5 Result Tables]
explicit connection [in 4.3.2 Explicit and Implicit Connections]
expressions [in 3.1.4 Expression Classes]
external errors [in 6.5.1 Kinds of Errors]
fetching foreign keys [in 4.5.4.3.2 Foreign Keys]
fetching primary keys [in 4.5.4.3.1 Primary Keys]
fetching table constraints [in 4.5.4.3 Fetching Table Constraints]
fetchRow() [in 5.8.3 Fetch Operation]
foreign keys
cacheable as metadata [in 9.4.1 Types of Cacheable Data]
constraint [in 4.5.3.2 Foreign Key Constraints]
constraint example [in 4.5.4.1.2 Creating a Foreign Key Constraint]
fetching [in 4.5.4.3.2 Foreign Keys]
formatting
data [in 13.3 Data Formatting]
raw numbers [in 13.3.5 Formatting Raw Numbers]
front-end dead-lock
avoiding [in 4.3.6 Transaction Control and Locking]
functions
aggregate [in 5.3.6 Aggregates, Expressions, and Functions]
asynchronous [in 12.7 Asynchronous Calls in the DB Interface Module]
[in 12.2 Architectural Overview]
information flow [in 2.6 Information Flow]
naming conventions for [in 3.3 Member Function Conventions]
predefined [in 5.3.6 Aggregates, Expressions, and Functions]
future object [in 12.2 Architectural Overview]
RWDBStatus [in 12.4 RWDBStatus Behavior in the Asynchronous Context]
grouping [in 5.3 Selecting Data]
[in 5.3.5 Ordering and Grouping]
guard classes [in 11.3 Sharing Objects of the DB Interface Module Among Threads]
portable [in 11.8 Portable Guard Classes]
with templates [in 11.6 The Guard Class with Templates]
[in 11.6 The Guard Class with Templates]
without templates [in 11.7 Guard Classes Without Templates]
hierarchy
database-dependent classes [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
database-independent classes [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
producer/product [in 2.3 Producers and Products]
hint
Open SQL statement type [in 15.1.3 Statement Type Hint]
identity column constraint [in 4.5.2.3 Identity Column Constraints]
and primary key constraint [in 4.5.3.1 Primary Key Constraints]
example [in 4.5.2.3.1 Creating an identity column]
implementation classes [in 1.1 Overview]
[in 2.3 Producers and Products]
[in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
[in 2.2 Interface and Implementation Classes]
[in 4.2 Getting a Connection]
[in 2.5 Memory Allocation]
implicit connection [in 4.3.2 Explicit and Implicit Connections]
in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
clearing memory [in 9.4.5 The In-Memory Cache Manager]
persisting its data [in 9.4.5 The In-Memory Cache Manager]
inheritance [in 4.4.4 Memory Tables]
inserting data [in 5.4 Inserting Data]
unexpected events [in 5.4.4 Getting Results from an Inserter]
using a reader [in 5.4.3 Inserting with a Reader]
using a selector [in 5.4.2 Inserting with a Selector]
values from program variables [in 5.4 Inserting Data]
insertion operator << [in 5.3.2 Joins]
interface classes [in 2.2 Interface and Implementation Classes]
[in 2.5 Memory Allocation]
database-dependent [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
database-independent [in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
interface module [in 2.1 Basic Architecture]
[in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
Interface/Implementation paradigm [in 2.2 Interface and Implementation Classes]
[in 2.5 Memory Allocation]
internal errors [in 6.5.1 Kinds of Errors]
internationalization
character sets in [in 13.2 Character Sets]
defined [in 13.1 Definition]
RWDate [in 13.3.3 RWDate]
RWDecimalPortable [in 13.3.4 RWDecimalPortable]
RWLocale [in 13.3.5 Formatting Raw Numbers]
invalid cursors
RWDBMemTable [in 5.8.1 Instantiating an RWDBCursor]
RWDBTPtrMemTable [in 5.8.1 Instantiating an RWDBCursor]
invalid objects, changing to valid [in 6.6.2 Making Unusable Objects Usable]
isValid(), how to use [in 6.6 More About isValid()]
iterator [in 4.4.2 Reading Tables: Class RWDBReader]
joins [in 5.3.2 Joins]
[in 5.3 Selecting Data]
how to perform [in 5.3.2 Joins]
with self [in 5.3.7 Self-Joins]
late binding [in 7.3 The Database Layer]
lifetime requirement of the DB cache manager [in 9.4.2 Using the Cache Manager]
locale sensitive data [in 13.3 Data Formatting]
mailingLabels() [in 17.5.3 VVContactRepository::mailingLabels]
memory allocation [in 2.5 Memory Allocation]
memory management
with cursors [in 5.8.2 Bind Operations]
memory table [in 4.4.4 Memory Tables]
[in 4.4 Tables]
template-based [in 22.2 Overview of This Tutorial]
metadata caching in DB [in 9.1 Caching and Performance]
cache manager example [in 9.4.7 Example]
classes involved [in 9.4 Metadata Caching and the Cache Manager]
clearing the in-memory cache [in 9.4.5 The In-Memory Cache Manager]
error handling [in 9.4.3 Error Handling in the Cache Manager]
how it works [in 9.4.1 Types of Cacheable Data]
implementing a cache manager [in 9.4.6 Implementing a Cache Manager]
in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
keeping cache data current [in 9.4.4 Keeping the Cache Up-To-Date]
lifetime requirement for cache manager [in 9.4.2 Using the Cache Manager]
local vs global cache [in 9.4 Metadata Caching and the Cache Manager]
multithreading and the cache manager [in 9.4.2 Using the Cache Manager]
persisting the in-memory cache manager [in 9.4.5 The In-Memory Cache Manager]
using the cache manager [in 9.4.2 Using the Cache Manager]
multibyte character set strings [in 13.2.4 RWDBMBString]
multithreading and the DB cache manager [in 9.4.2 Using the Cache Manager]
mutex [in 11.3 Sharing Objects of the DB Interface Module Among Threads]
locking and unlocking [in 11.3 Sharing Objects of the DB Interface Module Among Threads]
n&rcub [in 3.1.4 Expression Classes]
[in 3.1.4 Expression Classes]
national character set data types [in 13.2 Character Sets]
NCHAR [in 13.2 Character Sets]
normalization, definition [in 7.2 The SourcePro DB Solution]
normalizing data types [in 3.1 Kinds of Classes]
[in 3.2 Summary of Classes]
RWDBValue [in 3.1.1 Datatype Classes]
not null constraints [in 4.5.2.1 Not Null Constraints]
NULL values [in 3.1.1 Datatype Classes]
[in 4.4.2 Reading Tables: Class RWDBReader]
[in 5.7.1 Instantiating RWDBStoredProc]
nullify, referential action [in 4.5.4.1.2 Creating a Foreign Key Constraint]
[in 4.5.3.2 Foreign Key Constraints]
NVARCHAR [in 13.2 Character Sets]
Open SQL
part of pointer layer [in 7.5 The Pointer Layer]
statement type hint [in 15.1.3 Statement Type Hint]
operator[] [in 4.4.4 Memory Tables]
operator>>()
global overloading [in 17.5.4 operator>>() for VVContact]
operator<<() [in 18.5.3 VVContactRepository::reader]
[in 19.5.3 operator<<() for VVContact]
overloaded [in 19.5.2 VVContactRepository::insert]
ordering [in 5.3 Selecting Data]
[in 5.3.5 Ordering and Grouping]
ordering and grouping
restrictions [in 5.3.5 Ordering and Grouping]
outer join
example in the WHERE clause [in 5.3.3.2 Outer Join Constructs In the WHERE Clause (ANSI-Noncompliant)]
multiple example in the FROM clause [in 5.3.3.1 Outer Join Constructs in the FROM Clause (ANSI-Compliant)]
nested example in the FROM clause [in 5.3.3.1 Outer Join Constructs in the FROM Clause (ANSI-Compliant)]
simple example in the FROM clause [in 5.3.3.1 Outer Join Constructs in the FROM Clause (ANSI-Compliant)]
outer joins
ANSI and non-ANSI [in 5.3.3 Outer Joins]
in non-ANSI syntax [in 5.3.3.2 Outer Join Constructs In the WHERE Clause (ANSI-Noncompliant)]
in SQL 92 syntax [in 5.3.3.1 Outer Join Constructs in the FROM Clause (ANSI-Compliant)]
in the FROM clause [in 5.3.3.1 Outer Join Constructs in the FROM Clause (ANSI-Compliant)]
in the WHERE clause [in 5.3.3.2 Outer Join Constructs In the WHERE Clause (ANSI-Noncompliant)]
outermost transaction [in 4.3.5 Transaction Processing with RWDBConnection]
overloading [in 5.2.1 RWDBCriterion]
[in 3.3 Member Function Conventions]
extraction operator [in 4.4.2.1 Overloading the Extraction Operator]
performance
changing connection pool size [in 4.3.3 Connection Pools]
DB caching [in 9.1 Caching and Performance]
with asynchronous calls [in 12.7.2 Performance Issues]
with RWDateTime [in 7.4.3 RWDBDateTime]
persistence
of DB cache manager data [in 9.4.5 The In-Memory Cache Manager]
pointer layer [in 7.5 The Pointer Layer]
[in 7.2 The SourcePro DB Solution]
pointers
unnecessary [in 2.5 Memory Allocation]
pool size
changing [in 4.3.3 Connection Pools]
portability [in 6.5.2 Capturing Database-Dependent Information]
[in 13.2.4 RWDBMBString]
[in 2.2.1 Database-Dependent and Database-Independent Interface Classes]
predefined functions [in 5.3.6 Aggregates, Expressions, and Functions]
primary keys
and unique constraints [in 4.5.3.3 Unique Table Constraints]
cacheable as metadata [in 9.4.1 Types of Cacheable Data]
constraint example [in 4.5.4.1.1 Creating a Primary Key Constraint]
constraints [in 4.5.3.1 Primary Key Constraints]
fetching [in 4.5.4.3.1 Primary Keys]
producer/product paradigm [in 2.3 Producers and Products]
and RWDBManager [in 2.3 Producers and Products]
producers [in 2.3 Producers and Products]
products [in 2.3 Producers and Products]
projections [in 5.3 Selecting Data]
[in 5.3.2 Joins]
[in 5.3.1 Selecting Data from a Single Table]
public class hierarchy [in 2.2 Interface and Implementation Classes]
random access
with RWDBMemTable [in 4.4.6 Summary]
reference semantics [in 2.4 Reference Semantics]
referenceKey() method of RWDBForeignKey [in 4.5.4.1.2 Creating a Foreign Key Constraint]
referential action, and foreign key constraints [in 4.5.3.2 Foreign Key Constraints]
referential action
changing [in 4.5.4.1.2 Creating a Foreign Key Constraint]
referential integrity, and foreign key constraints [in 4.5.3.2 Foreign Key Constraints]
restrict, referential action [in 4.5.3.2 Foreign Key Constraints]
[in 4.5.4.1.2 Creating a Foreign Key Constraint]
restrictions [in 5.3 Selecting Data]
[in 5.3.1 Selecting Data from a Single Table]
[in 5.3.2 Joins]
result schema caching [in 9.3.4 Result Schema Caching]
result tables [in 4.4.5 Result Tables]
[in 4.4 Tables]
generating and reading [in 4.4.5 Result Tables]
RWBasicUString [in 3.1.1 Datatype Classes]
for internationalization [in 13.2.2 RWBasicUString]
RWCString [in 7.4.1 RWCString]
[in 3.1.1 Datatype Classes]
for standard character sets [in 13.2.5 RWCString]
in SourcePro DB [in 13.2.5 RWCString]
RWDate [in 13.3.3 RWDate]
[in 3.1.1 Datatype Classes]
localizing options [in 13.3.3 RWDate]
RWDateTime [in 2.4 Reference Semantics]
[in 2.4 Reference Semantics]
[in 13.3.1 RWDateTime]
[in 3.2 Summary of Classes]
[in 7.2 The SourcePro DB Solution]
[in 7.2 The SourcePro DB Solution]
[in 7.4.2 RWDateTime]
[in 7.4.2.2 Constructors]
[in 3.1.1 Datatype Classes]
[in 3.1.1 Datatype Classes]
[in 2.4 Reference Semantics]
constructors [in 7.4.2.2 Constructors]
example [in 7.4.2.1 Example]
RWDBAssignment [in 5.2.3 RWDBAssignment]
[in 5.2 Expressions, Criterions, and Assignments]
[in 3.1.4 Expression Classes]
RWDBBlob [in 7.4.5 RWDBBlob]
[in 3.1.1 Datatype Classes]
RWDBBoundExpr [in 3.1.4 Expression Classes]
part of pointer layer [in 7.5 The Pointer Layer]
RWDBBuffer<T>:part of pointer layer [in 7.5 The Pointer Layer]
RWDBBulkInserter [in 3.1.5 Bulk Classes]
[in 3.1.5 Bulk Classes]
[in 8.1 The Bulk Classes]
[in 3.1.5 Bulk Classes]
RWDBBulkReader [in 8.1 The Bulk Classes]
RWDBCacheManager [in 9.4 Metadata Caching and the Cache Manager]
RWDBCheckConstraint [in 4.5.3.4 Check Table Constraints]
[in 4.5.1 Table Constraints Classes]
[in 3.1.2 Database Classes]
and check condition [in 5.2.1 RWDBCriterion]
RWDBCheckConstraintList [in 4.5.3.4 Check Table Constraints]
[in 4.5.1 Table Constraints Classes]
[in 3.1.2 Database Classes]
RWDBCollectableExpr [in 3.1.4 Expression Classes]
RWDBColumn [in 3.1.2 Database Classes]
[in 4.4.1 Database Tables]
and constraints [in 4.5.2.1 Not Null Constraints]
defaultValue() method [in 4.5.2.2 Default Column Constraints]
RWDBCompoundSelector
asString() method [in 5.9 asString() Methods in the Data Manipulation Classes]
RWDBConnection [in 4.3.1 RWDBDatabase and RWDBConnection]
[in 3.1.2 Database Classes]
and transaction processing [in 4.3.5 Transaction Processing with RWDBConnection]
RWDBCriterion [in 5.2.2 RWDBCriterion and RWDBExpr]
[in 5.3.1 Selecting Data from a Single Table]
[in 5.6 Deleting Data]
[in 5.3.2 Joins]
[in 5.2 Expressions, Criterions, and Assignments]
[in 3.1.4 Expression Classes]
and check conditions [in 5.2.1 RWDBCriterion]
RWDBCritFormDefinition [in 3.1.4 Expression Classes]
RWDBCritFuncDef&lcub [in 3.1.4 Expression Classes]
RWDBCursor [in 3.1.3 Data Manipulation Classes]
[in 5.8 Cursors]
part of pointer layer [in 7.5 The Pointer Layer]
RWDBDatabase [in 4.3.1 RWDBDatabase and RWDBConnection]
[in 4.4 Tables]
[in 3.1.7 Utility and Diagnostics Classes]
[in 4.4.1 Database Tables]
[in 3.1.2 Database Classes]
[in 4.4.4 Memory Tables]
RWDBDateTime [in 7.4.3 RWDBDateTime]
[in 3.1.1 Datatype Classes]
[in 6.2 Checking Status with Class RWDBStatus]
RWDBDateTime changes
64-bit parameters [in 7.4.3.3 64-bit Variables]
conversions to RWDateTime [in 7.4.3.1 Conversions between RWDBDateTime and RWDateTime]
current time in now() [in 7.4.3.5 Current Time]
general [in 7.4.3 RWDBDateTime]
optional RWZone parameters [in 7.4.3.4 Optional RWZone Parameter]
persistence [in 7.4.3.2 Persistence]
RWDBDeleter [in 3.1.3 Data Manipulation Classes]
[in 5.6 Deleting Data]
asString() method [in 5.9 asString() Methods in the Data Manipulation Classes]
RWDBDuration [in 7.4.4 RWDBDuration]
[in 3.1.1 Datatype Classes]
RWDBEnvironmentHandle and data caching [in 9.3.4 Result Schema Caching]
RWDBExpr [in 5.2.3 RWDBAssignment]
[in 5.2 Expressions, Criterions, and Assignments]
[in 5.2.2 RWDBCriterion and RWDBExpr]
[in 5.3.6 Aggregates, Expressions, and Functions]
[in 3.1.4 Expression Classes]
RWDBExprFormDefinition [in 3.1.4 Expression Classes]
RWDBExprFuncDef&lcub [in 3.1.4 Expression Classes]
RWDBForeignKey [in 4.5.1 Table Constraints Classes]
[in 4.5.3.2 Foreign Key Constraints]
[in 3.1.2 Database Classes]
referenceKey() method [in 4.5.4.1.2 Creating a Foreign Key Constraint]
RWDBForeignKeyList [in 4.5.4.3.2 Foreign Keys]
[in 4.5.1 Table Constraints Classes]
[in 3.1.2 Database Classes]
[in 3.1.2 Database Classes]
[in 4.5.3.2 Foreign Key Constraints]
RWDBIdentityConstraint [in 4.5.2.3 Identity Column Constraints]
[in 3.1.2 Database Classes]
[in 4.5.1 Table Constraints Classes]
RWDBInserter [in 3.1.3 Data Manipulation Classes]
[in 5.4 Inserting Data]
RWDBInserter options for data caching [in 9.3.1 Caching with RWDBInserter]
RWDBInserter
asString() method [in 5.9 asString() Methods in the Data Manipulation Classes]
RWDBJoinExpr [in 3.1.4 Expression Classes]
RWDBManager [in 4.2 Getting a Connection]
[in 2.3 Producers and Products]
[in 3.1.2 Database Classes]
RWDBMBString [in 3.1.1 Datatype Classes]
for internationalization [in 13.2.4 RWDBMBString]
for national character sets [in 13.2.5 RWCString]
RWDBMemTable [in 4.4.6 Summary]
[in 3.1.7 Utility and Diagnostics Classes]
[in 4.4.4 Memory Tables]
RWDBNullIndicator [in 4.4.2 Reading Tables: Class RWDBReader]
[in 3.1.1 Datatype Classes]
RWDBPhraseBook [in 3.1.7 Utility and Diagnostics Classes]
and returning constraints [in 4.5.4.3.3 Unique and Check Constraints]
RWDBPrimaryKey [in 4.5.4.1.1 Creating a Primary Key Constraint]
[in 3.1.2 Database Classes]
[in 4.5.1 Table Constraints Classes]
[in 4.5.3.1 Primary Key Constraints]
RWDBReader [in 5.3.2 Joins]
[in 4.4.2 Reading Tables: Class RWDBReader]
[in 4.4.6 Summary]
[in 3.1.3 Data Manipulation Classes]
[in 4.4.2 Reading Tables: Class RWDBReader]
[in 3.1.3 Data Manipulation Classes]
RWDBReader options for data caching [in 9.3.2 Caching with RWDBReader]
RWDBReaders
asynchronous [in 12.8 Asynchronous RWDBReaders]
RWDBResult [in 4.4.6 Summary]
[in 3.1.3 Data Manipulation Classes]
RWDBRow [in 4.4.4 Memory Tables]
[in 3.1.7 Utility and Diagnostics Classes]
[in 3.1.7 Utility and Diagnostics Classes]
RWDBSchema [in 3.1.2 Database Classes]
[in 4.4.1 Database Tables]
and list of constraints [in 4.5.4.1.3 Creating Unique and Check Constraints]
RWDBSelector [in 5.2.1 RWDBCriterion]
[in 5.3 Selecting Data]
[in 5.3.7 Self-Joins]
[in 5.3.9 Summary]
[in 3.1.3 Data Manipulation Classes]
[in 5.3.6 Aggregates, Expressions, and Functions]
asString() method [in 5.9 asString() Methods in the Data Manipulation Classes]
RWDBStatus [in 6.5.1 Kinds of Errors]
[in 6.2 Checking Status with Class RWDBStatus]
[in 3.1.7 Utility and Diagnostics Classes]
asynchronous context [in 12.4 RWDBStatus Behavior in the Asynchronous Context]
cache manager errors [in 9.4.3 Error Handling in the Cache Manager]
Oracle errors [in 6.5.2 Capturing Database-Dependent Information]
RWDBStoredProc [in 5.7 Stored Procedures]
[in 3.1.2 Database Classes]
RWDBStoredProcEntry
used for metadata caching [in 9.4 Metadata Caching and the Cache Manager]
RWDBSystemHandle [in 3.1.2 Database Classes]
RWDBTable [in 4.4 Tables]
[in 4.4.6 Summary]
[in 3.1.2 Database Classes]
[in 5.3.7 Self-Joins]
[in 4.4 Tables]
[in 4.4.1 Database Tables]
alternatives to [in 4.4.4 Memory Tables]
RWDBTableEntry
used for metadata caching [in 9.4 Metadata Caching and the Cache Manager]
RWDBTPtrMemTable<T,C> [in 4.4.4 Memory Tables]
[in 3.1.7 Utility and Diagnostics Classes]
RWDBTracer [in 3.1.7 Utility and Diagnostics Classes]
RWDBUniqueConstraint [in 4.5.1 Table Constraints Classes]
[in 3.1.2 Database Classes]
[in 4.5.3.3 Unique Table Constraints]
RWDBUniqueConstraintList [in 3.1.2 Database Classes]
[in 4.5.1 Table Constraints Classes]
RWDBUpdater [in 5.5 Updating Data]
[in 3.1.3 Data Manipulation Classes]
asString() method [in 5.9 asString() Methods in the Data Manipulation Classes]
RWDBValue [in 5.7.3 Complex Stored Procedure Example]
[in 3.1.1 Datatype Classes]
[in 4.4.4 Memory Tables]
[in 7.4.7 RWDBValue]
RWDecimalPortable [in 4.4.2 Reading Tables: Class RWDBReader]
[in 13.3.4 RWDecimalPortable]
[in 3.1.1 Datatype Classes]
[in 7.4.6 RWDecimalPortable]
internationalization example [in 13.3.4 RWDecimalPortable]
RWExpr
and constraint check condition [in 4.5.4.1.3 Creating Unique and Check Constraints]
RWExternalErr [in 6.4 Exceptions]
RWUniqueConstraintList [in 4.5.3.3 Unique Table Constraints]
RWWString [in 3.1.1 Datatype Classes]
for internationalization [in 13.2.3 RWWString]
selecting and inserting [in 13.2.3 RWWString]
with cursors and readers [in 13.2.3 RWWString]
with stored procedures [in 13.2.3 RWWString]
schema
cacheable as metadata [in 9.4.1 Types of Cacheable Data]
defined [in 4.4.1 Database Tables]
SELECT statement [in 5.3 Selecting Data]
selecting data [in 5.3 Selecting Data]
self-joins [in 5.3.7 Self-Joins]
servers [in 5.2 Expressions, Criterions, and Assignments]
set operators [in 5.3 Selecting Data]
shared libraries [in 4.2 Getting a Connection]
shared table references [in 5.3.8 Subqueries]
sharing objects [in 11.3 Sharing Objects of the DB Interface Module Among Threads]
SourcePro DB
definition [in 1.1 Overview]
performance features [in 1.2.3 Enhanced Performance]
SQL constraints. See also => constraints.
SQL expressions [in 3.1.4 Expression Classes]
SQL operations [in 4.4 Tables]
SQL table constraints. See also => constraints.
standard character set data types [in 13.2 Character Sets]
static libraries [in 4.2 Getting a Connection]
stored procedures [in 4.4.5 Result Tables]
[in 5.7 Stored Procedures]
cacheable as metadata [in 9.4.1 Types of Cacheable Data]
with multiple SELECT statements [in 5.7.3 Complex Stored Procedure Example]
subqueries [in 5.3.8 Subqueries]
synchronous connections [in 12.2 Architectural Overview]
system handle [in 3.1.2 Database Classes]
t1 [in 17.3 Running the Program]
[in 21.3 Running the Program]
t2 [in 18.3 Running the Program]
t3 [in 19.3 Running the Program]
t4 [in 20.3 Running the Program]
t6 [in 22.3 Running the Program]
t7 [in 23.3 Running the Program]
table constraints [in 4.5 Table Constraints]
[in 4.5.3 Table Level Constraints]
check [in 4.5.3.4 Check Table Constraints]
table()
RWDBResult [in 4.4.5 Result Tables]
tables [in 4.4 Tables]
getting a table [in 4.4.1 Database Tables]
kinds of tables [in 4.4 Tables]
reading tables [in 4.4.2 Reading Tables: Class RWDBReader]
table owners [in 4.4.1 Database Tables]
time conversions in DB Interface Module [in 7.4.4 RWDBDuration]
topTenVideo [in 22.2 Overview of This Tutorial]
transaction control [in 4.3.6 Transaction Control and Locking]
transaction model [in 4.3.5 Transaction Processing with RWDBConnection]
transaction processing [in 4.3.5 Transaction Processing with RWDBConnection]
triggers [in 5.4.4 Getting Results from an Inserter]
[in 4.4.5 Result Tables]
Tutorial Five [in 21.1 Goal of This Tutorial]
Tutorial Four [in 20.1 Goal of This Tutorial]
Tutorial One [in 17.1 Goal of This Tutorial]
Tutorial Seven [in 23.1 Goal of This Tutorial]
Tutorial Six [in 22.1 Goal of This Tutorial]
Tutorial Three [in 19.1 Goal of This Tutorial]
Tutorial Two [in 18.1 Goal of This Tutorial]
tutorials
complicated query [in 22.1 Goal of This Tutorial]
customer table [in 16.4 The Tutorial Model]
deleting rows from a table [in 21.1 Goal of This Tutorial]
inserting data [in 19.1 Goal of This Tutorial]
model for [in 16.4 The Tutorial Model]
overdue customer records [in 18.2 Overview of This Tutorial]
printing mailing labels [in 17.2 Overview of This Tutorial]
purchase table [in 16.4 The Tutorial Model]
rentals table [in 16.4 The Tutorial Model]
retrieving data from a table [in 17.1 Goal of This Tutorial]
selective retrieval of data [in 18.1 Goal of This Tutorial]
supplier table [in 16.4 The Tutorial Model]
tables, classes, and files [in 16.4 The Tutorial Model]
[in 16.4 The Tutorial Model]
updating data [in 20.1 Goal of This Tutorial]
[in 23.1 Goal of This Tutorial]
using a template-based collection [in 22.1 Goal of This Tutorial]
videos table [in 16.4 The Tutorial Model]
type conversions [in 3.3 Member Function Conventions]
[in 5.2.1 RWDBCriterion]
[in 5.7.2 Type and Error Checking in RWDBStoredProc]
Unicode strings
in SourcePro DB [in 13.2.2 RWBasicUString]
unique constraints [in 4.5.3.3 Unique Table Constraints]
and primary keys [in 4.5.3.3 Unique Table Constraints]
example [in 4.5.4.1.3 Creating Unique and Check Constraints]
fetching [in 4.5.4.3.3 Unique and Check Constraints]
uniqueness
and identity column constraint [in 4.5.2.3 Identity Column Constraints]
and primary key constraints [in 4.5.3.1 Primary Key Constraints]
updaters
getting one [in 5.5 Updating Data]
updating data [in 5.5 Updating Data]
usable object, defined [in 6.6.1 Defining a Valid Object]
valid object [in 6.6.1 Defining a Valid Object]
value layer [in 7.2 The SourcePro DB Solution]
[in 7.4 The Value Layer]
features of [in 7.4 The Value Layer]
value semantics [in 2.4 Reference Semantics]
VARCHAR [in 13.2 Character Sets]
video store model [in 16.4 The Tutorial Model]
VVContact [in 17.2 Overview of This Tutorial]
[in 19.2 Overview of This Tutorial]
[in 18.2 Overview of This Tutorial]
operator>>() [in 17.5.4 operator>>() for VVContact]
VVContactRepository [in 17.2 Overview of This Tutorial]
[in 19.2 Overview of This Tutorial]
[in 21.2 Overview of This Tutorial]
[in 18.2 Overview of This Tutorial]
constructor [in 17.5.2 VVContactRepository Constructor]
mailingLabels() [in 17.5.3 VVContactRepository::mailingLabels]
remove() [in 21.5.2 VVContactRepository::remove]
VVInvoice
addRental() [in 23.5.2 VVInvoice::addRental]
VVPurchase [in 20.2 Overview of This Tutorial]
VVPurchaseTransactionRepository [in 20.2 Overview of This Tutorial]
VVRentalTransaction [in 18.2 Overview of This Tutorial]
VVRentalTransactionRepository [in 18.2 Overview of This Tutorial]
VVVideo [in 16.4 The Tutorial Model]
[in 20.2 Overview of This Tutorial]
VVVideoRepository [in 16.4 The Tutorial Model]
[in 22.2 Overview of This Tutorial]
[in 20.2 Overview of This Tutorial]
[in 23.5.4 VVVideoRepository::update]
find() [in 23.5.3 VVVideoRepository::find]
update() [in 23.5.4 VVVideoRepository::update]
updateStock() [in 20.5.2 VVVideoRepository::updateStock]
wide character strings [in 13.2.3 RWWString]
Copyright © Rogue Wave Software, Inc. All Rights Reserved.
The Rogue Wave name and logo, and SourcePro, are registered trademarks of Rogue Wave Software. All other trademarks are the property of their respective owners.
Provide feedback to Rogue Wave about its documentation.