. . . . . . . . . . . . . . . . . . . . . . . . . . . 31 3.4.4. Operations Using Date and Time Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 3.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 6.2.1. INSERT … VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 6.2.3. INSERT … DEFAULT VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . 40 Table of Contents 2 3.4.6. Operations Using Date and Time Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 3.4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 316 6.2.1. INSERT … VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318 6.2.3. INSERT … DEFAULT VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

TYPE OF COLUMN в объявлениях параметров и переменных EXECUTE PROCEDURE INSERT INSERT ... DEFAULT VALUES Предложение RETURNING Разрешено использовать UNION в операторе SELECT при вставке MERGE SELECT 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 'now'; Примечание: Обратите WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ) INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832, 22, -56786237632476, 0X6F55A09D42, -- 478177959234 0X7FFFFFFFFFFFFFFF

................................................................................ 302 INSERT ... VALUES ................................................................................................ ......................................................................... 303 INSERT ... DEFAULT VALUES ..................................................................................... 304 RETURNING Пример 2.2. Использование целых чисел заданных шестнадцатеричном виде INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832, 22, -56786237632476, 0X6F55A09D42, -- 478177959234

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 5.2.1. Result values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 14.2. Converting values to NULL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ordering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 UDFs returning values when they should return NULL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 2.4.1. Client dialects and generator values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 4.3. Can you re-use generator values?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . word “sequence” puts the emphasis on the series of values generated whereas “generator” seems to refer primarily to the factory that produces these values, there is no difference at all between a Firebird

of the stat of transactions. Each transaction is represented by a pair of bits in a bitmap. Valid values in these two bits are: 00 this transaction is active. 01 this transaction is in limbo. 10 this used successfully on the current hardware. This avoids problems caused by little-endian numerical values as compared with big-endian, for example. hdr_ods_minor Two bytes, unsigned. Bytes 0x3e and 0x3f remainder of the page, is an array of two bit values where each pair of bits represents a transaction and its status. Each transaction can have one of 4 status values: 0x00 this transaction is active, or has

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305 6.2.1. INSERT … VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 307 6.2.3. INSERT … DEFAULT VALUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832, 22, -56786237632476, 0X6F55A09D42, -- 478177959234

display of performance statistics SET TIME -- toggle display of timestamp with DATE values SET TERM -- change statement terminator string SET WIDTH [] -- set/unset other delimited identifiers in Firebird. If username or password are not supplied, then the current values in the ISC_USER and ISC_PASSWORD environment variables are used instead. There is no environment name or IP address, port number, and path of the primary database file, or an alias. The following values can be specified as the protocol: INET TCP/IP (first tries to connect using the IPv6 protocol,

non-SQL security class defined -84 335544668 dsql_procedure_use_err Procedure @1 does not return any values -85 335544747 usrname_too_long The username entered is too long.Maximum length is 31 bytes. -85 of read-write columns does not equal count of values -804 335544586 dsql_function_err Function unknown -804 335544713 dsql_sqlda_value_err Incorrect values within SQLDA structure -804 336397205 dsql_too_old_ods procedure @1's BLR -901 335544877 key_too_big Index key too big -901 336397211 dsql_too_many_values Too many values (more than @1) in member list to match against Firebird 2.1 Error Codes -901 336397236