3.1. Rules for Regular Object Identifiers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 2.3.2. Rules for Delimited Object Identifiers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407 11.2.1. The Object Owner. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 517 Table of Contents 11 Appendix H: Document History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

3.1. Rules for Regular Object Identifiers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 2.3.2. Rules for Delimited Object Identifiers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 586 13.3.1. The Object Owner. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 773 Appendix I: Document History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

такими, как эти: SELECT AU.MAKE, AU.MODEL, AU.WEIGHT, AU.PRICE, AU.IN_STOCK FROM AUTOMOBILES AU WHERE (AU.MAKE = :MAKE OR :MAKE IS NULL) AND (AU.MODEL = :MODEL OR :MODEL IS NULL) AND (AU.PRICE <= :MAXPRICE состоит в том, что конечный пользователь может дополнительно ввести варианты для параметров :make, :model и :maxprice. Там, где сделан выбор, должен быть применен соответствующий фильтр. Везде, где :make, :model и :maxprice. существует только на уровне приложений. Прежде чем запрос передается серверу Firebird для подготовки, он должен быть преобразован в такую форму: SELECT AU.MAKE, AU.MODEL, AU.WEIGHT

Firebird 2.0 and 2.1 Quick Start Guide IBPhoenix Editors Firebird Project members 11 July 2011, document version 3.11 covers Firebird 2.0–2.0.6 and 2.1–2.1.4 2 Table of Contents About this guide .. ............................................................................... 31 Appendix A: Document History ....................................................................................... source code or parts of it. You may distribute such modified versions, but if you do so, you must document your modifications and make them publicly available, at no cost, under the same license as the original

Installation Helen Borrie (Collator/Editor) 19 June 2012 - Document v. mi215_01 - for Firebird 2.1.5 Firebird 2 Migration & Installation 19 June 2012 - Document v. mi215_01 - for Firebird 2.1.5 Helen Borrie (Collator/Editor) .......................................................................... 12 Choosing a Server Model ................................................................................................. have the ability to run services (Win9x, WinME). For detailed usage instructions, refer to the document README.instsvc in the doc directory of your Firebird installation. 12 Chapter 2 INSTALLATION NOTES

EXISTS. Например, следующий запрос: Общие элементы языка 84 SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker = 'A'); использованием предиката EXISTS: SELECT model, speed, hd FROM PC WHERE EXISTS (SELECT * FROM product WHERE maker = 'A' AND product.model = PC.model); существуют модели, производитель которых начинается на букву «A»: SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker STARTING WITH 'A'); См

Abfrage: SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker = 'A'); kann ersetzt werden mittels EXISTS-Prädikat: SELECT model, speed, hd FROM WHERE maker = 'A' Chapter 4. Allgemeine Sprachelemente 87 AND product.model = PC.model); Jedoch gilt zu beachten, dass eine Abfrage mittels NOT IN und einer Unterabfrage nicht immer Computer, die deren Hersteller mit dem Buchstaben “A” beginnt: SELECT model, speed, hd FROM PC WHERE model IN (SELECT model FROM product WHERE maker STARTING WITH 'A'); Siehe

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Appendix A: Document History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . a number of different locations, but the utilities are in /usr/bin. For the remainder of this document, the assumption will be that the utility is called isql. Chapter 2. Overview 5 Chapter 3. Invoking "C:\DATABASES\FIREBIRD\MY_EMPLOYEE.FDB" CON> user 'SYSDBA' password 'secret';  Here and elsewhere in this document, we use the ‘$’ to signify the command prompt, it is not part of the command to enter. For example

. . . . . . . . . . . . . . . . . . . 39 Table of Contents 2 Chapter 1. Introduction This document describes the Firebird wire protocol. Most of the information was obtained by studying the Firebird this document. Changes in later protocol versions are described in notes below the description of the relevant version 10 message (currently only version 11 is partially described). This document is not 2.1. Generic response Int32 Operation code If operation equals op_response: Int32 Object handle Int64 Object ID Buffer Data (meaning depends on the operation). Byte[] Status vector  Information

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Appendix B: Document history . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 Table of Contents 1 Chapter 1. Introduction The purpose of this document is to try to explain what goes on inside a Firebird database. Much of the information in this manual was undertaken in the creation of this document, but no Firebird databases were harmed during this process. All databases mentioned or described within this document are those with an ODS of 11.1 — in