{"id":761,"date":"2015-02-17T17:10:22","date_gmt":"2015-02-17T15:10:22","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=761"},"modified":"2015-10-16T17:38:38","modified_gmt":"2015-10-16T14:38:38","slug":"mikro-eski-tip-formlarda-sql-sorgu-cumleleri-yazmak","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/mikro-eski-tip-formlarda-sql-sorgu-cumleleri-yazmak\/","title":{"rendered":"Mikro Eski tip formlarda SQL sorgu c\u00fcmleleri yazmak"},"content":{"rendered":"<h3 class=\"post-title entry-title\"><\/h3>\n<div id=\"post-body-8219099017607037006\" class=\"post-body entry-content\">Mikro ile form tasar\u0131m ekranlar\u0131na SQL sorgu c\u00fcmleleri ile istenen alanlar\u0131n eklenebilmesi.<\/p>\n<p>Evraklar \u00fczerinde ALT+F tu\u015flar\u0131 ile ula\u015f\u0131lan form tasar\u0131m ekranlar\u0131m\u0131z\u0131n statik ve dinamik alanlar\u0131na SQL sorgusu ile istenilen bilginin yazd\u0131r\u0131lmas\u0131 sa\u011flanm\u0131\u015ft\u0131r. B\u00f6ylece kullan\u0131c\u0131lar\u0131m\u0131z herhangi bir m\u00fcdahaleye gerek duymadan evrak dizaynlar\u0131nda yazacaklar\u0131 sorgular ile eri\u015febildikleri t\u00fcm alanlara ait bilgileri kullanarak d\u00f6k\u00fcm alabileceklerdir. \u00d6ncelikle belirtmek isteriz ki bu d\u00fczenleme sadece yeni tip form tasar\u0131m ekranlar\u0131m\u0131z i\u00e7in ge\u00e7erlidir. Bu ama\u00e7la tasar\u0131m ekran\u0131n\u0131n \u00fcst b\u00f6l\u00fcm\u00fcnde yer alan parametreler men\u00fcs\u00fcne Dinamik sorgu d\u00fczenle\u201d ve \u201cStatik sorgu d\u00fczenle\u201d se\u00e7enekleri eklenmi\u015ftir. Bu a\u015famada yap\u0131lmas\u0131 gereken hangi alana sorgu c\u00fcmlesi ile bilgi yaz\u0131lacak ise \u00f6ncelikle ilgili se\u00e7ene\u011fin se\u00e7ilmesi, a\u00e7\u0131lacak ekrana kullan\u0131lacak bilgiye ait sorgunun yaz\u0131lmas\u0131d\u0131r. Bu ekranlarda parametre olarak \u015fimdilik @SNO ve @DNO alanlar\u0131 kullan\u0131labilecektir.<\/p><\/div>\n<div class=\"post-body entry-content\"><\/div>\n<div class=\"post-body entry-content\"><\/div>\n<p><!--more--><\/p>\n<div class=\"post-body entry-content\">\n<p>@SNO\u00a0 &#8211; Statik alandaki kayd\u0131n record numaras\u0131.<br \/>\n@DNO &#8211; Dinamik alandaki kayd\u0131n record numaras\u0131n\u0131 ifade etmektedir.<\/p>\n<p>Bu parametreler yaz\u0131lan sorgunun where k\u0131sm\u0131nda mutlaka kullan\u0131lmal\u0131 ve sorgunun do\u011fru kayda ait oldu\u011fu garantilenmelidir.<\/p>\n<p>Unutmamal\u0131s\u0131n\u0131z ki;<\/p>\n<p>Statik sorgu, form d\u00f6k\u00fcl\u00fcrken bir kez \u00e7al\u0131\u015fmaktad\u0131r ve gelen bilgiler form \u00fczerinde her yerde kullan\u0131labilir. Dinamik sorgu ise her bir hareket sat\u0131r\u0131 i\u00e7in \u00e7al\u0131\u015fmaktad\u0131r.<\/p>\n<p>B\u00f6ylece kullan\u0131c\u0131lar\u0131m\u0131z yazacaklar\u0131 sorgular sayesinde \u00f6rne\u011fin beden detayl\u0131 olarak takibini yapt\u0131klar\u0131 stoklar\u0131n, fatura evrak\u0131ndan girmi\u015f olduklar\u0131 beden detaylar\u0131n\u0131n yazd\u0131r\u0131lmas\u0131n\u0131 sa\u011flayabileceklerdir.\u00a0 Dinamik sorgu d\u00fczenle se\u00e7ene\u011fi ile sorgusunu yaz\u0131p data ba\u011flant\u0131s\u0131n\u0131 yapacak ve detay sat\u0131rlar\u0131n\u0131n hemen alt\u0131nda beden bilgilerinin yaz\u0131lmas\u0131n\u0131 sa\u011flayabileceklerdir. Ayn\u0131 \u015fekilde faturadan girilmi\u015f stoklar\u0131n ana sa\u011flay\u0131c\u0131s\u0131na ait cep numaras\u0131n\u0131n d\u00f6k\u00fclmesini de sa\u011flayabileceklerdir. Bu \u00f6rnekleri evrak baz\u0131nda \u00e7o\u011faltabilmemiz m\u00fcmk\u00fcnd\u00fcr.<\/p>\n<p>\u015eimdi bir \u00f6rnekle ne yapman\u0131z gerekti\u011fini anlatal\u0131m.<\/p>\n<p>Mesela faturan\u0131zdaki renk-beden detayl\u0131 stoklar\u0131n\u0131z\u0131n k\u0131r\u0131l\u0131m miktarlar\u0131n\u0131 listelemek istedi\u011finizi d\u00fc\u015f\u00fcnelim. Bunun i\u00e7in,<\/p>\n<p>\u2219\u00a0\u00a0 \u00a0Yeni tip evrak tasar\u0131m formundaki Program men\u00fcs\u00fcndeki \u201cDinamik sorgu d\u00fczenle\u201d se\u00e7ene\u011fini \u00e7al\u0131\u015ft\u0131rarak kar\u015f\u0131n\u0131za \u00e7\u0131kan ekranda a\u015fa\u011f\u0131daki sorguyu yaz\u0131p, form tasar\u0131m\u0131n\u0131 kaydetmelisiniz.<\/p>\n<p>SELECT * FROM dbo.BEDEN_HAREKETLERI WHERE BdnHar_DRECid_RECno=@DNO<\/p>\n<p>\u2219\u00a0\u00a0 \u00a0Daha sonra ekran\u0131n\u0131z\u0131n sol taraf\u0131nda yer alan b\u00f6l\u00fcmden \u201cDinamik_sorgu_alanlar\u0131\u201d se\u00e7ene\u011fini i\u015faretleyip dizayn\u0131n\u0131z\u0131 olu\u015fturmal\u0131s\u0131n\u0131z. B\u00f6ylece Alt+K ile d\u00f6k\u00fcm\u00fc almak istedi\u011finizde yazd\u0131\u011f\u0131n\u0131z sorgunun d\u00f6k\u00fcm\u00fcn\u00fc alabileceksiniz. Yani verdi\u011fimiz \u00f6rne\u011fe g\u00f6re faturadaki renk-beden detayl\u0131 stoklar\u0131n k\u0131r\u0131l\u0131mlar\u0131na g\u00f6re miktarlar\u0131 d\u00f6k\u00fclecektir.<\/p>\n<p>Di\u011fer tablolarla ili\u015fki kurarak istedi\u011finiz ortak verileri getirebilirsiniz.<\/p>\n<p>SELECT MAX(dbo.fn_KurBul(cha_tarihi,sip_doviz_cinsi,1)) AS [Sipari\u015fin Faturala\u015fma D\u00f6viz Kuru]<br \/>\nFROM dbo.CARI_HESAP_HAREKETLERI WITH(NOLOCK)<br \/>\nLEFT OUTER JOIN dbo.STOK_HAREKETLERI WITH(NOLOCK) ON(cha_RECid_DBCno=sth_fat_recid_dbcno AND cha_RECid_RECno=sth_fat_recid_recno)<br \/>\nLEFT OUTER JOIN dbo.SIPARISLER WITH(NOLOCK) ON(sth_sip_recid_dbcno=sip_RECid_DBCno AND sth_sip_recid_recno=sip_RECid_RECno)<br \/>\nWHERE cha_RECno=@SNO<\/p><\/div>\n<p><!--more--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mikro ile form tasar\u0131m ekranlar\u0131na SQL sorgu c\u00fcmleleri ile istenen alanlar\u0131n eklenebilmesi. Evraklar \u00fczerinde ALT+F tu\u015flar\u0131 ile ula\u015f\u0131lan form tasar\u0131m ekranlar\u0131m\u0131z\u0131n statik ve dinamik alanlar\u0131na SQL sorgusu ile istenilen bilginin yazd\u0131r\u0131lmas\u0131 sa\u011flanm\u0131\u015ft\u0131r. B\u00f6ylece kullan\u0131c\u0131lar\u0131m\u0131z herhangi bir m\u00fcdahaleye gerek duymadan evrak dizaynlar\u0131nda yazacaklar\u0131 sorgular ile eri\u015febildikleri t\u00fcm alanlara ait bilgileri kullanarak d\u00f6k\u00fcm alabileceklerdir. \u00d6ncelikle belirtmek isteriz [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-761","post","type-post","status-publish","format-standard","hentry","category-mikro-yazilimevi"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/761","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=761"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/761\/revisions"}],"predecessor-version":[{"id":762,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/761\/revisions\/762"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}