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.
Working with Databases	Describes how to use SQL statements that deal with databases.
Working with Transactions	Explains how to use and control transactions with SQL statements.
Working with Data Definition Statements	Describes how to embed SQL data definition statements in applications.
Working with Data	Explains how to select, insert, update, and delete standard SQL data in applications.
Working with Dates and Times	Describes how to select, insert, update, and delete DATE, TIME, and TIMESTAMP data in applications.
Working with Blob Data	Describes how to select, insert, update, and delete Blob data in applications.
Using Arrays	Describes how to select, insert, update, and delete array data in applications.
Working with Stored Procedures	Explains how to call stored procedures in applications.
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.
Error Handling and Recovery	Describes how to trap and handle SQL statement errors in applications.
Using Dynamic SQL	Describes how to write DSQL applications.
Preprocessing, Compiling, and Linking	Describes how to convert source code into an executable application.