Consistency Across Different Databases
If you currently work with several different databases, you will find that SourcePro DB promotes consistency through its processes and procedures. Features that promote consistency include:
Automatic normalization of data types. You don’t have to adapt to the different ways database vendors represent data; SourcePro DB does it for you. Class RWDBValue converts database-dependent types to C++ types, and vice-versa. See Chapter 7, The Data Model.A uniform method for processing results. Some RDBMSs can produce multiple result sets from a single query, or completely unexpected result sets if stored procedures or triggers are involved. Class RWDBResult allows your application to handle these events easily, or to ignore them. No more flushing your data stream. See Getting Results from an Inserter.A uniform view of tabular data. With class RWDBTable, you can use the same interface to deal with tables in a relational database, derived tables representing a SQL query as a table, tables in program memory, and tables that result from a join. See Tables.Consistent error handling. Whatever databases you are using, the same error model applies. And SourcePro DB is exception safe in environments using C callback routines. Support for stored procedures. Class RWDBStoredProc encapsulates the functionality of a database stored procedure, including creation, deletion, and execution of stored procedures, and passing parameters by value or by reference. It can handle multiple result sets. See Stored Procedures.
