AUTONOMOUS TRANSACTION ............................................................................. 379 POST_EVENT ........................................................................................... 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 Доступно BEGIN INSERT INTO LOG(MSG) VALUES ('USER ' || CURRENT_USER || ' REFUSED.'); POST_EVENT 'CONNECTION ATTEMPT' || ' BY BLOCKED USER!'; END -- теперь вызываем исключение EXCEPTION

TRANSACTION DO BEGIN INSERT INTO LOG ( MSG) VALUES ( 'USER ' || CURRENT_USER || ' REFUSED.'); POST_EVENT 'CONNECTION ATTEMPT' || ' BY BLOCKED USER!'; END -- теперь вызываем исключение: EXCEPTION COURSES WHERE START_DAY IS NOT DISTINCT FROM END_DAY IF (NEW.JOB IS DISTINCT FROM OLD.JOB) THEN POST_EVENT 'JOB_CHANGED'; IS [NOT] DISTINCT FROM всегда возвращает TRUE или FALSE и никогда NULL (неизвестное NATURAL NCHAR NO NOT NULL NUMERIC OCTET_LENGTH OF ON ONLY OPEN OR ORDER OUTER PARAMETER PLAN POSITION POST_EVENT PRECISION PRIMARY PROCEDURE RDB$DB_KEY REAL RECORD_VERSION RECREATE RECURSIVE REFERENCES RELEASE

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299 7.6.17. POST_EVENT. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . REFUSED.'); POST_EVENT 'CONNECTION ATTEMPT' || ' BY BLOCKED USER!'; END -- now calling an exception EXCEPTION EX_BADUSER; END END See also Transsaction Control 7.6.17. POST_EVENT Used Statements 300 PSQL Syntax POST_EVENT event_name Table 94. POST_EVENT Statement Parameter Argument Description event_name Event name (message) limited to 127 bytes The POST_EVENT statement notifies the

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 REFUSED.'); POST_EVENT 'CONNECTION ATTEMPT BY BLOCKED USER!'; END -- now calling an exception EXCEPTION EX_BADUSER; END END See also Transaction Control 7.7.22. POST_EVENT Used for

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 REFUSED.'); POST_EVENT 'CONNECTION ATTEMPT BY BLOCKED USER!'; END -- now calling an exception EXCEPTION EX_BADUSER; END END Siehe auch Transaktionssteuerung 7.7.21. POST_EVENT Verwendet

column does not have the state NULL, but the value 0, so it would not generate a new ID. You could post the record, though — but only one… the second one would fail. It is anyway a good idea to “ban” 0 ID (because of the transaction issue). But if you get a new value from the generator before, and post the Insert with that value, you can simply fetch the row back with a “Select … where ID=genvalue”

However, user support questions are a distraction which they do not welcome. Please do not try to post your user support questions there! These belong in firebird-support@yahoogroups.com. Firebird 1.0

dll sur les clients Windows – correspondant à la version du serveur Firebird. Les versions 1.5 et postérieures de Firebird peuvent installer des liens symboliques ou des copies nommées comme pour les versions

However, user support questions are a distraction which they do not welcome. Please do not try to post your user support questions there! These belong in the firebird-support Google Group. Happy Firebirding

However, user support questions are a distraction which they do not welcome. Please do not try to post your user support questions there! These belong in the firebird-support group. Happy Firebirding