<?xml version="1.0" encoding="iso-8859-9" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="https://syndication.webwiz.net/rss_namespace/">
 <channel>
  <title>Clomosy | Forum : SQL de anlık veri</title>
  <link>https://www.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : SQL de anlık veri]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Tue, 14 Apr 2026 15:08:59 +0000</pubDate>
  <lastBuildDate>Tue, 15 Aug 2023 13:50:20 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.07</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://www.clomosy.com.tr/RSS_post_feed.asp?TID=562</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Clomosy | Forum]]></title>
   <url>https://www.clomosy.com.tr/forum_images/logo.png</url>
   <link>https://www.clomosy.com.tr/</link>
  </image>
  <item>
   <title><![CDATA[SQL de anlık veri : AddDataToListView metodunun sonuna...]]></title>
   <link>https://www.clomosy.com.tr/forum_posts.asp?TID=562&amp;PID=727#727</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://www.clomosy.com.tr/member_profile.asp?PF=133">Alforce</a><br /><strong>Konu:</strong> 562<br /><strong>Gönderim Zamanı:</strong> 15&nbsp;Ağustos&nbsp;2023 Saat 13:50<br /><br />AddDataToListView metodunun sonuna yazmanız gerkemez mi?<br><br>Kodunuzu tam bilmediğim için net bir cevap veremeyeceğim.<div>Umarım işinize yarar.<br><br><table width="99%"><tr><td><pre class="BBcode"><div><div style=": rgb251, 251, 253;">procedure AddDataToListview;</div><div style=": rgb251, 251, 253;">Var</div><div style=": rgb251, 251, 253;">&nbsp; foodListQuery : TClSqlQuery;</div><div style=": rgb251, 251, 253;">begin</div><div style=": rgb251, 251, 253;">&nbsp; foodListQuery := TClSqlQuery.Create(nil);</div><div style=": rgb251, 251, 253;">&nbsp; if (testRadio.isChecked) then&nbsp;</div><div style=": rgb251, 251, 253;">&nbsp; begin</div><div style=": rgb251, 251, 253;">&nbsp; try</div><div style=": rgb251, 251, 253;">&nbsp; ShowMessage(Clomosy.AppUserDisplayName);</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;foodListQuery.Connection := Clomosy.DBSQLServerConnection;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn1.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn2.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn3.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn4.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn5.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn6.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn8.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn9.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn11.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn12.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn14.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn16.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;isim := btn18.caption;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; // ShowMessage(isim);</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;foodListQuery.SQL.Text := 'update dbo.arsa set alan_kisi = '+quotedstr(Clomosy.AppUserDisplayName)+'</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;where isim = '+quotedstr(isim);</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;ShowMessage(foodListQuery.Sql.Text);&nbsp; &nbsp;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;foodListQuery.ExecSql;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;ShowMessage('Kayıt işlemi başarılı');</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;finally</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;foodListQuery.Close;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;foodListQuery.Free;</div><div style=": rgb251, 251, 253;">&nbsp; &nbsp; &nbsp;end;</div><div style=": rgb251, 251, 253;">&nbsp; end;</div><div style=": rgb251, 251, 253;">&nbsp; else begin</div><div style=": rgb251, 251, 253;">&nbsp; ShowMessage('Doğru giriniz');&nbsp;</div><div style=": rgb251, 251, 253;">&nbsp; end;</div><div style=": rgb251, 251, 253;">&nbsp;&nbsp;</div><div style=": rgb251, 251, 253;">&nbsp; LastSender:= MyForm.clSender;</div><div style=": rgb251, 251, 253;">end;</div><div></pre></td></tr></table></div></div></div>]]>
   </description>
   <pubDate>Tue, 15 Aug 2023 13:50:20 +0000</pubDate>
   <guid isPermaLink="true">https://www.clomosy.com.tr/forum_posts.asp?TID=562&amp;PID=727#727</guid>
  </item> 
  <item>
   <title><![CDATA[SQL de anlık veri : Benim kendi kodumda herhangi bir...]]></title>
   <link>https://www.clomosy.com.tr/forum_posts.asp?TID=562&amp;PID=726#726</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://www.clomosy.com.tr/member_profile.asp?PF=107">Zeren</a><br /><strong>Konu:</strong> 562<br /><strong>Gönderim Zamanı:</strong> 15&nbsp;Ağustos&nbsp;2023 Saat 13:30<br /><br /><div>Benim kendi kodumda herhangi bir ülkeye basıldığında Satın almak istiyor musun evet hayır seçenekleri geliyor eveti seçerse attığım kod devreye giriyor ve SQL de alınan ülkeye alan kişinin ismi düşüyor bu kısımda sıkıntı yok ancak hangi ülkeye basarsam basayım sadece İngiltere ülkesi alınıyor.Bu kodu her ülkenin procedüründe&nbsp;</div><div><div>LastSender:= MyForm.clSender;</div><div>MyForm.AddNewEvent(testButton,tbeOnClick,'AddDataToListview');</div><div>end;</div></div><div>kodu ile çağırdım ama neden sadece tek butonda çalıştığını anlayamadım.</div><div><br></div><div>procedure SetupSqlConnection;<div>begin</div><div>&nbsp; &nbsp;Clomosy.DBSQLServerConnect('SQL Server','192.168.2.64','sa','zeren93353','monopoly',50000);</div><div>end;</div><div><br></div><div><br></div><div>procedure AddDataToListview;</div><div>Var</div><div>&nbsp; foodListQuery : TClSqlQuery;</div><div>begin</div><div>&nbsp; foodListQuery := TClSqlQuery.Create(nil);</div><div>&nbsp; if (testRadio.isChecked) then&nbsp;</div><div>&nbsp; begin</div><div>&nbsp; try</div><div>&nbsp; ShowMessage(Clomosy.AppUserDisplayName);</div><div>&nbsp; &nbsp; &nbsp;foodListQuery.Connection := Clomosy.DBSQLServerConnection;</div><div>&nbsp; &nbsp; &nbsp;isim := btn1.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn2.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn3.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn4.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn5.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn6.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn8.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn9.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn11.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn12.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn14.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn16.caption;</div><div>&nbsp; &nbsp; &nbsp;isim := btn18.caption;</div><div>&nbsp; &nbsp; &nbsp;</div><div>&nbsp; &nbsp; // ShowMessage(isim);</div><div>&nbsp; &nbsp; &nbsp;foodListQuery.SQL.Text := 'update dbo.arsa set alan_kisi = '+quotedstr(Clomosy.AppUserDisplayName)+'</div><div>&nbsp; &nbsp; &nbsp;where isim = '+quotedstr(isim);</div><div>&nbsp; &nbsp; &nbsp;ShowMessage(foodListQuery.Sql.Text);&nbsp; &nbsp;</div><div>&nbsp; &nbsp; &nbsp;foodListQuery.ExecSql;</div><div>&nbsp; &nbsp; &nbsp;ShowMessage('Kayıt işlemi başarılı');</div><div>&nbsp; &nbsp; &nbsp;finally</div><div>&nbsp; &nbsp; &nbsp;foodListQuery.Close;</div><div>&nbsp; &nbsp; &nbsp;foodListQuery.Free;</div><div>&nbsp; &nbsp; &nbsp;end;</div><div>&nbsp; end;</div><div>&nbsp; else begin</div><div>&nbsp; ShowMessage('Doğru giriniz');&nbsp;</div><div>&nbsp; end;</div><div><br></div><div>end;</div></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div>]]>
   </description>
   <pubDate>Tue, 15 Aug 2023 13:30:00 +0000</pubDate>
   <guid isPermaLink="true">https://www.clomosy.com.tr/forum_posts.asp?TID=562&amp;PID=726#726</guid>
  </item> 
 </channel>
</rss>