<?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 : SQLite hatası</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : SQLite hatası]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 10:54:48 +0000</pubDate>
  <lastBuildDate>Fri, 18 Jul 2025 16:22:18 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 12.07</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>https://forum.clomosy.com.tr/RSS_post_feed.asp?TID=1107</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Clomosy | Forum]]></title>
   <url>https://forum.clomosy.com.tr/forum_images/logo.png</url>
   <link>https://forum.clomosy.com.tr/</link>
  </image>
  <item>
   <title><![CDATA[SQLite hatası : Merhaba Rumeysa, &#214;ncelikle baz&#305;...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1107&amp;PID=2271#2271</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=307">Mahmutdmr</a><br /><strong>Konu:</strong> 1107<br /><strong>Gönderim Zamanı:</strong> 18&nbsp;Temmuz&nbsp;2025 Saat 16:22<br /><br /><p -start="230" -end="442">Merhaba Rumeysa,<br -start="246" -end="249">Öncelikle bazı <str&#111;ng -start="266" -end="276">syntax</strong> hataların var. Clomosy’de <code -start="303" -end="308">try</code> ve <code -start="312" -end="320">except</code> komutlarında <code -start="334" -end="338">{}</code> kullanılmaz. Sadece <code -start="359" -end="367">except</code> kullandıktan sonra <code -start="387" -end="390">}</code> ile blok kapatılır ve kod bloğu aktif hale gelir.</p><p -start="449" -end="506">Bir diğer sorun ise, prosedürlerin sonuna <code -start="491" -end="494">;</code> konulmaz.</p><p -start="513" -end="547">Umarım yardımcı olabilmişimdir.</p><p -start="513" -end="547"><br>bir de&nbsp; düzenlediğim kodu dener misin çalışacak mı ?</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">var</p><p -start="513" -end="547">&nbsp; yemekEkle: TclForm;</p><p -start="513" -end="547">&nbsp; Qry: TclSQLiteQuery;</p><p -start="513" -end="547">&nbsp; ymkAdi, kcal: TClProEdit;</p><p -start="513" -end="547">&nbsp; ogunsecimi: TCLComboBox;</p><p -start="513" -end="547">&nbsp; eklebtn: TClProButton;</p><p -start="513" -end="547">&nbsp; notelbl: TClProLabel;</p><p -start="513" -end="547">&nbsp; noteMemo: TCLMemo;</p><p -start="513" -end="547">&nbsp; lblToplam: TClProLabel;</p><p -start="513" -end="547">&nbsp; bugun: TCLDateTime;</p><p -start="513" -end="547">&nbsp; toplamKalori: Integer;</p><p -start="513" -end="547">&nbsp; yemek, kalori, ogun, satir: String;</p><p -start="513" -end="547">&nbsp; girilenDeger, i: Integer;</p><p -start="513" -end="547">&nbsp; database, password: String;</p><p -start="513" -end="547">&nbsp;&nbsp;</p><p -start="513" -end="547">void TabloyuOlustur</p><p -start="513" -end="547">{</p><p -start="513" -end="547">&nbsp; database = Clomosy.AppFilesPath + 'ClomosyDatabase.db3';</p><p -start="513" -end="547">&nbsp; password = '';</p><p -start="513" -end="547">&nbsp; try&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp; Clomosy.DBSQLiteConnect(database, password);</p><p -start="513" -end="547">&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'CREATE TABLE IF NOT EXISTS YemekKayitlari ('+</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; 'id INTEGER PRIMARY KEY AUTOINCREMENT,'+</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; 'yemekAdi TEXT,'+</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; 'kalori INTEGER,'+</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; 'ogun TEXT,'+</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; 'tarih TEXT)';</p><p -start="513" -end="547">&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</p><p -start="513" -end="547">&nbsp; &nbsp;except&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp; ShowMessage('Tablo oluşturulurken hata oluştu: ' + LastExceptionMessage);</p><p -start="513" -end="547">&nbsp; }</p><p -start="513" -end="547">}</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">void BtnOnClick</p><p -start="513" -end="547">{</p><p -start="513" -end="547">&nbsp; yemek = ymkAdi.Text;</p><p -start="513" -end="547">&nbsp; kalori = kcal.Text;</p><p -start="513" -end="547">&nbsp; ogun = ogunsecimi.Text;</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; if (yemek == '')</p><p -start="513" -end="547">&nbsp; {</p><p -start="513" -end="547">&nbsp; &nbsp; ShowMessage('Yemek adı boş olamaz.');</p><p -start="513" -end="547">&nbsp; &nbsp; exit;</p><p -start="513" -end="547">&nbsp; }</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; if (kalori == '')</p><p -start="513" -end="547">&nbsp; {</p><p -start="513" -end="547">&nbsp; &nbsp; ShowMessage('Kalori miktarı boş olamaz.');</p><p -start="513" -end="547">&nbsp; &nbsp; exit;</p><p -start="513" -end="547">&nbsp; }</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; if (ogun == 'ÖĞÜN SEÇİNİZ')</p><p -start="513" -end="547">&nbsp; {</p><p -start="513" -end="547">&nbsp; &nbsp; ShowMessage('Lütfen bir öğün seçin.');</p><p -start="513" -end="547">&nbsp; &nbsp; exit;</p><p -start="513" -end="547">&nbsp; }</p><p -start="513" -end="547"><br></p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; try</p><p -start="513" -end="547">&nbsp; &nbsp; girilenDeger = StrToInt(kalori);</p><p -start="513" -end="547">&nbsp; except</p><p -start="513" -end="547">&nbsp;&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp; ShowMessage('Lütfen geçerli bir kalori değeri girin!');</p><p -start="513" -end="547">&nbsp; &nbsp; exit;</p><p -start="513" -end="547">&nbsp; }</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; // Tarih ata</p><p -start="513" -end="547">&nbsp; bugun = Date;</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; // Satırı oluştur ve yaz</p><p -start="513" -end="547">&nbsp; satir = '&#091;' + ogun + '&#093; ' + yemek + ' - ' + IntToStr(girilenDeger) + ' kcal (' + DateToStr(bugun) + ')';</p><p -start="513" -end="547">&nbsp; noteMemo.Lines.Add(satir);</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; // Kalori güncelle</p><p -start="513" -end="547">&nbsp; toplamKalori = toplamKalori + girilenDeger;</p><p -start="513" -end="547">&nbsp; lblToplam.Text = 'Toplam: ' + IntToStr(toplamKalori) + ' kcal';</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp;// Veritabanına kaydet</p><p -start="513" -end="547">&nbsp; try&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp; Clomosy.DBSQLiteConnect(database, password);</p><p -start="513" -end="547">&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; 'INSERT INTO YemekKayitlari (yemekAdi, kalori, ogun, tarih) VALUES (' +</p><p -start="513" -end="547">&nbsp; &nbsp; &nbsp; '''' + yemek + ''',' + kalori + ',' + '''' + ogun + ''',' + '''' + DateToStr(bugun) + ''')';</p><p -start="513" -end="547">&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</p><p -start="513" -end="547">&nbsp; &nbsp;except&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp; ShowMessage('Veri eklenemedi: ' + LastExceptionMessage);</p><p -start="513" -end="547">&nbsp; &nbsp; exit;</p><p -start="513" -end="547">&nbsp; }</p><p -start="513" -end="547">&nbsp; // Alanları temizle</p><p -start="513" -end="547">&nbsp; ymkAdi.Text = '';</p><p -start="513" -end="547">&nbsp; kcal.Text = '';</p><p -start="513" -end="547">&nbsp; ogunsecimi.ItemIndex = 0;</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; ShowMessage('Yemek başarıyla eklendi!');</p><p -start="513" -end="547">}</p><p -start="513" -end="547"><br></p><p -start="513" -end="547"><br></p><p -start="513" -end="547"><br></p><p -start="513" -end="547">{</p><p -start="513" -end="547">&nbsp; yemekEkle = TclForm.Create(Self);</p><p -start="513" -end="547">&nbsp; Qry = TclSQLiteQuery.Create(nil);</p><p -start="513" -end="547">&nbsp;&nbsp;</p><p -start="513" -end="547">&nbsp; database=Clomosy.AppFilesPath+'ClomosyDatabase.db3';</p><p -start="513" -end="547">&nbsp; password='';</p><p -start="513" -end="547"><br></p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi = yemekEkle.AddNewComboBox(yemekEkle,'ogunsecimi');</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.Align = alTop;</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.Height = 80;</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.Margins.Top=10;</p><p -start="513" -end="547">&nbsp; &nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.AddItem('ÖĞÜN SEÇİNİZ','');</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.AddItem('SABAH','');</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.AddItem('İLK ARA ÖĞÜN','');</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.AddItem('ÖĞLE','');</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.AddItem('ARA ÖĞÜN','');</p><p -start="513" -end="547">&nbsp; &nbsp;ogunsecimi.AddItem('AKŞAM','');</p><p -start="513" -end="547">&nbsp; &nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi = yemekEkle.AddNewProEdit(yemekEkle,'ymkAdi','YEMEK ADI');</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.Align = alTop;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.Width = 250;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.Height = 60;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.margins.top=10;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.BorderColor = clAlphaColor.clHexToColor('#90EE90');</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.FontColor = clAlphaColor.clHexToColor('#000000');</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.RoundHeight = 15;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.RoundWidth = 15;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.BorderWidth = 3;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.FontSize = 12;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.FontVertAlign = palcenter;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.FontHorzAlign = palCenter;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.TextSettings.Font.Style = &#091;fsBold,fsItalic&#093;;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.IsFill = True;&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.clProSettings.IsRound = True;</p><p -start="513" -end="547">&nbsp; &nbsp;ymkAdi.SetclProSettings(ymkAdi.clProSettings);</p><p -start="513" -end="547">&nbsp; &nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal = yemekEkle.AddNewProEdit(yemekEkle,'kcal','KALORİ MİKTARI');</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.Align = alTop;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.Width = 250;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.Height = 60;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.margins.top=10;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.BorderColor = clAlphaColor.clHexToColor('#90EE90');</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.FontColor = clAlphaColor.clHexToColor('#000000');</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.RoundHeight = 15;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.RoundWidth = 15;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.BorderWidth = 3;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.FontSize = 12;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.FontVertAlign = palcenter;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.FontHorzAlign = palCenter;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.TextSettings.Font.Style = &#091;fsBold,fsItalic&#093;;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.IsFill = True;&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.clProSettings.IsRound = True;</p><p -start="513" -end="547">&nbsp; &nbsp;kcal.SetclProSettings(kcal.clProSettings);</p><p -start="513" -end="547">&nbsp; &nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn = yemekEkle.AddNewProButton(yemekEkle,'eklebtn','');</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.Align = alTop;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.Width = 150;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.Height = 70;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.Margins.Top=10;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.FontColor = clAlphaColor.clDarkorchid;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.FontSize = 12;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.FontVertAlign = palcenter;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.FontHorzAlign = palCenter;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.TextSettings.Font.Style = &#091;fsBold,fsItalic&#093;;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.IsFill = True;&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.clProSettings.PictureSource = '<a href="https://resmim.net/cdn/2025/07/03/TnoYXI.png" target="_blank" rel="nofollow">https://resmim.net/cdn/2025/07/03/TnoYXI.png</a>';</p><p -start="513" -end="547">&nbsp; &nbsp;eklebtn.SetclProSettings(eklebtn.clProSettings);</p><p -start="513" -end="547">&nbsp; &nbsp;yemekEkle.AddNewEvent(eklebtn, tbeOnClick, 'BtnOnClick');</p><p -start="513" -end="547">&nbsp; &nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl = yemekEkle.AddNewProLabel(yemekEkle,'notelbl','BUGÜN TÜKETİLEN YEMEKLER');</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.Align = alBottom;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.Width = 150;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.Height = 20;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.Margins.Left = 10;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.Margins.Bottom = 20;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.clProSettings.FontColor = clAlphaColor.clHexToColor('#00FA9A');</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.clProSettings.FontSize = 15;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.clProSettings.FontVertAlign = palcenter;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.clProSettings.FontHorzAlign = palLeading;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.clProSettings.TextSettings.Font.Style = &#091;fsBold&#093;;</p><p -start="513" -end="547">&nbsp; &nbsp;notelbl.SetclProSettings(notelbl.clProSettings);</p><p -start="513" -end="547">&nbsp; &nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo = yemekEkle.AddNewMemo(yemekEkle,'noteMemo','');</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.Align = alBottom;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.Height = 200;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.Width = 250;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.Margins.Left= 10;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.Margins.Right= 10;&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.Margins.Bottom= 50;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.ReadOnly = true;</p><p -start="513" -end="547">&nbsp; &nbsp;noteMemo.TextSettings.WordWrap = True;</p><p -start="513" -end="547">&nbsp;</p><p -start="513" -end="547">&nbsp; &nbsp;TabloyuOlustur;</p><p -start="513" -end="547">&nbsp; &nbsp;yemekEkle.Run;</p><p -start="513" -end="547">}</p><p -start="513" -end="547"><br><br></p>]]>
   </description>
   <pubDate>Fri, 18 Jul 2025 16:22:18 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1107&amp;PID=2271#2271</guid>
  </item> 
  <item>
   <title><![CDATA[SQLite hatası : Merhaba, veritaban&#305; ba&#287;lant&#305;s&#305;...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1107&amp;PID=2269#2269</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=304">Rmeysa</a><br /><strong>Konu:</strong> 1107<br /><strong>Gönderim Zamanı:</strong> 18&nbsp;Temmuz&nbsp;2025 Saat 15:38<br /><br />Merhaba, veritabanı bağlantısı kurmaya çalışıyorum hata alıyorum. Nerede hata yapıyorum?<div><div>var</div><div>&nbsp; yemekEkle: TclForm;</div><div>&nbsp; Qry: TclSQLiteQuery;</div><div>&nbsp; ymkAdi, kcal: TClProEdit;</div><div>&nbsp; ogunsecimi: TCLComboBox;</div><div>&nbsp; eklebtn: TClProButton;</div><div>&nbsp; notelbl: TClProLabel;</div><div>&nbsp; noteMemo: TCLMemo;</div><div>&nbsp; lblToplam: TClProLabel;</div><div>&nbsp; bugun: TCLDateTime;</div><div>&nbsp; toplamKalori: Integer;</div><div>&nbsp; yemek, kalori, ogun, satir: String;</div><div>&nbsp; girilenDeger, i: Integer;</div><div>&nbsp; database, password: String;</div><div>&nbsp;&nbsp;</div><div>void TabloyuOlustur;</div><div>{</div><div>&nbsp; database = Clomosy.AppFilesPath + 'ClomosyDatabase.db3';</div><div>&nbsp; password = '';</div><div>&nbsp; try {</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteConnect(database, password);</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'CREATE TABLE IF NOT EXISTS YemekKayitlari ('+</div><div>&nbsp; &nbsp; &nbsp; 'id INTEGER PRIMARY KEY AUTOINCREMENT,'+</div><div>&nbsp; &nbsp; &nbsp; 'yemekAdi TEXT,'+</div><div>&nbsp; &nbsp; &nbsp; 'kalori INTEGER,'+</div><div>&nbsp; &nbsp; &nbsp; 'ogun TEXT,'+</div><div>&nbsp; &nbsp; &nbsp; 'tarih TEXT)';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; } except {</div><div>&nbsp; &nbsp; ShowMessage('Tablo oluşturulurken hata oluştu: ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div><br></div><div>void BtnOnClick;</div><div>{</div><div>&nbsp; yemek = ymkAdi.Text;</div><div>&nbsp; kalori = kcal.Text;</div><div>&nbsp; ogun = ogunsecimi.Text;</div><div><br></div><div>&nbsp; if (yemek == '')</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Yemek adı boş olamaz.');</div><div>&nbsp; &nbsp; exit;</div><div>&nbsp; }</div><div><br></div><div>&nbsp; if (kalori == '')</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Kalori miktarı boş olamaz.');</div><div>&nbsp; &nbsp; exit;</div><div>&nbsp; }</div><div><br></div><div>&nbsp; if (ogun == 'ÖĞÜN SEÇİNİZ')</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Lütfen bir öğün seçin.');</div><div>&nbsp; &nbsp; exit;</div><div>&nbsp; }</div><div><br></div><div><br></div><div>&nbsp; try</div><div>&nbsp; {</div><div>&nbsp; &nbsp; girilenDeger = StrToInt(kalori);</div><div>&nbsp; }</div><div>&nbsp; except</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Lütfen geçerli bir kalori değeri girin!');</div><div>&nbsp; &nbsp; exit;</div><div>&nbsp; }</div><div><br></div><div>&nbsp; // Tarih ata</div><div>&nbsp; bugun = Date;</div><div><br></div><div>&nbsp; // Satırı oluştur ve yaz</div><div>&nbsp; satir = '&#091;' + ogun + '&#093; ' + yemek + ' - ' + IntToStr(girilenDeger) + ' kcal (' + DateToStr(bugun) + ')';</div><div>&nbsp; noteMemo.Lines.Add(satir);</div><div><br></div><div>&nbsp; // Kalori güncelle</div><div>&nbsp; toplamKalori = toplamKalori + girilenDeger;</div><div>&nbsp; lblToplam.Text = 'Toplam: ' + IntToStr(toplamKalori) + ' kcal';</div><div><br></div><div>&nbsp;// Veritabanına kaydet</div><div>&nbsp; try {</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteConnect(database, password);</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</div><div>&nbsp; &nbsp; &nbsp; 'INSERT INTO YemekKayitlari (yemekAdi, kalori, ogun, tarih) VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; '''' + yemek + ''',' + kalori + ',' + '''' + ogun + ''',' + '''' + DateToStr(bugun) + ''')';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; } except {</div><div>&nbsp; &nbsp; ShowMessage('Veri eklenemedi: ' + LastExceptionMessage);</div><div>&nbsp; &nbsp; exit;</div><div>&nbsp; }</div><div>&nbsp; // Alanları temizle</div><div>&nbsp; ymkAdi.Text = '';</div><div>&nbsp; kcal.Text = '';</div><div>&nbsp; ogunsecimi.ItemIndex = 0;</div><div><br></div><div>&nbsp; ShowMessage('Yemek başarıyla eklendi!');</div><div>}</div><div><br></div><div><br></div><div><br></div><div>{</div><div>&nbsp; yemekEkle = TclForm.Create(Self);</div><div>&nbsp; Qry = TclSQLiteQuery.Create(nil);</div><div>&nbsp;&nbsp;</div><div>&nbsp; database=Clomosy.AppFilesPath+'ClomosyDatabase.db3';</div><div>&nbsp; password='';</div><div><br></div><div>&nbsp; &nbsp;ogunsecimi = yemekEkle.AddNewComboBox(yemekEkle,'ogunsecimi');</div><div>&nbsp; &nbsp;ogunsecimi.Align = alTop;</div><div>&nbsp; &nbsp;ogunsecimi.Height = 80;</div><div>&nbsp; &nbsp;ogunsecimi.Margins.Top=10;</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;ogunsecimi.AddItem('ÖĞÜN SEÇİNİZ','');</div><div>&nbsp; &nbsp;ogunsecimi.AddItem('SABAH','');</div><div>&nbsp; &nbsp;ogunsecimi.AddItem('İLK ARA ÖĞÜN','');</div><div>&nbsp; &nbsp;ogunsecimi.AddItem('ÖĞLE','');</div><div>&nbsp; &nbsp;ogunsecimi.AddItem('ARA ÖĞÜN','');</div><div>&nbsp; &nbsp;ogunsecimi.AddItem('AKŞAM','');</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;ymkAdi = yemekEkle.AddNewProEdit(yemekEkle,'ymkAdi','YEMEK ADI');</div><div>&nbsp; &nbsp;ymkAdi.Align = alTop;</div><div>&nbsp; &nbsp;ymkAdi.Width = 250;</div><div>&nbsp; &nbsp;ymkAdi.Height = 60;</div><div>&nbsp; &nbsp;ymkAdi.margins.top=10;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.BorderColor = clAlphaColor.clHexToColor('#90EE90');</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.FontColor = clAlphaColor.clHexToColor('#000000');</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.RoundHeight = 15;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.RoundWidth = 15;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.BorderWidth = 3;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.FontSize = 12;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.FontVertAlign = palcenter;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.FontHorzAlign = palCenter;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.TextSettings.Font.Style = &#091;fsBold,fsItalic&#093;;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.IsFill = True;&nbsp;</div><div>&nbsp; &nbsp;ymkAdi.clProSettings.IsRound = True;</div><div>&nbsp; &nbsp;ymkAdi.SetclProSettings(ymkAdi.clProSettings);</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;kcal = yemekEkle.AddNewProEdit(yemekEkle,'kcal','KALORİ MİKTARI');</div><div>&nbsp; &nbsp;kcal.Align = alTop;</div><div>&nbsp; &nbsp;kcal.Width = 250;</div><div>&nbsp; &nbsp;kcal.Height = 60;</div><div>&nbsp; &nbsp;kcal.margins.top=10;</div><div>&nbsp; &nbsp;kcal.clProSettings.BorderColor = clAlphaColor.clHexToColor('#90EE90');</div><div>&nbsp; &nbsp;kcal.clProSettings.FontColor = clAlphaColor.clHexToColor('#000000');</div><div>&nbsp; &nbsp;kcal.clProSettings.RoundHeight = 15;</div><div>&nbsp; &nbsp;kcal.clProSettings.RoundWidth = 15;</div><div>&nbsp; &nbsp;kcal.clProSettings.BorderWidth = 3;</div><div>&nbsp; &nbsp;kcal.clProSettings.FontSize = 12;</div><div>&nbsp; &nbsp;kcal.clProSettings.FontVertAlign = palcenter;</div><div>&nbsp; &nbsp;kcal.clProSettings.FontHorzAlign = palCenter;</div><div>&nbsp; &nbsp;kcal.clProSettings.TextSettings.Font.Style = &#091;fsBold,fsItalic&#093;;</div><div>&nbsp; &nbsp;kcal.clProSettings.IsFill = True;&nbsp;</div><div>&nbsp; &nbsp;kcal.clProSettings.IsRound = True;</div><div>&nbsp; &nbsp;kcal.SetclProSettings(kcal.clProSettings);</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;eklebtn = yemekEkle.AddNewProButton(yemekEkle,'eklebtn','');</div><div>&nbsp; &nbsp;eklebtn.Align = alTop;</div><div>&nbsp; &nbsp;eklebtn.Width = 150;</div><div>&nbsp; &nbsp;eklebtn.Height = 70;</div><div>&nbsp; &nbsp;eklebtn.Margins.Top=10;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.FontColor = clAlphaColor.clDarkorchid;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.FontSize = 12;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.FontVertAlign = palcenter;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.FontHorzAlign = palCenter;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.TextSettings.Font.Style = &#091;fsBold,fsItalic&#093;;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.IsFill = True;&nbsp;</div><div>&nbsp; &nbsp;eklebtn.clProSettings.PictureSource = '<a href="https://resmim.net/cdn/2025/07/03/TnoYXI.png" target="_blank" rel="nofollow">https://resmim.net/cdn/2025/07/03/TnoYXI.png</a>';</div><div>&nbsp; &nbsp;eklebtn.SetclProSettings(eklebtn.clProSettings);</div><div>&nbsp; &nbsp;yemekEkle.AddNewEvent(eklebtn, tbeOnClick, 'BtnOnClick');</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;notelbl = yemekEkle.AddNewProLabel(yemekEkle,'notelbl','BUGÜN TÜKETİLEN YEMEKLER');</div><div>&nbsp; &nbsp;notelbl.Align = alBottom;</div><div>&nbsp; &nbsp;notelbl.Width = 150;</div><div>&nbsp; &nbsp;notelbl.Height = 20;</div><div>&nbsp; &nbsp;notelbl.Margins.Left = 10;</div><div>&nbsp; &nbsp;notelbl.Margins.Bottom = 20;</div><div>&nbsp; &nbsp;notelbl.clProSettings.FontColor = clAlphaColor.clHexToColor('#00FA9A');</div><div>&nbsp; &nbsp;notelbl.clProSettings.FontSize = 15;</div><div>&nbsp; &nbsp;notelbl.clProSettings.FontVertAlign = palcenter;</div><div>&nbsp; &nbsp;notelbl.clProSettings.FontHorzAlign = palLeading;</div><div>&nbsp; &nbsp;notelbl.clProSettings.TextSettings.Font.Style = &#091;fsBold&#093;;</div><div>&nbsp; &nbsp;notelbl.SetclProSettings(notelbl.clProSettings);</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;noteMemo = yemekEkle.AddNewMemo(yemekEkle,'noteMemo','');</div><div>&nbsp; &nbsp;noteMemo.Align = alBottom;</div><div>&nbsp; &nbsp;noteMemo.Height = 200;</div><div>&nbsp; &nbsp;noteMemo.Width = 250;</div><div>&nbsp; &nbsp;noteMemo.Margins.Left= 10;</div><div>&nbsp; &nbsp;noteMemo.Margins.Right= 10;&nbsp;</div><div>&nbsp; &nbsp;noteMemo.Margins.Bottom= 50;</div><div>&nbsp; &nbsp;noteMemo.ReadOnly = true;</div><div>&nbsp; &nbsp;noteMemo.TextSettings.WordWrap = True;</div><div>&nbsp;</div><div>&nbsp; &nbsp;TabloyuOlustur;</div><div>&nbsp; &nbsp;yemekEkle.Run;</div><div>}</div></div>]]>
   </description>
   <pubDate>Fri, 18 Jul 2025 15:38:17 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1107&amp;PID=2269#2269</guid>
  </item> 
 </channel>
</rss>