Chapter 4 The Database Classes

SourcePro DB lets you interact with your database using C++. The core classes of the DB Interface Module encapsulate SQL 92 Data Manipulation Language (DML) and Data Definition Language (DDL) constructs. In this chapter, we discuss the classes that encapsulate basic database constructs, primarily connections and tables. In Chapter 5, “The Data Manipulation Classes,” we discuss the classes that encapsulate basic data manipulation operations: SELECT, INSERT, UPDATE, and DELETE, and the related topics of stored procedures and cursors.

NOTE >> You must install your database client software and establish a working database connection before building SourcePro DB. See Installing and Building Your SourcePro C++ Products and “Database Connectivity” in this manual.

The example programs used in these chapters are listed in Table 5. If you are reading this manual online, click the number of an example to jump to the code:

Table 5 – Example programs of SourcePro DB
Number of Program	Topic
Example 1	Establishing connectivity
Example 2	Reading a database table
Example 3	Selecting from a single table
Example 4	Performing a join
Example 5	Unknown results from stored procedure
Example 6	Using the asString() method