<?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 : Veritabanı</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : Veritabanı]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 14:25:14 +0000</pubDate>
  <lastBuildDate>Thu, 29 Aug 2024 18:04:03 +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=918</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[Veritabanı : Merhaba Mustafa,Not ekle sayfas&#305;ndaki...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1770#1770</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=142">BilalCndn</a><br /><strong>Konu:</strong> 918<br /><strong>Gönderim Zamanı:</strong> 29&nbsp;Ağustos&nbsp;2024 Saat 18:04<br /><br />Merhaba Mustafa,<div><br></div><div>Not ekle sayfasındaki form ve nesneleri 'ShowNotEkleScreen' void'i içerisinde tanımladığın için diğer voidlerin içerisinden erişemezsin. var kısmındaki nesneleri global olarak tanımlarsan sorunun çözülecektir.</div><div><br></div><div>İyi çalışmalar dilerim.</div>]]>
   </description>
   <pubDate>Thu, 29 Aug 2024 18:04:03 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1770#1770</guid>
  </item> 
  <item>
   <title><![CDATA[Veritabanı : Not Kayd&#305; s&#305;ras&#305;nda bir hata olu&#351;tu:Access...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1769#1769</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=222">MustafaCetin</a><br /><strong>Konu:</strong> 918<br /><strong>Gönderim Zamanı:</strong> 29&nbsp;Ağustos&nbsp;2024 Saat 17:44<br /><br />Not Kaydı sırasında bir hata oluştu:Access violation at address 00A7A564 in moulde'ClomosyLearn.exe'.Read of address 0000000&nbsp;<br>hata bu kullanıcı kayıt olabiliyor giriş yapıyor ve bu veriler sqlite da gözüküyor . Not kayıt için sqlite da tablo oluşturuyor ama not için veri oluşturmuyor.]]>
   </description>
   <pubDate>Thu, 29 Aug 2024 17:44:43 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1769#1769</guid>
  </item> 
  <item>
   <title><![CDATA[Veritabanı : Merhaba Mustafa,Hatan&#305;n tam halini...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1767#1767</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=142">BilalCndn</a><br /><strong>Konu:</strong> 918<br /><strong>Gönderim Zamanı:</strong> 29&nbsp;Ağustos&nbsp;2024 Saat 17:38<br /><br />Merhaba Mustafa,<div><br></div><div>Hatanın tam halini paylaşır mısın?</div>]]>
   </description>
   <pubDate>Thu, 29 Aug 2024 17:38:37 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1767#1767</guid>
  </item> 
  <item>
   <title><![CDATA[Veritabanı : Kullan&#305;c&#305; kay&#305;t ve giri&#351; yapabiliyor...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1764#1764</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=222">MustafaCetin</a><br /><strong>Konu:</strong> 918<br /><strong>Gönderim Zamanı:</strong> 29&nbsp;Ağustos&nbsp;2024 Saat 15:42<br /><br /><div>Kullanıcı kayıt ve giriş yapabiliyor ama not kaydetmek istediğimde sqlite da tablo oluşturuyor sonra&nbsp; Not kaydı sırasında bir hata oluştu mesajı geliyor.</div><div>var</div><div>&nbsp; anaSayfa, girisSayfa, kayitSayfa, postLoginSayfa: TclForm;</div><div>&nbsp; nameK, surnameK, passwordK: TclProEdit;</div><div>&nbsp; nameG, surnameG, passwordG: TclProEdit;</div><div>&nbsp; kayitButton, girisButton: TclProButton;</div><div>&nbsp; notBasligiEdit, notIcerigiEdit: TclProEdit;&nbsp;</div><div>&nbsp; VScroll:TCLVertScrollBox;</div><div><br></div><div>void ShowAnaSayfa;</div><div>{</div><div>&nbsp; if not (Assigned(anaSayfa))</div><div>&nbsp; &nbsp; anaSayfa = TclForm.Create(Self);</div><div><br></div><div>&nbsp; anaSayfa.SetFormBGImage('<a href="https://i.hizliresim.com/phhojjq.jpg" target="_blank" rel="nofollow">https://i.hizliresim.com/phhojjq.jpg</a>');</div><div><br></div><div>&nbsp; girisButton = anaSayfa.AddNewProButton(anaSayfa, 'girisButton', 'Giriş Yap');</div><div>&nbsp; girisButton.Margins.Top = 100;</div><div>girisButton.Width = 160;</div><div>girisButton.Height = 40;</div><div>girisButton.clProSettings.RoundWidth = 20;</div><div>girisButton.clProSettings.RoundHeight = 20;</div><div>girisButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#2196F3');</div><div>girisButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div><br></div><div><br></div><div>girisButton.SetclProSettings(girisButton.clProSettings);</div><div>anaSayfa.AddNewEvent(girisButton, tbeOnClick, 'GirisYap');</div><div><br></div><div>&nbsp; kayitButton = anaSayfa.AddNewProButton(anaSayfa, 'kayitButton', 'Kayıt Ol');</div><div>&nbsp;kayitButton.Margins.Top = 160;</div><div>kayitButton.Width = 160;</div><div>kayitButton.Height = 40;</div><div>kayitButton.clProSettings.RoundWidth = 20;</div><div>kayitButton.clProSettings.RoundHeight = 20;</div><div>kayitButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#4CAF50');</div><div>kayitButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div><br></div><div>kayitButton.SetclProSettings(kayitButton.clProSettings);</div><div>anaSayfa.AddNewEvent(kayitButton, tbeOnClick, 'KayitOl');</div><div><br></div><div>&nbsp; anaSayfa.Run;</div><div>}</div><div><br></div><div>void ShowPostLoginScreen(userName: string);</div><div>var</div><div>&nbsp; welcomeLabel: TclProLabel;</div><div>&nbsp; notAraButton, notEkleButton: TclProButton;</div><div>&nbsp; notAraEdit: TclProEdit;</div><div>&nbsp; notLabel: TclProLabel;</div><div>{</div><div>&nbsp; if not (Assigned(postLoginSayfa))</div><div>&nbsp; &nbsp; postLoginSayfa = TclForm.Create(Self);</div><div><br></div><div>&nbsp; postLoginSayfa.SetFormBGImage('<a href="https://i.hizliresim.com/km8rak7.png" target="_blank" rel="nofollow">https://i.hizliresim.com/km8rak7.png</a>');</div><div><br></div><div>&nbsp; welcomeLabel = postLoginSayfa.AddNewProLabel(postLoginSayfa, 'welcomeLabel', 'Hoşgeldiniz, ' + userName + '!');</div><div>&nbsp; welcomeLabel.Align = alNone;</div><div>&nbsp; welcomeLabel.Position.X = 20;</div><div>&nbsp; welcomeLabel.Position.Y = 120;</div><div>&nbsp; welcomeLabel.Width = 300;</div><div>&nbsp; welcomeLabel.Height = 75;</div><div>welcomeLabel.clProSettings.FontSize = 15;</div><div>welcomeLabel.clProSettings.FontColor = clAlphaColor.clHexToColor('#0be5ae');</div><div>welcomeLabel.SetclProSettings(welcomeLabel.clProSettings);</div><div><br></div><div><br></div><div>&nbsp; notLabel = postLoginSayfa.AddNewProLabel(postLoginSayfa, 'notLabel', 'Not Ara:');</div><div>&nbsp; notLabel.Align = alNone;</div><div>&nbsp; notLabel.Position.X = 50;</div><div>&nbsp; notLabel.Position.Y = 240;</div><div>&nbsp; notLabel.Width = 100;</div><div>&nbsp; notLabel.Height = 30;</div><div>&nbsp; notLabel.clProSettings.FontSize = 16;</div><div>notLabel.clProSettings.FontColor = clAlphaColor.clHexToColor('#000000');</div><div>notLabel.SetclProSettings(notLabel.clProSettings);</div><div><br></div><div>&nbsp; notAraEdit = postLoginSayfa.AddNewProEdit(postLoginSayfa, 'notAraEdit', '');</div><div>&nbsp; notAraEdit.Align = alNone;</div><div>&nbsp; notAraEdit.Position.X = 120;</div><div>&nbsp; notAraEdit.Position.Y = 240;</div><div>&nbsp; notAraEdit.Width = 200;</div><div>&nbsp; notAraEdit.Height = 45;</div><div>&nbsp; notAraEdit.clProSettings.RoundWidth = 20;</div><div>notAraEdit.clProSettings.RoundHeight = 20;</div><div>notAraEdit.SetclProSettings(notAraEdit.clProSettings);</div><div><br></div><div>&nbsp; notAraButton = postLoginSayfa.AddNewProButton(postLoginSayfa, 'notAraButton', 'Ara');</div><div>&nbsp; notAraButton.Align = alNone;</div><div>&nbsp; notAraButton.Position.X = 160;</div><div>&nbsp; notAraButton.Position.Y = 310;</div><div>&nbsp; notAraButton.Width = 120;</div><div>&nbsp; notAraButton.Height = 45;</div><div>&nbsp;notAraButton.clProSettings.RoundWidth = 20;</div><div>notAraButton.clProSettings.RoundHeight = 20;</div><div>notAraButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#4CAF50');</div><div>notAraButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>notAraButton.SetclProSettings(notAraButton.clProSettings);</div><div>postLoginSayfa.AddNewEvent(notAraButton, tbeOnClick, 'NotAra');</div><div><br></div><div>&nbsp; notEkleButton = postLoginSayfa.AddNewProButton(postLoginSayfa, 'notEkleButton', 'Not Ekle');</div><div>&nbsp; notEkleButton.Align = alNone;</div><div>&nbsp; notEkleButton.Position.X = 160;&nbsp;&nbsp;</div><div>&nbsp; notEkleButton.Position.Y = 350;</div><div>&nbsp; notEkleButton.Width = 120;</div><div>&nbsp; notEkleButton.Height = 45;</div><div>&nbsp;notEkleButton.clProSettings.RoundWidth = 20;</div><div>notEkleButton.clProSettings.RoundHeight = 20;</div><div>notEkleButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#FF5722');</div><div>notEkleButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>notEkleButton.SetclProSettings(notEkleButton.clProSettings);</div><div>postLoginSayfa.AddNewEvent(notEkleButton, tbeOnClick, 'ShowNotEkleScreen');</div><div><br></div><div>&nbsp; postLoginSayfa.Run;</div><div>}</div><div><br></div><div>void KaydetNot;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath + 'MuhabirMobil.db', '');</div><div>&nbsp; &nbsp; ShowMessage('Veritabanına bağlanıldı.');</div><div><br></div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</div><div>&nbsp; &nbsp; 'SELECT * FROM Notes WHERE note_title = ' + QuotedStr(notBasligiEdit.Text) +</div><div>&nbsp; &nbsp; ' AND note_content = ' + QuotedStr(notIcerigiEdit.Text);</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; if not (Clomosy.DBSQLiteQuery.Found)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</div><div>&nbsp; &nbsp; &nbsp; 'INSERT INTO Notes (note_title, note_content) VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(notBasligiEdit.Text) + ', ' + QuotedStr(notIcerigiEdit.Text) + ');';</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Not başarıyla kaydedildi!');</div><div><br></div><div>&nbsp; &nbsp; &nbsp; // Not eklendikten sonra giriş ekranına dön</div><div>&nbsp; &nbsp; &nbsp; ShowPostLoginScreen('Kullanıcı');&nbsp;&nbsp;</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Bu not zaten mevcut.');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Not kaydı sırasında bir hata oluştu: ' + LastExceptionMessage);</div><div>}</div><div>}</div><div><br></div><div><br></div><div><br></div><div><br></div><div>void ShowNotEkleScreen;</div><div>var</div><div>&nbsp; MyForm: TclForm;</div><div>&nbsp; notBasligiLabel, notIcerigiLabel: TclProLabel;</div><div>&nbsp; notBasligiEdit: TclProEdit;</div><div>&nbsp; notIcerigiScrollBox: TCLVertScrollBox;</div><div>&nbsp; notIcerigiEdit: TclProEdit;</div><div>&nbsp; kaydetButton: TclProButton;</div><div>{</div><div>&nbsp; MyForm = TclForm.Create(Self);</div><div>&nbsp; MyForm.SetFormBGImage('<a href="https://i.hizliresim.com/km8rak7.png" target="_blank" rel="nofollow">https://i.hizliresim.com/km8rak7.png</a>');</div><div><br></div><div>&nbsp; notBasligiLabel = MyForm.AddNewProLabel(MyForm, 'notBasligiLabel', 'Not Başlığı:');</div><div>&nbsp; notBasligiLabel.Align = alNone;</div><div>&nbsp; notBasligiLabel.Position.X = 30;</div><div>&nbsp; notBasligiLabel.Position.Y = 50;</div><div><br></div><div>&nbsp; notBasligiEdit = MyForm.AddNewProEdit(MyForm, 'notBasligiEdit', '');</div><div>&nbsp; notBasligiEdit.Align = alNone;</div><div>&nbsp; notBasligiEdit.Position.X = 130;</div><div>&nbsp; notBasligiEdit.Position.Y = 50;</div><div>&nbsp; notBasligiEdit.Width = 200;</div><div>&nbsp; notBasligiEdit.Height = 30;</div><div><br></div><div>&nbsp; notIcerigiLabel = MyForm.AddNewProLabel(MyForm, 'notIcerigiLabel', 'Not İçeriği:');</div><div>&nbsp; notIcerigiLabel.Align = alNone;</div><div>&nbsp; notIcerigiLabel.Position.X = 30;</div><div>&nbsp; notIcerigiLabel.Position.Y = 100;</div><div><br></div><div>&nbsp;&nbsp;</div><div>&nbsp; notIcerigiScrollBox = MyForm.AddNewVertScrollBox(MyForm, 'notIcerigiScrollBox');</div><div>&nbsp; notIcerigiScrollBox.Align = alNone;</div><div>&nbsp; notIcerigiScrollBox.Position.X = 130;</div><div>&nbsp; notIcerigiScrollBox.Position.Y = 100;</div><div>&nbsp; notIcerigiScrollBox.Width = 200;</div><div>&nbsp; notIcerigiScrollBox.Height = 150;</div><div>&nbsp; notIcerigiScrollBox.ShowScrollBars = True;&nbsp;</div><div><br></div><div>&nbsp; notIcerigiEdit = MyForm.AddNewProEdit(notIcerigiScrollBox, 'notIcerigiEdit', '');</div><div>&nbsp; notIcerigiEdit.Align = alTop;&nbsp;</div><div>&nbsp; notIcerigiEdit.Width = notIcerigiScrollBox.Width - 20;</div><div>&nbsp; notIcerigiEdit.Height = notIcerigiScrollBox.Height * 2;&nbsp;</div><div>&nbsp; notIcerigiEdit.Margins.Top = alTop;</div><div>&nbsp; notIcerigiEdit.TextSettings.VertAlign=1;</div><div>&nbsp; notIcerigiEdit.TextSettings.WordWrap=True;</div><div><br></div><div>&nbsp; kaydetButton = MyForm.AddNewProButton(MyForm, 'kaydetButton', 'Kaydet');</div><div>&nbsp; kaydetButton.Align = alNone;</div><div>&nbsp; kaydetButton.Position.X = 150;</div><div>&nbsp; kaydetButton.Position.Y = 270;</div><div>&nbsp; kaydetButton.Width = 100;</div><div>&nbsp; kaydetButton.Height = 40;</div><div>&nbsp; kaydetButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#4CAF50');</div><div>&nbsp; kaydetButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>&nbsp; kaydetButton.SetclProSettings(kaydetButton.clProSettings);</div><div>&nbsp;</div><div>&nbsp; if (Assigned(kaydetButton))&nbsp;</div><div>&nbsp; {</div><div>&nbsp; &nbsp; try</div><div>&nbsp; &nbsp; &nbsp; MyForm.AddNewEvent(kaydetButton, tbeOnClick, 'KaydetNot');</div><div>&nbsp; &nbsp; except</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Event bağlanırken bir hata oluştu.');</div><div>&nbsp; &nbsp; };</div><div>&nbsp; };</div><div><br></div><div>&nbsp;</div><div>&nbsp; MyForm.Run;</div><div>}</div><div><br></div><div><br></div><div>void GirisYap;</div><div>{</div><div>&nbsp; if not (Assigned(girisSayfa))</div><div>&nbsp; &nbsp; girisSayfa = TclForm.Create(Self);</div><div><br></div><div>&nbsp; girisSayfa.SetFormBGImage('<a href="https://i.hizliresim.com/phhojjq.jpg" target="_blank" rel="nofollow">https://i.hizliresim.com/phhojjq.jpg</a>');</div><div><br></div><div>nameG = girisSayfa.AddNewProEdit(girisSayfa, 'nameG', 'İsminiz:');</div><div>nameG.Margins.Top = 150;</div><div>nameG.Width = 350;</div><div>nameG.Height = 45;</div><div>nameG.clProSettings.RoundWidth = 20;</div><div>nameG.clProSettings.RoundHeight = 20;</div><div>nameG.SetclProSettings(nameG.clProSettings);</div><div><br></div><div>surnameG = girisSayfa.AddNewProEdit(girisSayfa, 'surnameG', 'Soyisminiz:');</div><div>surnameG.Margins.Top = 210;</div><div>surnameG.Width = 350;</div><div>surnameG.Height = 45;</div><div>surnameG.clProSettings.RoundWidth = 20;</div><div>surnameG.clProSettings.RoundHeight = 20;</div><div>surnameG.SetclProSettings(surnameG.clProSettings);</div><div><br></div><div>passwordG = girisSayfa.AddNewProEdit(girisSayfa, 'passwordG', 'Şifreniz:');</div><div>passwordG.Margins.Top = 270;</div><div>passwordG.Width = 350;</div><div>passwordG.Height = 45;</div><div>passwordG.clProSettings.RoundWidth = 20;</div><div>passwordG.clProSettings.RoundHeight = 20;</div><div>passwordG.Password = True;</div><div>passwordG.SetclProSettings(passwordG.clProSettings);</div><div><br></div><div>girisButton = girisSayfa.AddNewProButton(girisSayfa, 'girisButton', 'Giriş Yap');</div><div>girisButton.Margins.Top = 350;</div><div>girisButton.Width = 160;</div><div>girisButton.Height = 40;</div><div>girisButton.clProSettings.RoundWidth = 20;</div><div>girisButton.clProSettings.RoundHeight = 20;</div><div>girisButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#2196F3');</div><div>girisButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div><br></div><div>girisButton.SetclProSettings(girisButton.clProSettings);</div><div>girisSayfa.AddNewEvent(girisButton, tbeOnClick, 'KullaniciKontrolEt');</div><div><br></div><div>&nbsp; girisSayfa.Run;</div><div>}</div><div>void KayitOl;</div><div>{</div><div>&nbsp; if not (Assigned(kayitSayfa))</div><div>&nbsp; &nbsp; kayitSayfa = TclForm.Create(Self);</div><div><br></div><div>&nbsp; kayitSayfa.SetFormBGImage('<a href="https://i.hizliresim.com/phhojjq.jpg" target="_blank" rel="nofollow">https://i.hizliresim.com/phhojjq.jpg</a>');</div><div><br></div><div>&nbsp; nameK = kayitSayfa.AddNewProEdit(kayitSayfa, 'nameK', 'İsminiz:');</div><div>nameK.Margins.Top = 150;</div><div>nameK.Width = 350;</div><div>nameK.Height = 45;</div><div>nameK.clProSettings.RoundWidth = 20;</div><div>nameK.clProSettings.RoundHeight = 20;</div><div>nameK.SetclProSettings(nameK.clProSettings);</div><div><br></div><div>surnameK = kayitSayfa.AddNewProEdit(kayitSayfa, 'surnameK', 'Soyisminiz:');</div><div>surnameK.Margins.Top = 210;</div><div>surnameK.Width = 350;</div><div>surnameK.Height = 45;</div><div>surnameK.clProSettings.RoundWidth = 20;</div><div>surnameK.clProSettings.RoundHeight = 20;</div><div>surnameK.SetclProSettings(surnameK.clProSettings);</div><div><br></div><div>passwordK = kayitSayfa.AddNewProEdit(kayitSayfa, 'passwordK', 'Şifreniz:');</div><div>passwordK.Margins.Top = 270;</div><div>passwordK.Width = 350;</div><div>passwordK.Height = 45;</div><div>passwordK.clProSettings.RoundWidth = 20;</div><div>passwordK.clProSettings.RoundHeight = 20;</div><div>passwordK.Password = True;</div><div>passwordK.SetclProSettings(passwordK.clProSettings);</div><div><br></div><div>kayitButton = kayitSayfa.AddNewProButton(kayitSayfa, 'kayitButton', 'Kayıt Ol');</div><div>kayitButton.Margins.Top = 350;</div><div>kayitButton.Width = 160;</div><div>kayitButton.Height = 40;</div><div>kayitButton.clProSettings.RoundWidth = 20;</div><div>kayitButton.clProSettings.RoundHeight = 20;</div><div>kayitButton.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#4CAF50');</div><div>kayitButton.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>kayitButton.SetclProSettings(kayitButton.clProSettings);</div><div>kayitSayfa.AddNewEvent(kayitButton, tbeOnClick, 'SqLiteInsertUser');</div><div><br></div><div>&nbsp; kayitSayfa.Run;</div><div>}</div><div><br></div><div>void SqLiteInsertUser;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp; &nbsp;Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath+'MuhabirMobil.db', '');</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp; ShowMessage('Veritabanına bağlanıldı.');</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</div><div>&nbsp; &nbsp; 'SELECT * FROM Users WHERE user_name = ' + QuotedStr(nameK.Text) +&nbsp;</div><div>&nbsp; &nbsp; ' AND user_surname = ' + QuotedStr(surnameK.Text);</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; if not (Clomosy.DBSQLiteQuery.Found)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</div><div>&nbsp; &nbsp; &nbsp; 'INSERT INTO Users (user_name, user_surname, user_password) VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(nameK.Text) + ', ' + QuotedStr(surnameK.Text) + ', ' + QuotedStr(passwordK.Text) + ');';</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Başarılı bir şekilde kayıt olundu!');</div><div>&nbsp; &nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; kayitSayfa.clHide;&nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; GirisYap;&nbsp;&nbsp;</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Bu kullanıcı zaten mevcut.');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Kayıt sırasında bir hata oluştu: ' + LastExceptionMessage);</div><div>}</div><div>}</div><div><br></div><div>void SqLiteConnectionCreateTable;</div><div>var</div><div>&nbsp; TableExists: Boolean;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath+'MuhabirMobil.db', '');</div><div>&nbsp; &nbsp; ShowMessage('Veritabanına bağlanıldı.');</div><div><br></div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'SELECT name FROM sqlite_master WHERE type="table" AND name="Users";';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; TableExists = not (Clomosy.DBSQLiteQuery.Eof);</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; if not (TableExists)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'CREATE TABLE Users(user_id INTEGER PRIMARY KEY AUTOINCREMENT, user_name TEXT, user_surname TEXT, user_password TEXT)';</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kullanıcı tablosu başarıyla oluşturuldu!');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kullanıcı tablosu zaten mevcut.');</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'SELECT name FROM sqlite_master WHERE type="table" AND name="Notes";';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp; TableExists = not (Clomosy.DBSQLiteQuery.Eof);</div><div><br></div><div>&nbsp; &nbsp; if not (TableExists)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text =&nbsp;</div><div>&nbsp; &nbsp; &nbsp; 'CREATE TABLE Notes(' +</div><div>&nbsp; &nbsp; &nbsp; 'note_id INTEGER PRIMARY KEY AUTOINCREMENT, ' +</div><div>&nbsp; &nbsp; &nbsp; 'note_title TEXT, ' +</div><div>&nbsp; &nbsp; &nbsp; 'note_content TEXT)';</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Notes tablosu başarıyla oluşturuldu!');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Notes tablosu zaten mevcut.');</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; except</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp; ShowMessage('Veritabanı işlemleri sırasında bir hata oluştu: ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div><br></div><div>void KullaniciKontrolEt;</div><div>var</div><div>&nbsp; Qry: TClSQLiteQuery;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp; &nbsp;Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath+'MuhabirMobil.db', '');</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; ShowMessage('Veritabanına bağlanıldı.');</div><div><br></div><div>&nbsp; &nbsp; Qry = Clomosy.DBSQLiteQueryWith(</div><div>&nbsp; &nbsp; &nbsp; 'SELECT * FROM Users WHERE user_name = ' + QuotedStr(nameG.Text) +&nbsp;</div><div>&nbsp; &nbsp; &nbsp; ' AND user_surname = ' + QuotedStr(surnameG.Text) +&nbsp;</div><div>&nbsp; &nbsp; &nbsp; ' AND user_password = ' + QuotedStr(passwordG.Text));</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; Qry.OpenOrExecute;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; if (Qry.Found)</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Başarılı bir şekilde giriş yapıldı!');</div><div>&nbsp; &nbsp; &nbsp; girisSayfa.clHide;&nbsp;</div><div>&nbsp; &nbsp; &nbsp; ShowPostLoginScreen(nameG.Text);&nbsp;&nbsp;</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kullanıcı bulunamadı. Lütfen tekrar deneyin.');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Giriş sırasında bir hata oluştu: ' + LastExceptionMessage);</div><div>}</div><div>}</div><div><br></div><div>{</div><div>&nbsp; SqLiteConnectionCreateTable;&nbsp;</div><div>&nbsp; ShowAnaSayfa;&nbsp;</div><div>}</div><div><br></div><div><br></div>]]>
   </description>
   <pubDate>Thu, 29 Aug 2024 15:42:26 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=918&amp;PID=1764#1764</guid>
  </item> 
 </channel>
</rss>