{"id":1567,"date":"2015-01-27T13:41:09","date_gmt":"2015-01-27T11:41:09","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1567"},"modified":"2016-04-27T13:41:42","modified_gmt":"2016-04-27T10:41:42","slug":"logo-triger-ozel-kodu-projeye-aktaran-triger","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/logo-triger-ozel-kodu-projeye-aktaran-triger\/","title":{"rendered":"Logo Triger &#8211; Ozel Kodu Projeye Aktaran Triger"},"content":{"rendered":"<pre class=\"aLF-aPX-K0-aPE aLF-aPX-aLK-ayr-auR\">\/\/ **   FATURA SATIR UPDATE - OZELKODU PROJEYE ATAMAK  ** \/\/\r\n--DROP TRIGGER TRG_PROJESATIRUPDATE\r\nCREATE TRIGGER TRG_PROJESATIRUPDATE\r\n   ON LG_001_01_STLINE\r\n   AFTER INSERT, UPDATE ,DELETE\r\nAS\r\nBEGIN\r\n     DECLARE @REF [int] \r\n     DECLARE @OZELKOD VARCHAR(25)\r\n\t DECLARE @PROJE [int]\r\n   \r\n\t SET @REF=(SELECT LOGICALREF \"REF\" FROM  INSERTED)\r\n     SET @OZELKOD=(SELECT SPECODE FROM  INSERTED)\r\n     SET @PROJE=(SELECT (SELECT LOGICALREF FROM LG_001_PROJECT WHERE CODE=@OZELKOD) FROM INSERTED)\r\n  \r\n\r\n         UPDATE LG_001_01_STLINE SET PROJECTREF=@PROJE WHERE LOGICALREF=@REF\r\nEND\r\n\r\n\/\/ ** FATURA UPDATE -- OZELKODU PROJEYE ATAMAK ** \/\/\r\n\r\n--DROP TRIGGER TRG_PROJEUPDATE\r\nCREATE TRIGGER TRG_PROJEUPDATE\r\n   ON LG_001_01_INVOICE\r\n   AFTER INSERT, UPDATE\r\nAS\r\nBEGIN\r\n     DECLARE @REF [int] \r\n     DECLARE @OZELKOD VARCHAR(25)\r\n\t DECLARE @PROJE [int]\r\n   \r\n\t SET @REF=(SELECT LOGICALREF \"REF\" FROM  INSERTED)\r\n     SET @OZELKOD=(SELECT SPECODE FROM  INSERTED)\r\n     SET @PROJE=(SELECT (SELECT LOGICALREF FROM LG_001_PROJECT WHERE CODE=@OZELKOD) FROM INSERTED)\r\n  \r\n\r\n         UPDATE LG_001_01_INVOICE SET PROJECTREF=@PROJE WHERE LOGICALREF=@REF\r\nEND\r\n\r\n\r\n\/\/ **   \u00d6ZEL KOD KONTROL\u00dc   ** \/\/\r\n--DROP TRIGGER ozelkodKontrol\r\nCREATE TRIGGER ozelkodKontrol\r\n   ON LG_001_01_INVOICE\r\n   AFTER INSERT, UPDATE\r\nAS\r\nBEGIN\r\n     DECLARE @specode VARCHAR(25)\r\n     set @specode =''\r\n\r\n     SELECT @specode = specode\r\n     FROM inserted\r\n    \r\n     IF @specode = ''\r\n     BEGIN\r\n         RAISERROR('\u00d6ZEL KOD G\u00ddR\u00ddLMEL\u00ddD\u00ddR!', 16, 1)\r\n         ROLLBACK\r\n     RETURN\r\n     END\r\nEND\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/\/ ** FATURA SATIR UPDATE &#8211; OZELKODU PROJEYE ATAMAK ** \/\/ &#8211;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 &#8220;REF&#8221; FROM INSERTED) SET @OZELKOD=(SELECT SPECODE FROM INSERTED) SET @PROJE=(SELECT (SELECT LOGICALREF FROM LG_001_PROJECT WHERE CODE=@OZELKOD) FROM INSERTED) [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1567","post","type-post","status-publish","format-standard","hentry","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1567"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1567\/revisions"}],"predecessor-version":[{"id":1568,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1567\/revisions\/1568"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}