SQL sorgular\u0131nda tek t\u0131rnak i\u015fareti kullanmak WinTr’de pek kolay de\u011fil. Zira WinTr Tag isimlerini t\u0131rnak ile alg\u0131l\u0131yor. Bunun yerine sorgunun tamam\u0131 veya bir k\u0131sm\u0131 Tag de\u011feri olarak ayarlanmal\u0131 ve soruda bu Tag kullan\u0131lmal\u0131.<\/p>\n
\u00d6rnek Sorgu:\u00a0SELECT Tag_1,IIF(Tag_1 = 0,’Kabul’,’Red’) as Tag_1 FROM TABLE1<\/p>\n
\u00d6rnek sorguda Tag_1 de\u011feri s\u0131f\u0131r oldu\u011funda Kabul, S\u0131f\u0131rdan farkl\u0131 oldu\u011funda Red yazd\u0131rmak istiyoruz. Fakat t\u0131rnak i\u015faretlerinden dolay\u0131 sorguyu derledi\u011fimizde a\u015fa\u011f\u0131daki sonucu al\u0131yoruz.<\/p>\n
SELECT Tag_1,IIF(Tag_1 = 0 ‘Tag not found’ ‘Tag not found’ \u00a0as Tag_1 FROM TABLE1<\/p>\n
\u00c7\u00fcnk\u00fc WinTr t\u0131rnak i\u015fareti i\u00e7ersindeki verileri Tag ismi olarak alg\u0131l\u0131yor. Kabul ve Red isminde taglar olmad\u0131\u011f\u0131 i\u00e7in de Tag bulunamad\u0131 hatas\u0131 veriyor.<\/p>\n
\u00c7\u00f6z\u00fcm i\u00e7in sorguyu bir tag i\u00e7ersine g\u00f6mmeliyiz. Internal bir tag olu\u015fturup ismini\u00a0Tag_SQLQuery tipini string olarak ayarlayal\u0131m. Bu tag’a bir kereye mahsus sorguyu yazmal\u0131y\u0131z. Ekrana bir Textbox koyup, value Tag’\u0131 olarak\u00a0Tag_SQLQuery tag\u0131n\u0131 se\u00e7ip runtime’\u0131 a\u00e7ar ve \u00f6rnek sorguyu yap\u0131\u015ft\u0131r\u0131p runtime kapat\u0131r\u0131z. Ekrandaki TextBox’\u0131 silebiliriz.\u00a0Tag_SQLQuery Tag’\u0131 i\u00e7erinde sorgu sonsuza kadar kalacakt\u0131r.<\/p>\n
Control Panelinden rapor mod\u00fcl\u00fcn\u00fc a\u00e7\u0131p sorgu alan\u0131na sadece ‘Tag_SQLQuery’ ifadesi ba\u015f\u0131nda bir bo\u015fluk b\u0131rakarak yaz\u0131l\u0131r. Sorgu derlendi\u011finde \u00f6rnek sorguyu al\u0131r\u0131z.<\/p>\n
Fakat sorgu sonunda Tarih veya ba\u015fka sebeplerden dolay\u0131 dinamikde\u011fi\u015fen bir sorguya ihtiyac\u0131m\u0131z olabilir. Bu durumda sorgunun tamam\u0131 yerine bir k\u0131sm\u0131n\u0131n Tag i\u00e7ersine g\u00f6m\u00fclmesi gerekir. Ayn\u0131 \u00f6rnek i\u00e7in problem \u00e7\u0131kartan k\u0131sm\u0131 yani\u00a0Kabul’,’Red ifadesini\u00a0Tag_SQLQuery tag\u0131na de\u011fer olarak verelim. Bu defa Control Panelinde a\u015fa\u011f\u0131daki sorguyu yazal\u0131m.<\/p>\n
SELECT Tag_2,IIF(Tag_2 = 0, ‘Tag_SQLQuery’ ) as W02 FROM TABLE1<\/p>\n
Dikkat edin\u00a0‘Tag_SQLQuery’ ifadesinin \u00f6n\u00fcnde ve arkas\u0131nda bir bo\u015fluk olmal\u0131. Bu sorgu derlendi\u011finde \u00f6rnek sorgumuzu elde ederiz. Bu \u015fekilde sorgu sonunda veya di\u011fer dinamik de\u011ferler de \u00e7al\u0131\u015fm\u0131\u015f olacakt\u0131r. Ayr\u0131ca Kabul, Red se\u00e7eneklerinin bulundu\u011fu di\u011fer sorgularda da ayn\u0131 Tag’\u0131 kullanabiliriz.<\/p>\n
Yaz\u0131 uzun oldu maalesef en kestirme yolu \u015fimdilik bu. A\u015fama a\u015fama yaz\u0131lanlar\u0131 anlamaya \u00e7al\u0131\u015f\u0131n bir kere \u00e7\u00f6zd\u00fc\u011f\u00fcn\u00fczde bir daha u\u011fra\u015fmayacaks\u0131n\u0131z.<\/p>\n","protected":false},"excerpt":{"rendered":"
SQL sorgular\u0131nda tek t\u0131rnak i\u015fareti kullanmak WinTr’de pek kolay de\u011fil. Zira WinTr Tag isimlerini t\u0131rnak ile alg\u0131l\u0131yor. Bunun yerine sorgunun tamam\u0131 veya bir k\u0131sm\u0131 Tag de\u011feri olarak ayarlanmal\u0131 ve soruda bu Tag kullan\u0131lmal\u0131. \u00d6rnek Sorgu:\u00a0SELECT Tag_1,IIF(Tag_1 = 0,’Kabul’,’Red’) as Tag_1 FROM TABLE1 \u00d6rnek sorguda Tag_1 de\u011feri s\u0131f\u0131r oldu\u011funda Kabul, S\u0131f\u0131rdan farkl\u0131 oldu\u011funda Red yazd\u0131rmak istiyoruz. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[341,332,340,339],"class_list":["post-831","post","type-post","status-publish","format-standard","hentry","category-scada-report","tag-cift-tirnak","tag-rapor","tag-tek-tirnak","tag-tirnak"],"yoast_head":"\n