{"id":458,"date":"2019-11-27T10:56:44","date_gmt":"2019-11-27T10:56:44","guid":{"rendered":"http:\/\/michalmoroz.info\/?p=458"},"modified":"2019-11-27T12:29:48","modified_gmt":"2019-11-27T12:29:48","slug":"skrypt-sql-c-d","status":"publish","type":"post","link":"http:\/\/michalmoroz.info\/?p=458","title":{"rendered":"Skrypt SQL&ndash;c.d."},"content":{"rendered":"<h4>Czyszczenie Wariant\u00f3w<\/h4>\n<p><i>Skrypt usuwa wszystkie sk\u0142adniki z wariant\u00f3w o okre\u015blonej nazwie<\/i><\/p>\n<p>delete from xpoSkladniki where ParentWariant in (select oid from xpoWarianty where Nazwa = 'Zaimportowany');<br \/>delete from xpoWarianty where Nazwa = 'Zaimportowany';<\/p>\n<h4>Usuwanie wariantu<\/h4>\n<p>Skrypt usuwa z sk\u0142adnik\u00f3w wszystkie warianty o wskazanej nazwie np. \u201eNowy\u201d<\/p>\n<p>delete from xpoWarianty where Nazwa = 'Nowy' or Nazwa like '%Nowy%';<\/p>\n<p><\/p>\n<h4>Usuwanie sk\u0142adnik\u00f3w, kt\u00f3re s\u0105 usuni\u0119te z systemu magazynowego<\/h4>\n<p>delete from xpoSkladniki where Skladnik in (select localid from xpoTowView where Usuniety = 1)<\/p>\n<p><\/p>\n<p><font size=\"1\">Skrypt dzia\u0142a na wszystkich wersjach Mozart Produkcja, czyli dal Subiekt GT, Subiekt Nexo Pro, enova i Navireo.<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Czyszczenie Wariant\u00f3w Skrypt usuwa wszystkie sk\u0142adniki z wariant\u00f3w o okre\u015blonej nazwie delete from xpoSkladniki where ParentWariant in (select oid from xpoWarianty where Nazwa = 'Zaimportowany');delete from xpoWarianty where Nazwa = 'Zaimportowany'; Usuwanie wariantu Skrypt usuwa z sk\u0142adnik\u00f3w wszystkie warianty o wskazanej nazwie np. \u201eNowy\u201d delete from xpoWarianty where Nazwa = 'Nowy' or Nazwa like '%Nowy%';&hellip; <a class=\"more-link\" href=\"http:\/\/michalmoroz.info\/?p=458\">Czytaj dalej <span class=\"screen-reader-text\">Skrypt SQL&ndash;c.d.<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[14,17,22,10,16],"_links":{"self":[{"href":"http:\/\/michalmoroz.info\/index.php?rest_route=\/wp\/v2\/posts\/458"}],"collection":[{"href":"http:\/\/michalmoroz.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/michalmoroz.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/michalmoroz.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/michalmoroz.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=458"}],"version-history":[{"count":2,"href":"http:\/\/michalmoroz.info\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions"}],"predecessor-version":[{"id":460,"href":"http:\/\/michalmoroz.info\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions\/460"}],"wp:attachment":[{"href":"http:\/\/michalmoroz.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/michalmoroz.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=458"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/michalmoroz.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}