As we discussed in Chapter 14, Defining Open SQL, Open SQL is a database-portable set of classes for directly executing SQL statements. In this chapter, we explore the Open SQL classes in more detail, and demonstrate how to use them within your applications. Of the three classes that form the Open SQL API, class RWDBOSql is the most important.

Class RWDBOSql is the core of the Open SQL API. Fundamentally, using Open SQL involves four activities:

Each of these activities depends on RWDBOSql, so we begin this chapter by creating an instance of this class.