. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 544 11.13. NEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . although it is not recommended. From time to time, non-reserved keywords may become reserved when some new language feature is introduced. For instance, the following statement will be executed without errors type.  Dialect 1 DATE data can be defined alternatively as TIMESTAMP and this is recommended for new definitions in Dialect 1 databases. Fractions of Seconds If fractions of seconds are stored in date

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 376 9.11. NEW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Rene Lobsiger (Switzerland) Hian Pin Tjioe Xavier Codina Mick Arundell (Australia) Russell Belding (New Zealand) Anticlei Scheid (Brazil) Luca Minuti (Italy) Mark Rotteveel (Netherlands) Chris Mathews (U Busto Criado Istvan Szabo Spiridon Pavlovic J. L. Garcia Naranjo A. Morales Morales Helen Cullen (New Zealand) Francisco Ibarra Ozuna Chapter 1. About the Firebird SQL Language Reference: for Firebird

..................................................................... 340 Контекстные переменные NEW и OLD ............................................................... 340 Триггеры на события базы ............................................................................................. 396 NEW .................................................................................................. (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) VALUES (973, 8804, DATE 'today' + 2, TIME '16:00'); -- 3 NEW.LASTMOD = TIMESTAMP 'now'; Примечание Обратите внимание, что эти

contributed to the manual. Chapter 1. Introduction 2 Chapter 2. Database Structure When you create a new database, be it single or multiple file, a number of things happen: • The database file(s) are created; the system tables and indices. New pages will be added to the end of the database file(s) as and when the user creates new tables and/or indices. For example, a brand-new database, created on a 32-bit checksum. From Firebird 3.0, it is possible that this field in the page header will probably have a new name and function. pag_generation Four bytes, unsigned. Bytes 0x04 - 0x07. The page generation number

. 26 11.1.1. Preventing New Connections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 11.1.2. Preventing New Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 11.3. New Startup and Shutdown States in Firebird 2.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . are: -ac(tivate_shadow) activate shadow file for database usage -at(tach) shutdown new database attachments -b(uffers) set page buffers -co(mmit) commit transaction

You must make sure that you restore the security database to have a page size of at least 4 Kb. The new security2.fdb will not work with a smaller page size. Warning A simple 'cp security.fdb security2 to adjust your view trigger code in order to make the update happen at all. New Reserved Words (Keywords) A number of new reserved keywords are introduced. The full list is available in a chapter of its double-quotes. In a Dialect 1 database there is no way to retain them: they must be redefined with new, legal words. (V.2.1) Malformed UTF8 strings and text blobs are no longer allowed. This affects not

CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION CURRENT_USER DELETING GDSCODE INSERTING NEW 'NOW' OLD ROW_COUNT SQLCODE SQLSTATE UPDATING 12. Операторы и предикаты Разрешено использование (EMPLOYEE_ID, CLIENT_ID, APP_DATE, APP_TIME) VALUES (973, 8804, DATE 'today' + 2, TIME '16:00') NEW.LASTMOD = TIMESTAMP 'now'; Примечание: Обратите внимание, что эти сокращённые выражения вычисляются FUNCTION funcname [] ::= ENTRY_POINT 'new-entry-point' MODULE_NAME 'new-module-name' Пример: ALTER EXTERNAL FUNCTION PHI MODULE_NAME 'NewUdfLib' 56 Руководство

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 4.2. Adding New Users. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 5.2. Adding New Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . user details from version 2.0 of Firebird. They can, however, change their own passwords with the new version. Previously the SYSDBA had to make the changes on behalf of the users.  It is possible

the database owner, however, if the -c(reate) switch is used, any validated username can create a new database from a backup file. Chapter 2. Command-line Options 3 -V[ERIFY] Normally gbak operates restore. From Firebird 2.5 onwards, there is a new -? switch to display the list of valid options. The output has slightly different layout and a couple of new options have been added: gbak:legal switches will overwrite the previous setting for the cache size. -C[REATE_DATABASE] This switch causes a new database to be created from the backup file. The database file must not exist or the restore will

( MyField = NULL ) then…”, and so on. However, as a general rule you should not make use of these new possibilities! In almost every thinkable situation, such use of NULL literals is a sign of poor SQL 2, they treat NULL as the value 0: • FIRST • SKIP This new Firebird 2 directive returns an empty set if any argument is NULL: • ROWS In new code, use ROWS, not FIRST and SKIP. Chapter 4. Internal constraints 35 ) If your scripts and/or databases should function consistently under both old and new Firebird versions, make sure that no CHECK constraint can ever resolve to NULL. Add “or … is null”