Virg\u00fcll\u00fc say\u0131lar\u0131n virg\u00fclden sonraki hane say\u0131s\u0131n\u0131 s\u0131n\u0131rlamak isteyebiliriz. Bu i\u015fi iki farkl\u0131 \u015fekilde yapabiliriz. Rapor sorgusu i\u00e7erisinde yapmak i\u00e7in SQL Round fonksiyonunu kullanabiliriz. A\u015fa\u011f\u0131daki \u00f6rnek sorguya bak\u0131n\u0131z.<\/p>\n
SELECT [DateTime],Round([Tag_1],1) As Tag_1,Round([Tag_2],2) As Tag_2 FROM Table1<\/p>\n
Bu sorguda Tag_1 virg\u00fclden sonra bir hane, Tag_2 virg\u00fclden sonra iki hane olarak raporda g\u00f6r\u00fcn\u00fcr.<\/p>\n
Di\u011fer bir y\u00f6ntem ise Tag de\u011feri database’e kaydedilmeden \u00f6nce virg\u00fclden sonraki k\u0131sm\u0131n\u0131n s\u0131n\u0131rland\u0131r\u0131lmas\u0131d\u0131r. E\u011fer bu tag Plc’den virg\u00fcll\u00fc say\u0131 olarak okunuyorsa i\u015flem plc i\u00e7erisinde yap\u0131lmal\u0131d\u0131r. Plc i\u00e7erisinde yapam\u0131yorsan\u0131z WinTr SCADA’da bulunan SCALE komutunu kullanabilirsiniz.<\/p>\n
Virg\u00fclden sonras\u0131n\u0131 k\u0131s\u0131tlamak istedi\u011finiz Tag’\u0131 Connection Manager sayfas\u0131nda Registered Tag List sekmesinde bulun. \u00dczerinde sa\u011f klik ile a\u00e7\u0131lan men\u00fcde Scale -> Set’e t\u0131klay\u0131n. Sol b\u00f6l\u00fcm input ve sa\u011f b\u00f6l\u00fcm Output olarak g\u00f6receksiniz. Amac\u0131m\u0131z tag’\u0131 \u00f6l\u00e7eklendirmek olmad\u0131\u011f\u0131ndan Input ve output b\u00f6l\u00fcmlerindeki Min. ve Max. de\u011ferlerini e\u015fit girelim(Min=0, Max=100). Output b\u00f6l\u00fcm\u00fcnde decimal place ile birg\u00fclden sonraki hane say\u0131s\u0131 s\u0131n\u0131rland\u0131r\u0131l\u0131r. Scale komutu ile Input tag\u0131n\u0131n bir kopyas\u0131 olu\u015fturulur. Scada sayfalar\u0131nda yeni olu\u015fturulan tag’\u0131 kullanmal\u0131s\u0131n\u0131z. Bu taglar internal olup lisans tag say\u0131s\u0131n\u0131 eksiltmez.<\/p>\n","protected":false},"excerpt":{"rendered":"
Virg\u00fcll\u00fc say\u0131lar\u0131n virg\u00fclden sonraki hane say\u0131s\u0131n\u0131 s\u0131n\u0131rlamak isteyebiliriz. Bu i\u015fi iki farkl\u0131 \u015fekilde yapabiliriz. Rapor sorgusu i\u00e7erisinde yapmak i\u00e7in SQL Round fonksiyonunu kullanabiliriz. A\u015fa\u011f\u0131daki \u00f6rnek sorguya bak\u0131n\u0131z. SELECT [DateTime],Round([Tag_1],1) As Tag_1,Round([Tag_2],2) As Tag_2 FROM Table1 Bu sorguda Tag_1 virg\u00fclden sonra bir hane, Tag_2 virg\u00fclden sonra iki hane olarak raporda g\u00f6r\u00fcn\u00fcr. Di\u011fer bir y\u00f6ntem ise Tag […]<\/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":[332,363,152,362,361],"class_list":["post-859","post","type-post","status-publish","format-standard","hentry","category-scada-report","tag-rapor","tag-scale","tag-skala","tag-virgullu-sayilar","tag-yuvarlama"],"yoast_head":"\n