"D:\Replicator_1_beta\Client\TEMPLATE.GDB"

BD_DETAIL

Descriptions

There is no desription for trigger BD_DETAIL

Definition

CREATE TRIGGER BD_DETAIL FOR DETAIL ACTIVE
BEFORE DELETE POSITION 32767
AS
DECLARE VARIABLE CURR_DB_ID INTEGER;
DECLARE VARIABLE REPL_COUNT INTEGER;
BEGIN
  /*
  Работает аналоги÷но BD_MASTER
  (в BD_MASTER более подробная документация)
  */

  SELECT DB_ID FROM CURR_DB_ID INTO :CURR_DB_ID;
  /**/
  SELECT COUNT( DB_ID ) FROM CURR_SERV INTO :REPL_COUNT;
  IF( REPL_COUNT = 0 )THEN/*not in receive*/
    BEGIN
      IF( OLD.DB_ID <> CURR_DB_ID )THEN EXCEPTION E_ACCESS_ERROR;/*Попытка удаления ÷ужой записи*/
    END
  ELSE
    IF( REPL_COUNT <> 1 )THEN EXCEPTION EINTERNAL_MULTIPLE_REPL;/*ASSERT(DEBUG)*/
  /**/
  UPDATE LOG_DETAIL
    SET   LOG_UPD_GEN = NULL
    WHERE
          LOG_GID = OLD.GID
      AND LOG_UPD_GEN IS NOT NULL;/*Доп. условие, ÷то бы избежать конфликта блокировок к SET_NEW_GEN*/
END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 11/13/2006 10:51 PM