Функции для работы с контекстными переменными ................................................ 406 RDB$GET_CONTEXT .......................................................................................... Операторы DDL 148 FROM goods JOIN price ON goods.code_goods = price.code_goods LEFT JOIN sp_get_balance(goods.code_goods) b ON 1 = 1; Пример 4.64. Создание обновляемого представления Во время работы DDL триггера доступно пространство имён DDL_TRIGGER для использования в функции RDB$GET_CONTEXT. Его использование также допустимо в хранимых процедурах и функциях, вызванных триггерами DDL

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); в фиктивную переменную и тем самым выиграть во времени её выполнения. Примечание Функции RDB$GET_CONTEXT и RDB$SET_CONTEXT хотя и классифицированы в этом руководстве как внутренние, фактически

idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle 20.2.0 You can even use the GraalVM JavaScript Engine in Java 11 to get rid of the warning messages. Since JLatexMath is bigger, you have to download it separately, then %function_exists("$some_function") true if the function has been defined %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve

idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle 20.2.0 You can even use the GraalVM JavaScript Engine in Java 11 to get rid of the warning messages. Since JLatexMath is bigger, you have to download it separately, then %function_exists("$some_function") true if the function has been defined %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve

NEW.my_number = GEN_ID(my_generator, 1); END Переход с MS SQL на Firebird 10 CREATE PROCEDURE get_my_generator RETURNS (new_value INTEGER) AS BEGIN new_value = GEN_ID(my_generator, 1); END Перенос authors /* Это вариант перевода в СУБД Firebird 1.0. */ /* Выделить оператор CASE. */ CREATE PROCEDURE get_state_name ( state_code char(2) ) RETURNS ( state_name varchar(64) ) AS BEGIN IF (state_code = 'CA') CHAR(2); BEGIN FOR SELECT state FROM authors INTO :short_state DO BEGIN EXECUTE PROCEDURE get_state_name :short_state RETURNING_VALUES :state; SUSPEND; END END Три замечания по приведенному

idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle 20.2.0 You can even use the GraalVM JavaScript Engine in Java 11 to get rid of the warning messages. Since JLatexMath is bigger, you have to download it separately, then %function_exists("$some_function") true if the function has been defined %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve

idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle 20.2.0 You can even use the GraalVM JavaScript Engine in Java 11 to get rid of the warning messages. Since JLatexMath is bigger, you have to download it separately, then %function_exists("$some_function") true if the function has been defined %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve

idle Client is idle @Client 0 is send Client -> Server@+25 : GET +25 is await +75 is recv +25 is idle +25 is send Client -> Server@+25 : GET\nIf-Modified-Since: 150 +25 is await +50 is recv +25 is idle 20.2.0 You can even use the GraalVM JavaScript Engine in Java 11 to get rid of the warning messages. Since JLatexMath is bigger, you have to download it separately, then %function_exists("$some_function") true if the function has been defined %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve

variable %set_variable_value("$my_variable", "some_value") An empty string %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve dir, rectangle, "A label") @enduml Notes When mixing sprites macros with other elements you may get a syntax error if, for example, trying to add a rectangle along with classes. In those cases, add {

variable %set_variable_value("$my_variable", "some_value") An empty string %get_variable_value Retrieve some variable value %get_variable_value("$my_variable") the value of the variable %getenv Retrieve dir, rectangle, "A label") @enduml Notes When mixing sprites macros with other elements you may get a syntax error if, for example, trying to add a rectangle along with classes. In those cases, add {