Triggers Previous topic Chapter index Next topic

CIERRES_BD0

 

Description

(There is no description for trigger CIERRES_BD0)

 

Definition

CREATE TRIGGER CIERRES_BD0 FOR CIERRES
ACTIVE BEFORE DELETE POSITION 0
AS
begin
  DELETE FROM comovi
  WHERE (tipo=OLD.tipo)
  AND (prefijo =OLD.prefijo)
  AND (numero = OLD.numero);


  DELETE FROM cocomp
  WHERE (tipo=OLD.tipo)
  AND (prefijo = OLD.prefijo)
  AND (numero = OLD.numero);
end

 

     Previous topic Chapter index Next topic