. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 398 7.7.22. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . START_DAY IS NOT DISTINCT FROM END_DAY; -- PSQL fragment IF (NEW.JOB IS DISTINCT FROM OLD.JOB) THEN POST_EVENT 'JOB_CHANGED'; See also IS [NOT] NULL, Boolean IS [NOT] Boolean IS [NOT] Available in DSQL, PSQL executed when a specified event occurs in the associated table or view. A DML trigger is specific to one and only one relation (table or view) and one phase in the timing of the event (BEFORE or AFTER). It

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 7.6.17. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . executed when a specified event occurs in the associated table or view. A trigger is specific to one and only one relation (table or view) and one phase in the timing of the event (BEFORE or AFTER). It can can be specified to execute for one specific event (insert, update, delete) or for some combination of two or three of those events. Another form of trigger — known as a “database trigger” — can be

TRANSACTION ............................................................................. 379 POST_EVENT ................................................................................................. 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 Доступно в: DSQL [POSITION number] ON {tablename | viewname} ::= [ACTIVE | INACTIVE] ON db_event [POSITION number] ::= [ACTIVE | INACTIVE] {BEFORE | AFTER}

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 386 7.7.21. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 in ::= [ACTIVE | INACTIVE] ON event> [POSITION number] ::= [ACTIVE | INACTIVE] {BEFORE | AFTER} event> [POSITION number] ::=

Reference to "current of " outside scope of loop In Firebird 1.5 and earlier, referring to "current of " outside the scope of the cursor loop was accepted by the PSQL parser, allowing the likelihood typedef void (*ISC_EVENT_CALLBACK) (void*, ISC_USHORT, const ISC_UCHAR*); ISC_STATUS isc_que_events( ISC_STATUS*, isc_db_handle*, ISC_LONG*, short, const ISC_SCHAR*, ISC_EVENT_CALLBACK, void*); void*); It may cause a compile-time incompatibility, as older event handling programs cannot be compiled if they use a bit different signature for a callback routine (e.g., void* instead of const

BUFFER, CHECK_POINT_LENGTH, COMPILETIME, CONTINUE, DB_KEY, DEBUG, DESCRIBE, DISPLAY, ECHO, EDIT, EVENT, EXTERN, FOUND, GOTO, GROUP_COMMIT_, HELP, IMMEDIATE, INDICATOR, INIT, INPUT, ISQL, LC_MESSAGES, LC_TYPE Руководство по языку SQL CHECK_POINT_LENGTH COMPILETIME CONTINUE DB_KEY DEBUG DESCRIBE DISPLAY ECHO EDIT EVENT EXTERN FOUND GOTO GROUP_COMMIT_ GROUP_COMMIT_WAIT HELP IMMEDIATE INDICATOR INIT INPUT ISQL LC_MESSAGES ::= [ACTIVE | INACTIVE] ON db_event [POSITION number] ::= mutation [OR mutation [OR mutation]] mutation ::= INSERT | UPDATE | DELETE db_event ::= CONNECT | DISCONNECT | TRANSACTION

Guardian active for other platforms if a SYSDBA is not available to restart the server manually in the event that it is stopped for some reason. Windows 9x or ME On Windows 9x or ME Firebird server should Note It is possible to connect directly to a local Windows Superserver, without using the TCP/IP loop- back. This is not a TCP/IP connection and it is not a thread-safe way to connect to a local server

WHILE loops When evaluating the condition of a WHILE loop, NULL has the same effect as in an IF statement: if the condition resolves to NULL, the loop is not (re)entered — just as if it were false. Again Again, watch out with inversion using NOT: a condition like while ( Counter > 12 ) do will skip the loop block if Counter is NULL, which is probably what you want, but: while ( not Counter > 12 ) do will is encountered. Fetching a NULL, or even row after row filled with NULLs, does not terminate the loop! Chapter 9. Conditional statements and loops 32 Chapter 10. Keys and unique indices 10.1. Primary

database file, and the users are able to continue processing data as normal and without loss. In the event that your main database file(s) become corrupted or unreadable, the DBA can activate Chapter 4. Shadow maintenance  The DBA can set up the database to automatically create a new shadow file in the event of a current shadow being activated. This allows a continuous supply of shadow files and prevents -k[ill_shadow] database_name  Before Firebird 3, the command line switch was -⁠k[ill]. In the event that a database running with shadow files loses a shadow, or a shadow becomes unusable for some reason

-902 335544724 net_event_connect_err Failed to establish a secondary connection for event processing. -902 335544725 net_event_listen_err Error while listening for an incoming event connection request