<?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 Hatası</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : Sql Hatası]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 13:13:13 +0000</pubDate>
  <lastBuildDate>Mon, 05 Aug 2024 18:08:37 +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=811</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[Sql Hatası : Merhaba Yusuf,A&#351;a&#287;&#305;daki kodu inceler...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=811&amp;PID=1436#1436</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=106">Developer</a><br /><strong>Konu:</strong> 811<br /><strong>Gönderim Zamanı:</strong> 05&nbsp;Ağustos&nbsp;2024 Saat 18:08<br /><br />Merhaba Yusuf,<div>Aşağıdaki kodu inceler misin:</div><div><div>var</div><div>&nbsp; loginForm: TclStyleForm;</div><div>&nbsp; tcEdit, nameEdit: TclEdit;</div><div>&nbsp; loginButton: TclButton;</div><div>&nbsp; userTC, userName: string;</div><div>&nbsp; AddAppointmentUnit, AnaSayfaUnitUnit : TclUnit;</div><div><br></div><div>void CreateDatabase;</div><div>{</div><div>&nbsp; Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath + 'UserDatabase.db3', '');</div><div>&nbsp; Clomosy.DBSQLiteQuery.SQL.Text = '</div><div>&nbsp; &nbsp; CREATE TABLE IF NOT EXISTS Users (</div><div>&nbsp; &nbsp; &nbsp; id INTEGER PRIMARY KEY AUTOINCREMENT,</div><div>&nbsp; &nbsp; &nbsp; tc TEXT,&nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; name TEXT</div><div>&nbsp; &nbsp; );</div><div>&nbsp; &nbsp; CREATE TABLE IF NOT EXISTS Appointments (</div><div>&nbsp; &nbsp; &nbsp; id INTEGER PRIMARY KEY AUTOINCREMENT,</div><div>&nbsp; &nbsp; &nbsp; DoctorName TEXT,</div><div>&nbsp; &nbsp; &nbsp; AppointmentDate TEXT,</div><div>&nbsp; &nbsp; &nbsp; Notes TEXT,</div><div>&nbsp; &nbsp; &nbsp; UserID TEXT,</div><div>&nbsp; &nbsp; &nbsp; UserName TEXT</div><div>&nbsp; &nbsp; );</div><div>&nbsp; ';</div><div>&nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute();</div><div>}</div><div><br></div><div>// Kullanıcı bilgilerini veritabanına kaydetme fonksiyonu</div><div>void SaveUserInfo;</div><div>{</div><div>&nbsp; Clomosy.DBSQLiteQuery.SQL.Text = 'INSERT INTO Users (tc, name) VALUES (:tc, :name)';</div><div>&nbsp; Clomosy.DBSQLiteQuery.ParamByName('tc').Value = userTC;</div><div>&nbsp; Clomosy.DBSQLiteQuery.ParamByName('name').Value = userName;</div><div>&nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute();</div><div><br></div><div>&nbsp; ShowMessage('Kullanıcı bilgileri kaydedildi.');</div><div>&nbsp;&nbsp;</div><div>}</div><div><br></div><div>void GoToAnaSayfaUnit;</div><div>{</div><div><br></div><div>&nbsp; AnaSayfaUnitUnit = TclUnit.Create;</div><div>&nbsp; AnaSayfaUnitUnit.UnitName = 'AnaSayfaUnitUnit';</div><div>&nbsp; AnaSayfaUnitUnit.CallerForm = loginForm;</div><div>&nbsp; AnaSayfaUnitUnit.Run;</div><div>}</div><div><br></div><div>// Randevu formuna geçiş</div><div>void GoToAddAppointmentUnit;</div><div>{</div><div>&nbsp; AddAppointmentUnit = TclUnit.Create;</div><div>&nbsp; AddAppointmentUnit.UnitName = 'AddAppointmentUnit';</div><div>&nbsp; AddAppointmentUnit.CallerForm = loginForm;</div><div>&nbsp; AddAppointmentUnit.Run;</div><div>}</div><div><br></div><div>{</div><div>&nbsp; loginForm = TclStyleForm.Create(Self);</div><div><br></div><div>&nbsp; // TC edit</div><div>&nbsp; tcEdit = loginForm.AddNewEdit(loginForm, 'tcEdit', 'TC Kimlik Numarası');</div><div>&nbsp; tcEdit.Align = alTop;</div><div>&nbsp; tcEdit.Height = 40;</div><div>&nbsp; tcEdit.Margins.Top = 50;</div><div>&nbsp; tcEdit.Margins.Left = 20;</div><div>&nbsp; tcEdit.Margins.Right = 20;</div><div><br></div><div>&nbsp; nameEdit = loginForm.AddNewEdit(loginForm, 'nameEdit', 'İsim');</div><div>&nbsp; nameEdit.Align = alTop;</div><div>&nbsp; nameEdit.Height = 40;</div><div>&nbsp; nameEdit.Margins.Top = 10;</div><div>&nbsp; nameEdit.Margins.Left = 20;</div><div>&nbsp; nameEdit.Margins.Right = 20;</div><div><br></div><div>&nbsp; loginButton = loginForm.AddNewButton(loginForm, 'loginButton', 'Giriş');</div><div>&nbsp; loginButton.Align = alTop;</div><div>&nbsp; loginButton.Height = 40;</div><div>&nbsp; loginButton.Margins.Top = 20;</div><div>&nbsp; loginButton.Margins.Left = 20;</div><div>&nbsp; loginButton.Margins.Right = 20;</div><div><br></div><div><br></div><div>&nbsp; loginForm.AddNewEvent(loginButton, tbeOnClick, 'SaveUserInfo');</div><div><br></div><div>&nbsp; CreateDatabase(); // Veritabanı oluşturma çağrısı</div><div><br></div><div>&nbsp; loginForm.Run;</div><div>}</div></div>]]>
   </description>
   <pubDate>Mon, 05 Aug 2024 18:08:37 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=811&amp;PID=1436#1436</guid>
  </item> 
  <item>
   <title><![CDATA[Sql Hatası : var loginForm: TclStyleForm; Edit,...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=811&amp;PID=1433#1433</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=201">YusufSoyler</a><br /><strong>Konu:</strong> 811<br /><strong>Gönderim Zamanı:</strong> 05&nbsp;Ağustos&nbsp;2024 Saat 17:55<br /><br /><div>var</div><div>&nbsp; loginForm: TclStyleForm;</div><div>&nbsp; Edit, nameEdit: TclEdit;</div><div>&nbsp; loginButton: TclButton;</div><div>&nbsp; userTC, userName: string;</div><div>&nbsp; AddAppointmentUnit, AnaSayfaUnitUnit : TclUnit;</div><div><br></div><div>void CreateDatabase;</div><div>{</div><div>&nbsp; Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath + 'UserDatabase.db3', '');</div><div>&nbsp; Clomosy.DBSQLiteQuery.SQL.Text = '</div><div>&nbsp; &nbsp; CREATE TABLE IF NOT EXISTS Users (</div><div>&nbsp; &nbsp; &nbsp; id INTEGER PRIMARY KEY AUTOINCREMENT,</div><div>&nbsp; &nbsp; &nbsp; tc TEXT,&nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; name TEXT</div><div>&nbsp; &nbsp; );</div><div>&nbsp; &nbsp; CREATE TABLE IF NOT EXISTS Appointments (</div><div>&nbsp; &nbsp; &nbsp; id INTEGER PRIMARY KEY AUTOINCREMENT,</div><div>&nbsp; &nbsp; &nbsp; DoctorName TEXT,</div><div>&nbsp; &nbsp; &nbsp; AppointmentDate TEXT,</div><div>&nbsp; &nbsp; &nbsp; Notes TEXT,</div><div>&nbsp; &nbsp; &nbsp; UserID TEXT,</div><div>&nbsp; &nbsp; &nbsp; UserName TEXT</div><div>&nbsp; &nbsp; );</div><div>&nbsp; ';</div><div>&nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute();</div><div>}</div><div><br></div><div>// Kullanıcı bilgilerini veritabanına kaydetme fonksiyonu</div><div>void SaveUserInfo;</div><div>{</div><div>&nbsp; Clomosy.DBSQLiteQuery.SQL.Text = 'INSERT INTO Users (tc, name) VALUES (:tc, :name)';</div><div>&nbsp; Clomosy.DBSQLiteQuery.ParamByName('tc').Value = userTC;</div><div>&nbsp; Clomosy.DBSQLiteQuery.ParamByName('name').Value = userName;</div><div>&nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute();</div><div><br></div><div>&nbsp; ShowMessage('Kullanıcı bilgileri kaydedildi.');</div><div>&nbsp;&nbsp;</div><div>}</div><div><br></div><div>void GoToAnaSayfaUnit;</div><div>{</div><div><br></div><div>&nbsp; AnaSayfaUnitUnit = TclUnit.Create;</div><div>&nbsp; AnaSayfaUnitUnit.UnitName = 'AnaSayfaUnitUnit';</div><div>&nbsp; AnaSayfaUnitUnit.CallerForm = loginForm;</div><div>&nbsp; AnaSayfaUnitUnit.Run;</div><div>}</div><div><br></div><div>// Randevu formuna geçiş</div><div>void GoToAddAppointmentUnit;</div><div>{</div><div>&nbsp; AddAppointmentUnit = TclUnit.Create;</div><div>&nbsp; AddAppointmentUnit.UnitName = 'AddAppointmentUnit';</div><div>&nbsp; AddAppointmentUnit.CallerForm = loginForm;</div><div>&nbsp; AddAppointmentUnit.Run;</div><div>}</div><div><br></div><div>{</div><div>&nbsp; loginForm = TclStyleForm.Create(Self);</div><div><br></div><div>&nbsp; // TC edit</div><div>&nbsp; tcEdit = loginForm.AddNewEdit(loginForm, 'tcEdit', 'TC Kimlik Numarası');</div><div>&nbsp; tcEdit.Align = alTop;</div><div>&nbsp; tcEdit.Height = 40;</div><div>&nbsp; tcEdit.Margins.Top = 50;</div><div>&nbsp; tcEdit.Margins.Left = 20;</div><div>&nbsp; tcEdit.Margins.Right = 20;</div><div><br></div><div>&nbsp; nameEdit = loginForm.AddNewEdit(loginForm, 'nameEdit', 'İsim');</div><div>&nbsp; nameEdit.Align = alTop;</div><div>&nbsp; nameEdit.Height = 40;</div><div>&nbsp; nameEdit.Margins.Top = 10;</div><div>&nbsp; nameEdit.Margins.Left = 20;</div><div>&nbsp; nameEdit.Margins.Right = 20;</div><div><br></div><div>&nbsp; loginButton = loginForm.AddNewButton(loginForm, 'loginButton', 'Giriş');</div><div>&nbsp; loginButton.Align = alTop;</div><div>&nbsp; loginButton.Height = 40;</div><div>&nbsp; loginButton.Margins.Top = 20;</div><div>&nbsp; loginButton.Margins.Left = 20;</div><div>&nbsp; loginButton.Margins.Right = 20;</div><div><br></div><div><br></div><div>&nbsp; loginForm.AddNewEvent(loginButton, tbeOnClick, 'SaveUserInfo');</div><div><br></div><div>&nbsp; CreateDatabase(); // Veritabanı oluşturma çağrısı</div><div><br></div><div>&nbsp; loginForm.Run;</div><div>}</div><div><img src="uploads/201/Ekran_görüntüsü_2024-08-05_173201.png" height="230" width="403" border="0" />&nbsp; bu hatayi alıyorum</div>]]>
   </description>
   <pubDate>Mon, 05 Aug 2024 17:55:09 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=811&amp;PID=1433#1433</guid>
  </item> 
 </channel>
</rss>