Embedded SQL Guide

From InterBase
Jump to: navigation, search

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.
Personal tools
Previous Releases: