. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.6. VIEW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 5.6.1. CREATE VIEW . . . 6.2. ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 5.6.3. CREATE OR ALTER VIEW . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Table of Contents 2 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.6. VIEW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129 5.6.1. CREATE VIEW . . . 6.2. ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 5.6.3. CREATE OR ALTER VIEW . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 3.5.2. Client-Zeichensatz. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.6. VIEW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150 5.6.1. CREATE VIEW . . . 6.2. ALTER VIEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 5.6.3. CREATE OR ALTER VIEW . . . . .

Connection Protocol with XNet .................................................................... 10 Client Impersonation No Longer Works .................................................................. ............................................................................................ 28 Client-only Installs .................................................................................. updatable via triggers no longer perform direct table operations In former versions, a naturally updatable view with triggers passed the DML operation to the underlying table and executed the triggers as well.

1.5 and higher. Chapter 1. Introduction 4 Chapter 2. Overview The isql utility is a text-mode client tool located in the bin directory of the Firebird installation. It provides a command line interface the DML in the script that caused the problem. When the server only indicates failure, users can view the first line of the statement that caused the failure, in relation to the entire script. This to extract the information to a specified output file. The resultant information can be used to view all the changes made to the database since its creation. Before making any more changes, create a

................ 143 VIEW ...................................................................................................................................... 144 CREATE VIEW ..................... ...................................................................................... 146 ALTER VIEW ................................................................................................. ............................................................................ 150 CREATE OR ALTER VIEW ........................................................................................... 150 Примеры

aggregate reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit transitional_date DATE must be changed to TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect does not support reference to datatype -104 335544798 depend_on_uncommitted_rel read-only table -150 335544362 read_only_view Cannot update read-only view -150 335544446 non_updatable Not updatable -150 335544546 constaint_on_view Cannot define constraints on views -151

aggregate reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit transitional_date DATE must be changed to TIMESTAMP -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect %d does not support reference to %s datatype -104 335544798 depend_on_uncommitted_rel of read-only table -150 335544362 read_only_view Cannot update read-only view %s -150 335544446 non_updatable Not updatable -150 335544546 constaint_on_view Cannot define constraints on views -151 335544359

aggregate reference -104 335544714 invalid_array_id Invalid blob id -104 335544730 cse_not_supported Client/Server Express not supported in this release -104 335544743 token_too_long Token size exceeds limit be changed to TIMESTAMP Firebird 2.1 Error Codes -104 335544796 sql_dialect_datatype_unsupport Client SQL dialect @1 does not support reference to @2 datatype -104 335544798 depend_on_uncommitted_rel of read-only table -150 335544362 read_only_view Cannot update read-only view @1 -150 335544446 non_updatable Not updatable -150 335544546 constaint_on_view Cannot define constraints on views -151 335544359

TRIGGER CREATE OR ALTER TRIGGER DROP TRIGGER RECREATE TRIGGER VIEW CREATE VIEW ALTER VIEW CREATE OR ALTER VIEW RECREATE VIEW 7. Операторы DML DELETE Использование COLLATE для столбцов с Список столбцов для представлений с оператором UNION теперь не обязателен • ALTER VIEW • CREATE OR ALTER VIEW 15 Руководство по языку SQL Язык обращения с данными (DML) Изменения начиная с Firebird SET AGECAT = 'Old' WHERE BIRTHDATE < DATE '1-Jan-1943' INSERT INTO APPOINTMENTS (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) VALUES (973, 8804, DATE 'today' + 2, TIME '16:00') NEW.LASTMOD = TIMESTAMP