This part includes information you’ll need if you
plan to use Dexterity to create applications for use with Microsoft
SQL Server. It contains information about SQL-specific concepts,
such as data sources, connections, cursors and stored procedures.
Following is a list of topics that are discussed:
Data Sources
explains how to set up Microsoft SQL Server and create data sources
necessary to access it.
Logins and Connections explains how to log into a
SQL data source from a Dexterity application. It also describes
connections and how they are managed by Dexterity.
Cursors explains the SQL-specific concept of a
cursor, and provides information about manipulating the cursor to
optimize your application’s performance and provide users with the
most current data from the application’s tables.
Locking provides information about the way in
which active locking is implemented for use with SQL.
SQL Tables
explains how to create SQL tables, methods to add data to them, and
how to grant privileges.
Stored Procedures
discusses SQL stored procedures and procedures you’ll need to add
to your Dexterity application to properly execute stored
procedures.
Pass-through SQL
explains how to use pass-through SQL in an application.