Logo Triger – Ozel Kodu Projeye Aktaran Triger

// **   FATURA SATIR UPDATE - OZELKODU PROJEYE ATAMAK  ** //
--DROP TRIGGER TRG_PROJESATIRUPDATE
CREATE TRIGGER TRG_PROJESATIRUPDATE
   ON LG_001_01_STLINE
   AFTER INSERT, UPDATE ,DELETE
AS
BEGIN
     DECLARE @REF [int] 
     DECLARE @OZELKOD VARCHAR(25)
	 DECLARE @PROJE [int]
   
	 SET @REF=(SELECT LOGICALREF "REF" FROM  INSERTED)
     SET @OZELKOD=(SELECT SPECODE FROM  INSERTED)
     SET @PROJE=(SELECT (SELECT LOGICALREF FROM LG_001_PROJECT WHERE CODE=@OZELKOD) FROM INSERTED)
  

         UPDATE LG_001_01_STLINE SET PROJECTREF=@PROJE WHERE LOGICALREF=@REF
END

// ** FATURA UPDATE -- OZELKODU PROJEYE ATAMAK ** //

--DROP TRIGGER TRG_PROJEUPDATE
CREATE TRIGGER TRG_PROJEUPDATE
   ON LG_001_01_INVOICE
   AFTER INSERT, UPDATE
AS
BEGIN
     DECLARE @REF [int] 
     DECLARE @OZELKOD VARCHAR(25)
	 DECLARE @PROJE [int]
   
	 SET @REF=(SELECT LOGICALREF "REF" FROM  INSERTED)
     SET @OZELKOD=(SELECT SPECODE FROM  INSERTED)
     SET @PROJE=(SELECT (SELECT LOGICALREF FROM LG_001_PROJECT WHERE CODE=@OZELKOD) FROM INSERTED)
  

         UPDATE LG_001_01_INVOICE SET PROJECTREF=@PROJE WHERE LOGICALREF=@REF
END


// **   ÖZEL KOD KONTROLÜ   ** //
--DROP TRIGGER ozelkodKontrol
CREATE TRIGGER ozelkodKontrol
   ON LG_001_01_INVOICE
   AFTER INSERT, UPDATE
AS
BEGIN
     DECLARE @specode VARCHAR(25)
     set @specode =''

     SELECT @specode = specode
     FROM inserted
    
     IF @specode = ''
     BEGIN
         RAISERROR('ÖZEL KOD GÝRÝLMELÝDÝR!', 16, 1)
         ROLLBACK
     RETURN
     END
END