Соединения с хранимыми процедурами ............................................................ 267 WHERE ................................................................................................. ............................................................................................ 306 WHERE ................................................................................................. ........................................................................................... 311 WHERE .................................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197 6.1.5. The WHERE clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241 6.3.3. The WHERE Clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249 6.5.2. WHERE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 6.1.5. The WHERE clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 324 6.3.3. The WHERE Clause . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331 Table of Contents 6 6.5.2. WHERE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

триггерах Подзапросы в выражениях PSQL UDF, вызываемые как пустые функции Разрешение использования WHERE CURRENT OF для курсоров представления 10. Безопасность и управление доступом к данным ALTER документирована. Синтаксис: datatype 'date/timestring' Пример: UPDATE PEOPLE SET AGECAT = 'Old' WHERE BIRTHDATE < DATE '1-Jan-1943' INSERT INTO APPOINTMENTS (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) использован мнемонический двоичный тип данных вместо целого. Примеры: SELECT NAMEBLOB FROM MYTABLE WHERE NAMEBLOB COLLATE PT_BR = 'Joậo' CREATE TABLE MYPICTURES ( ); ID INTEGER NOT NULL PRIMARY KEY, TITLE

only provide values for part of the fields, the remaining fields will be initialised to NULL except where a default value is in effect or a value is assigned by a “before insert” trigger. • If you add a if ( MyField is null ) then YourString = 'Dunno' select * from Pupils where PhoneNumber is not null select * from Pupils where not ( PhoneNumber is null ) /* does the same as the previous example */ 2. NULL support in Firebird SQL 6 update Numbers set Total = A + B + C where A + B + C is not null delete from Phonebook where PhoneNum is null Do not use “… = NULL” to test for nullness. This syntax

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 6.1.5. Die WHERE-Klausel. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 312 6.3.3. Die WHERE-Klausel. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318 6.5.2. WHERE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Other questions and queries that I had were very patiently answered on the Firebird Support forums where the developers hang out. Much hex dumping of database files was undertaken in the creation of this The Page Inventory Page (PIP). This page keeps track of allocated and free pages using a bitmap where a 1 means the page is free, and a 0 (zero) shows a used page. There may be more than one PIP in a file of a Firebird database is a very important page. It holds data that describes the database, where its other files are to be found, shadow file names, database page size, ODS version and so on. On

directory that Firebird was installed in, but some Linux distributions put it in /etc/firebird/n.n where n.n is the version of the Firebird database server. There is more information on connecting to databases to store records of commands to a script file. The TMP setting on a client can be used to control where these script files will be stored, if an absolute file path is not specified. Chapter 4. Command the database file. This has a disadvantage in that all clients will be able to determine exactly where the database is to be found, or, may cause problems when the database has to be moved. To alleviate

isc_dpb_user_name User name SYSDBA isc_dpb_password User password masterkey Server Generic response — where the Object handle is the database handle. 3.2. Detach Detaches from the database. After detach the Database path Buffer Database parameter buffer Chapter 3. Databases 8 Server Generic response — where the Object handle is the database handle. 3.4. Drop Drops the currently attached database. Client larger than necessary size does not inflate the response on the wire. Server Generic response — where Data holds the requested information. Chapter 3. Databases 9 3.6. Disconnect Client Int32 Operation

leave it defined to point to the root directory of a v.1.5.x installation, there will be situations where the Firebird engine, command-line tools, cron scripts, batch files, installers, etc., will not work also check that the old value is no longer Known Compatibility Issues 2 visible in the workspace where you are installing Firebird--use the SET FIREBIRD command in a Windows shell or printenv FIREBIRD updating table: UPDATE TableA SET FieldA = (SELECT SUM(A.FieldB) FROM TableA A WHERE A.FieldID = TableA.FieldID) Note Although it is possible in Firebird to provide an alias