Embedded SQL Guide

From InterBase
Jump to: navigation, search

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.
Personal tools