Embedded SQL Guide

Go Up to User Guides

The Embedded SQL Guide cover the "how-to" information on developing InterBase applications using embedded SQL.

Topics include:

• Application requirements
• Working with databases, transactions, data definition statements, data, dates and times, arrays, stored procedures and events
• Error handling
• Dynamic SQL
• Preprocessing, compiling and linking

Chapters

The following table provides a brief description of each chapter in the Embedded SQL Guide:

Chapter	Description
Using the Embedded SQL Guide	Describes elements common to programming all SQL and DSQL applications.
Application Requirements	Describes elements common to programming all SQL and DSQL applications. Requirements for All Applications Declaring and Initializing Databases SQL Statements Error Handling and Recovery Closing Transactions Closing Databases DSQL Requirements DSQL Limitations Preprocessing Programs
Working with Databases	Describes how to use SQL statements that deal with databases. Declaring a Database Specifying a Connection Character Set Opening a Database Accessing an Open Database Differentiating Table Names Closing a Database
Working with Transactions	Explains how to use and control transactions with SQL statements. Starting the Default Transaction Starting a Named Transaction Using Transaction Names in Data Statements Ending a Transaction Working with Multiple Transactions Working with Multiple Transactions in DSQL
Working with Data Definition Statements	Describes how to embed SQL data definition statements in applications. Creating Metadata Dropping Metadata Altering Metadata
Working with Data	Explains how to select, insert, update, and delete standard SQL data in applications. Supported Data Types Understanding SQL Expressions Understanding Data Retrieval with SELECT Selecting a Single Row Selecting Multiple Rows Selecting Multiple Rows in DSQL Joining Tables Using Subqueries Inserting Data Updating Data Deleting Data
Working with Dates and Times	Describes how to select, insert, update, and delete DATE, TIME, and TIMESTAMP data in applications. Querying the Database for Current Date and Time Information Selecting Dates and Times Formatting Dates for Input Inserting Dates and Times Updating Dates and Times Using CAST( ) to Convert Dates and Times Using Date Literals Adding and Subtracting Date and Time Data Types Comparing Dates and Times Using Date and Time Data Types with Aggregate Functions
Working with Blob Data	Describes how to select, insert, update, and delete Blob data in applications. What is a Blob? How are Blob Data Stored? Accessing Blob Data with SQL Accessing Blob Data with API Calls Filtering Blob Data Writing an External Blob Filter
Using Arrays	Describes how to select, insert, update, and delete array data in applications. Creating Arrays Accessing Arrays
Working with Stored Procedures	Explains how to call stored procedures in applications. Using Stored Procedures Using Select Procedures Using Executable Procedures
Working with Events	Explains how triggers interact with applications. Describes how to register interest in events, wait on them, and respond to them in applications. Understanding the Event Mechanism Signaling Event Occurrences Registering Interest in Events Registering Interest in Multiple Events Waiting for Events with EVENT WAIT Responding to Events
Error Handling and Recovery	Describes how to trap and handle SQL statement errors in applications. Standard Error Handling Additional InterBase Error Handling
Using Dynamic SQL	Describes how to write DSQL applications. Overview of the DSQL Programming Process DSQL Limitations Writing a DSQL Application Understanding the XSQLDA DSQL Programming Methods
Preprocessing, Compiling, and Linking	Describes how to convert source code into an executable application. Preprocessing Compiling and Linking