Comprehensive Functionality
SourcePro DB encapsulates the basic abstractions you need for database programming, as well as the special features required by individual applications. Some of these features include:
Support for internationalization. You can use SourcePro DB with virtually all known character sets and locales. SourcePro DB provides proper formatting of strings, dates, times, numbers, and currency. See Chapter 13, Internationalization.Options for database connections. Class RWDBConnection encapsulates connections to databases. You can let SourcePro DB manage connections invisibly, or control these resources yourself. Specifying an optimum number of default connections can significantly boost the performance of an application. See Managing Connections and the entry for RWDBDatabase in the SourcePro API Reference Guide for details on defaultConnections() and totalConnections(). Class RWDBEnvironmentHandle lets you set certain connect time and configuration parameters before connecting to a database. See your Access Module guide.
You can also initiate a connection when an RWDBDatabase is produced by the RWDBManager. See RWDBDatabase::connect() in the SourcePro API Reference Guide.
Open SQL. You can control SQL statements directly using this alternative interface that encapsulates the semantics for statement execution, parameter binding, and results fetching. See Chapter 15, Using the Open SQL Classes.Primary and foreign key support. You can get direct access to schema information, including datatype, precision, scale, and storage length, and primary and foreign key information. The direct mechanism for the creation of tables also supports primary and foreign keys. See the class descriptions for RWDBForeignKey, and the description of primaryKey() under RWDBSchema and RWDBTable.Outer joins. You can construct SQL outer join syntaxes for SQL 92-compliant syntax and the noncompliant syntaxes supported by some database vendor APIs. See Outer Joins in the DB Interface Module User’s Guide, the class description for RWDBJoinExpr, and the section on outer joins in each Access Module guide.Full exception safety. SourcePro DB is exception-safe even in environments where C callback routines are used. Transaction processing model. SourcePro DB supplies a uniform, ANSI-compliant interface for all supported databases. See Transaction Processing with RWDBConnection.
