AUTONOMOUS TRANSACTION ............................................................................. 379 POST_EVENT ........................................................................................... Функции для работы с контекстными переменными ................................................ 406 RDB$GET_CONTEXT .......................................................................................... FROM COURSES WHERE START_DAY IS NOT DISTINCT FROM END_DAY IF (NEW.JOB IS DISTINCT FROM OLD.JOB) THEN POST_EVENT 'JOB_CHANGED'; См. также: IS. IS Доступно

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 7.6.17. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 309 8.1.1. RDB$GET_CONTEXT() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . date literals without a time part, as well as 'TODAY', 'YESTERDAY' and 'TOMORROW' automatically get a zero time part. If, for some reason, it is important to you to store a Dialect 1 timestamp literal

NULLIF() OCTET_LENGTH() OVERLAY() PI() 8 Руководство по языку SQL POSITION() POWER() RAND() RDB$GET_CONTEXT() RDB$SET_CONTEXT() REPLACE() REVERSE() RIGHT() ROUND() RPAD() SIGN() SIN() SINH() SQRT() SUBSTRING() APP_NAME, SERVER_PID, PC_PID, DATE_START_CONNECT) VALUES ( CURRENT_USER, CURRENT_CONNECTION, RDB$GET_CONTEXT('SYSTEM', 'CLIENT_ADDRESS'), :REMOTE_PROTOCOL, :APP_NAME, :SERVER_PID, :PC_USER_PID, CURRENT_TIMESTAMP); TRANSACTION DO BEGIN INSERT INTO LOG ( MSG) VALUES ( 'USER ' || CURRENT_USER || ' REFUSED.'); POST_EVENT 'CONNECTION ATTEMPT' || ' BY BLOCKED USER!'; END -- теперь вызываем исключение: EXCEPTION

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 398 7.7.22. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 410 8.1.1. RDB$GET_CONTEXT() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 492 8.12.3. RDB$GET_TRANSACTION_CN() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 386 7.7.21. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 398 8.1.1. RDB$GET_CONTEXT() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . START_DAY IS NOT DISTINCT FROM END_DAY; -- PSQL-Fragment IF (NEW.JOB IS DISTINCT FROM OLD.JOB) THEN POST_EVENT 'JOB_CHANGED'; Siehe auch IS [NOT] NULL, Boolesches IS [NOT] Boolesches IS [NOT] Verfügbar

Firebird database. You can create one by giving it a name: CREATE GENERATOR GenTest; Then you can get its current value and increase or decrease it just like a “var i:integer” in Delphi, but it is not well as long as the values lie within the 32-bit range. But as soon as that range is exceeded, you get a numeric overflow error: dialect 3 is much stricter on range checking than dialect 1! 2.4.1. Client value, consider it as “gone forever”. When you start a transaction and then call a generator and get a value of — let’s say — 5, it will remain at that value even if you roll back the transaction (!)

....................................................................................... 22 How to get help ............................................................................................. matches this guide. This guide covers versions 1.0, 1.0.2 and 1. 0.3. If you run Firebird 1.5 or higher, get the appropriate version of the Quick Start Guide at http://www.firebirdsql.org/manual/ (HTML) or http://www substituting this example IP address for the IP address that your server is broadcasting. Warning If you get a timeout message, study the Using Firebird manual – Chapter 6: Network Configuration, and Chapter

....................................................................................... 29 How to get help ............................................................................................. Firebird version. This guide covers versions 2.0– 2.0.6 and 2.1–2.1.4. For all other Firebird versions, get the corresponding Quick Start Guide at http://www. firebirdsql.org/en/documentation/. Some warnings not even read-only. They query databases via the server, and the server makes sure that users only get the allowed type of access (if at all) to any objects within the database. Disable Classic local mode

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 8. How to get help. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . matches your Firebird version. This document covers Firebird 5. For all other Firebird versions, get the corresponding Quick Start Guide at https://www.firebirdsql.org/en/documentation/. Chapter 1. CURRENT USER, which always refers to the user you are logged in as. If the command succeeds, you won’t get any feedback. Instead, isql will just print the next “SQL>”- Chapter 5. Server configuration and management

trigger. • Assignments to NEW context variables in AFTER-triggers are also prohibited. Tip If you get an unexpected error Cannot update a read-only column then violation of one of these restrictions will you begin, even if you have been cheerfully running v.1.5 for years! And note, although you might get Firebird 2.x to install and run on Windows 95, 98 or ME, they are no longer supported platforms for the runtime assembly from the Microsoft redistributable is the easiest and thus the preferred way to get them on board. However, from Firebird 2.1.2 onward, it becomes possible to isolate the runtimes for