LIBCXX SQL Library
		Next

LIBCXX SQL Library

Index

LIBCXX SQL Library

Introduction
Known issues
Installation, and requirements

I. Core SQL classes

1. Creating an SQL environment

2. Connecting to an SQL server

Connecting to a non-predefined data source
Determining SQL database driver capabilities

3. Executing SQL statements

Logging executed SQL
Combining prepare() with execute()
Vector parameters
Fetching SELECT results
Limiting the number of rows fetched
Bulk SELECT fetches
Creating scrollable cursors
Using scrollable cursors
Modifying fetched rows
Batches and row counts
Using mpf_class values from GMP library

4. Transactions

Disabling and enabling automatic commits
begin_work(), commit_work() and rollback_work()
x::sql::transaction

5. Inserting and fetching blobs

Inserting blobs
Retrieving blobs

6. SQL catalogs

II. SQL database interface

7. Creating resultsets

automake macros
Resultset objects created from a schema file
Resultset class names
Setting upper limit on the number of resultset rows

8. Adding constraints to resultsets

9. Adding joins to resultsets

Specifying columns used in joins, and multiple joins to the same table
Nested resultsets
Prefetching rows from joined tables

10. Adding GROUP BY, HAVING, and ORDER BY to resultsets

11. UPDATE resultsets

UPDATEs using joins
Updating individual rows

12. INSERTing into a resultset

INSERTing into a nested resultset
INSERTing into tables with serial/autoincrement columns

13. Standalone constraints

		Next
		LIBCXX SQL Library