This document does not cover configuration of Firebird, Firebird command-line tools, nor its programming APIs. 1.2. Authorship For the Firebird 4.0 version, the Firebird 3.0 Language Reference was taken supported by Firebird gpre, the application which allows you to embed SQL constructs into your host programming language (C, C++, Pascal, Cobol, etc.) and preprocess those embedded constructs into the proper types of names are valid as identifiers: regular names, similar to variable names in regular programming languages, and delimited names that are specific to SQL. To be valid, each type of identifier

the data manipulation language (DML) employed for queries and the PSQL used for server-based programming. The leader of the Firebird Project’s documentation team, Paul Vinkenoog, took up the cause for supported by Firebird gpre, the application which allows you to embed SQL constructs into your host programming language (C, C++, Pascal, Cobol, etc.) and preprocess those embedded constructs into the proper SQL Language Structure 19 identifiers: regular names, similar to variable names in regular programming languages, and delimited names that are specific to SQL. To be valid, each type of identifier

data are written to disk immediately upon posting. It is possible to configure a database to use asynchronous data writes – whereby modified or new data are held in the memory cache for periodic flushing

created with Interbase 6 or an early beta version of Firebird, then the database will be running in asynchronous mode — which is not ideal. Chapter 14. Database Write Mode 35 Chapter 15. Close Database Ignoring

are written to disk immediately upon posting. It is possible to configure a database to use asynchronous data writes — whereby modified or new data are held in the memory cache for periodic flushing

data are written to disk immediately upon posting. It is possible to configure a database to use asynchronous data writes – whereby modified or new data are held in the memory cache for periodic flushing

value to compute “X or true” and “X and false” is also the basis of a feature found in various programming languages: short-circuit boolean evaluation. The above results can be generalised as follows for in Firebird PSQL have a totally different function than WHILE loops, or for loops in general programming languages. Firebird FOR loops have the form: Chapter 9. Conditional statements and loops 31

The language you use when you, as a client, talk to a Firebird server. • PSQL — The server-side programming language used in Firebird stored procedures and triggers. 3.2.1. Creating a generator (“Insert”)

13. Isql Prompts 25 Chapter 14. Error Handling And Exception Support Exception handling is a programming construct designed to handle an occurrence that disrupts the normal execution of a program. These

is in use -532 335545003 transaction_in_use Transaction is in use -532 335545017 async_active Asynchronous call is already running for this attachment -551 335544352 no_priv no permission for @1 access