Embedded SQL Guide

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	Product
Chapter 1: Using the Embedded SQL Guide	Describes elements common to programming all SQL and DSQL applications.
Chapter 2: Application Requirements	Describes elements common to programming all SQL and DSQL applications.
Chapter 3: Working with Databases	Describes using SQL statements that deal with databases.
Chapter 4: Working with Transactions	Explains how to use and control transactions with SQL statements
Chapter 5: Working with Data Definition Statements	Describes how to embed SQL data definition statements in applications.
Chapter 6: Working with Data	Explains how to select, insert, update, and delete standard SQL data in applications
Chapter 7: Working with Dates and Times	Describes how to select, insert, update, and delete DATE, TIME, and TIMESTAMP data in applications.
Chapter 8: Working with Blob Data	Describes how to select, insert, update, and delete Blob data in applications.
Chapter 9: Using Arrays	Describes how to select, insert, update, and delete array data in applications.
Chapter 10: Working with Stored Procedures	Explains how to call stored procedures in applications.
Chapter 11: 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.
Chapter 12: Error Handling and Recovery	Describes how to trap and handle SQL statement errors in applications.
Chapter 13: Using Dynamic SQL	Describes how to write DSQL applications.
Chapter 14: Preprocessing, Compiling, and Linking	Describes how to convert source code into an executable application.