{"id":351,"date":"2014-09-18T10:08:15","date_gmt":"2014-09-18T07:08:15","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=351"},"modified":"2015-10-16T17:43:16","modified_gmt":"2015-10-16T14:43:16","slug":"iade-edilen-satirlar-silinemez-uyarisi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/iade-edilen-satirlar-silinemez-uyarisi\/","title":{"rendered":"\u0130ade Edilen Sat\u0131rlar Silinemez Uyar\u0131s\u0131"},"content":{"rendered":"<p>betuld CLONE &#8211; \u0130ade E-Fatura Kaydedildi\u011finde Sistemde Mevcut T\u00fcm Fi\u015flerin RETAMOUNT alan\u0131na Bilgi Yaz\u0131yor Ve Fi\u015fte De\u011f\u015fiklik Yapmak veya Sat\u0131r Silinmek \u0130stendi\u011finde \u0130ade Edilen Sat\u0131rlar Silinemez Uyar\u0131s\u0131 Veriyor<\/p>\n<p><!--more--><\/p>\n<p>Hatal\u0131 olan sat\u0131rlar\u0131 d\u00fczelmek i\u00e7in a\u015fa\u011f\u0131daki sorgular \u00e7al\u0131\u015ft\u0131r\u0131n\u0131z. \u0130\u015flem \u00f6ncesi yedek al\u0131n\u0131z. SELECT * FROM LG_500_02_STLINE WHERE RETAMOUNT&gt;0 AND LOGICALREF NOT IN (SELECT SOURCELINK FROM LG_500_02_STLINE WHERE SOURCELINK&gt;0) UPDATE LG_500_02_STLINE SET RETAMOUNT=0 WHERE RETAMOUNT&gt;0 AND LOGICALREF NOT IN (SELECT SOURCELINK FROM LG_500_02_STLINE WHERE SOURCELINK&gt;0)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>betuld CLONE &#8211; \u0130ade E-Fatura Kaydedildi\u011finde Sistemde Mevcut T\u00fcm Fi\u015flerin RETAMOUNT alan\u0131na Bilgi Yaz\u0131yor Ve Fi\u015fte De\u011f\u015fiklik Yapmak veya Sat\u0131r Silinmek \u0130stendi\u011finde \u0130ade Edilen Sat\u0131rlar Silinemez Uyar\u0131s\u0131 Veriyor<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-351","post","type-post","status-publish","format-standard","hentry","category-e-fatura"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/351","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=351"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/351\/revisions"}],"predecessor-version":[{"id":352,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/351\/revisions\/352"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}