<?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 : SqlLite Insert</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : SqlLite Insert]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 14:37:33 +0000</pubDate>
  <lastBuildDate>Fri, 09 Aug 2024 15:05:13 +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=854</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[SqlLite Insert : Te&#351;ekk&#252;rler ]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=854&amp;PID=1610#1610</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=205">cafer kosker</a><br /><strong>Konu:</strong> 854<br /><strong>Gönderim Zamanı:</strong> 09&nbsp;Ağustos&nbsp;2024 Saat 15:05<br /><br />Teşekkürler]]>
   </description>
   <pubDate>Fri, 09 Aug 2024 15:05:13 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=854&amp;PID=1610#1610</guid>
  </item> 
  <item>
   <title><![CDATA[SqlLite Insert : Merhaba Cafer, { database = Clomosy.AppFilesPath...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=854&amp;PID=1609#1609</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=142">BilalCndn</a><br /><strong>Konu:</strong> 854<br /><strong>Gönderim Zamanı:</strong> 09&nbsp;Ağustos&nbsp;2024 Saat 11:57<br /><br />Merhaba Cafer,<div><br></div><div><table width="99%"><tr><td><pre class="BBcode"></div><div><div>{</div><div>&nbsp; database = Clomosy.AppFilesPath + 'ClomosyDatabase.db3' &nbsp; &nbsp; //'D:\SQLite Databases\ClomosyDatabase.db'</div><div>&nbsp; password = '';</div><div>&nbsp;&nbsp;</div><div>&nbsp; try</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteConnect(database, password);</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; // SQLite için tablo oluşturma</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'CREATE TABLE IF NOT EXISTS KaydolBilgiOrnek (İsim TEXT NOT NULL, Soyisim TEXT NOT NULL, Telefon TEXT NOT NULL, Eposta TEXT NOT NULL, Parola TEXT NOT NULL, DogumTarihi TEXT NOT NULL)';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; ShowMessage('Veritabanına tablo ekleme işlemi başarılı!');</div><div>&nbsp; &nbsp; //InsertExampleData;</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Exception Class: '+LastExceptionClassName+' Exception Message: '+LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div></div><div></pre></td></tr></table></div><div><br></div><div>Bu kısımda bir void oluşturmadan kod bloğu açmışsın hata alma sebebin bu.</div>]]>
   </description>
   <pubDate>Fri, 09 Aug 2024 11:57:45 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=854&amp;PID=1609#1609</guid>
  </item> 
  <item>
   <title><![CDATA[SqlLite Insert : var KayitForm: TclForm; KayitEmailEdit,...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=854&amp;PID=1608#1608</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=205">cafer kosker</a><br /><strong>Konu:</strong> 854<br /><strong>Gönderim Zamanı:</strong> 09&nbsp;Ağustos&nbsp;2024 Saat 11:11<br /><br /><div><br></div><div>var</div><div>&nbsp; KayitForm: TclForm;</div><div>&nbsp; KayitEmailEdit, KayitParolaEdit,KayitIsimEdit,KayitSoyisimEdit,KayitTelefonEdit : TclProEdit;</div><div>&nbsp; KayitKaydolBtn,KayitHiddenPasswordBtn,KayitNormalPasswordBtn: TClProButton;</div><div>&nbsp; KayitUyeOlLbl : TClProLabel;</div><div>&nbsp; KayitPnl: TclProPanel;</div><div>&nbsp; KayitLogo:TClProImage;</div><div>&nbsp; YasEdit : TClProDateEdit;</div><div>&nbsp; KayitEmailImg,KayitpasswordImg,KayitIsimImg,KayitSoyisimImg,YasEditImg,KayitTelefonEditImg : TClProImage;</div><div>&nbsp; Qry : TClSQLiteQuery;</div><div>&nbsp; gun,ay,yil, dogruTarih: TclString;</div><div>&nbsp; KayitVerticalScrollBox: TclVertScrollBox;</div><div>&nbsp; database, password : String;</div><div>&nbsp;&nbsp;</div><div>{</div><div>&nbsp; database = Clomosy.AppFilesPath + 'ClomosyDatabase.db3' &nbsp; &nbsp; //'D:\SQLite Databases\ClomosyDatabase.db'</div><div>&nbsp; password = '';</div><div>&nbsp;&nbsp;</div><div>&nbsp; try</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteConnect(database, password);</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; // SQLite için tablo oluşturma</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.Sql.Text = 'CREATE TABLE IF NOT EXISTS KaydolBilgiOrnek (İsim TEXT NOT NULL, Soyisim TEXT NOT NULL, Telefon TEXT NOT NULL, Eposta TEXT NOT NULL, Parola TEXT NOT NULL, DogumTarihi TEXT NOT NULL)';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; ShowMessage('Veritabanına tablo ekleme işlemi başarılı!');</div><div>&nbsp; &nbsp; //InsertExampleData;</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Exception Class: '+LastExceptionClassName+' Exception Message: '+LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div><br></div><div>void InsertExampleData;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.SQL.Text = '</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''Mehmet'', ''Öden'', ''05369937353'', ''odenmehmet70@gmail.com'', ''12345678'', ''2003-06-28'');</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''Cafer'', ''Kösker'', ''05535423484'', ''caferkos7@gmail.com'', ''admin1234'', ''2003-07-14'');</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''Ali Berkay'', ''Sasi'', ''05068892277'', ''aliberkay@gmail.com'', ''a123123'', ''2001-10-08'');</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''Ertan'', ''Kösker'', ''05359778285'', ''ertankos@hotmail.com'', ''ertan1234'', ''1980-02-28'');</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''Emre'', ''Keser'', ''05453822111'', ''emrekeser@gmail.com'', ''EmreKeser2003'', ''2003-06-06'');</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''Mirkan'', ''Özdemir'', ''05531394067'', ''mirkanözdemir@yahoo.com'', ''mirkanOz04'', ''2004-05-18'');</div><div>&nbsp; &nbsp; INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) VALUES (''A'', ''A'', ''05359778584'', ''A'', ''a'', ''2024-07-31'');';</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; ShowMessage('Veri ekleme başarılı!');</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Exception Class: '+LastExceptionClassName+' Exception Message: '+LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div><br></div><div>void InsertDataBase;</div><div>{</div><div>&nbsp; gun = clGetStringTo(YasEdit.Date,'.');</div><div>&nbsp; yil = clGetStringAfter(YasEdit.Date, '.');</div><div>&nbsp; ay = clGetStringTo(yil, '.');</div><div>&nbsp; yil = clGetStringAfter(yil, '.');</div><div>&nbsp;&nbsp;</div><div>&nbsp; dogruTarih = yil + '-' + ay + '-' + gun;</div><div><br></div><div>&nbsp; try</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.SQL.Text =</div><div>&nbsp; &nbsp; &nbsp; 'INSERT INTO KaydolBilgiOrnek (İsim, Soyisim, Telefon, Eposta, Parola, DogumTarihi) ' +</div><div>&nbsp; &nbsp; &nbsp; 'VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(KayitIsimEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(KayitSoyisimEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(KayitTelefonEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(KayitEmailEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(KayitParolaEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(dogruTarih) + // Dönüştürülmüş tarih değeri</div><div>&nbsp; &nbsp; &nbsp; ');';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; ShowMessage('Kullanıcı Ekleme Başarılı');</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Exception Class : ' + LastExceptionClassName + ' Exception Message : ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div>void KayitHiddenPasswordBtnClick;</div><div>{</div><div>&nbsp; if not Assigned(KayitNormalPasswordBtn)&nbsp;</div><div>&nbsp; {</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn = KayitForm.AddNewProButton(KayitParolaEdit, 'KayitNormalPasswordBtn', '');</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Align = alRight;</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Margins.Right = 10;</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Margins.Top = 5;</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Margins.Bottom = 5;</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Width = 25;</div><div>&nbsp; &nbsp; KayitForm.SetImage(KayitNormalPasswordBtn, '<a href="https://i.imgur.com/3h7ewO1.png" target="_blank" rel="nofollow">https://i.imgur.com/3h7ewO1.png</a>');</div><div>&nbsp; &nbsp; KayitForm.AddNewEvent(KayitNormalPasswordBtn, tbeOnClick, 'KayitNormalPasswordBtnClick');</div><div>&nbsp; }</div><div>&nbsp; else</div><div>&nbsp; {</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Visible = True;</div><div>&nbsp; }</div><div><br></div><div>&nbsp; KayitParolaEdit.Password = False;</div><div>&nbsp; KayitHiddenPasswordBtn.Visible = False;</div><div>}</div><div><br></div><div><br></div><div>void KayitNormalPasswordBtnClick;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; &nbsp; if not Assigned(KayitHiddenPasswordBtn)&nbsp;</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn = KayitForm.AddNewProButton(KayitParolaEdit, 'KayitHiddenPasswordBtn', '');</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn.Align = alRight;</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn.Margins.Right = 10;</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn.Margins.Top = 5;</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn.Margins.Bottom = 5;</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn.Width = 25;</div><div>&nbsp; &nbsp; &nbsp; KayitForm.SetImage(KayitHiddenPasswordBtn, '<a href="https://i.imgur.com/dQ1keru.png" target="_blank" rel="nofollow">https://i.imgur.com/dQ1keru.png</a>');</div><div>&nbsp; &nbsp; &nbsp; KayitForm.AddNewEvent(KayitHiddenPasswordBtn, tbeOnClick, 'KayitHiddenPasswordBtnClick');</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; else</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; KayitHiddenPasswordBtn.Visible = True;</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; KayitParolaEdit.Password = True;</div><div>&nbsp; &nbsp; KayitNormalPasswordBtn.Visible = False;</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Exception Class: ' + LastExceptionClassName + ' Exception Message: ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div><br></div><div><br></div><div><br></div><div><br></div><div>{</div><div>&nbsp; KayitForm= TclForm.Create(Self);</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitPnl = KayitForm.AddNewProPanel(KayitForm, 'KayitPnl');</div><div>&nbsp; KayitPnl.Align = alCenter;</div><div>&nbsp; KayitPnl.Height = 830;</div><div>&nbsp; KayitPnl.Width = 400;</div><div>&nbsp; KayitPnl.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitPnl.SetclProSettings(KayitPnl.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitVerticalScrollBox = KayitForm.AddNewVertScrollBox(KayitPnl,'KayitVerticalScrollBox');</div><div>&nbsp; KayitVerticalScrollBox.Align = alClient;</div><div>&nbsp; KayitVerticalScrollBox.Margins.Top = 20;</div><div>&nbsp; KayitVerticalScrollBox.Margins.Bottom = 10;</div><div>&nbsp; KayitVerticalScrollBox.Margins.Right = 10;</div><div>&nbsp; KayitVerticalScrollBox.Margins.Left = 10;</div><div><br></div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitLogo = KayitForm.AddNewProImage(KayitVerticalScrollBox,'KayitLogo');</div><div>&nbsp; KayitLogo.Align = alMostTop;</div><div>&nbsp; KayitLogo.Height = 220;</div><div>&nbsp; KayitLogo.Margins.Top =10;</div><div>&nbsp; KayitLogo.Margins.Left = 20;</div><div>&nbsp; KayitLogo.Margins.Right = 20;</div><div>&nbsp; KayitLogo.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitLogo.clProSettings.PictureSource = '<a href="https://i.imgur.com/bB7XC76.png" target="_blank" rel="nofollow">https://i.imgur.com/bB7XC76.png</a>';</div><div>&nbsp; KayitLogo.SetclProSettings(KayitLogo.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitIsimEdit = KayitForm.AddNewProEdit(KayitVerticalScrollBox, 'KayitIsimEdit', 'İsim');</div><div>&nbsp; KayitIsimEdit.Align = alTop;</div><div>&nbsp; KayitIsimEdit.Height = 50;</div><div>&nbsp; KayitIsimEdit.Margins.Top =20;</div><div>&nbsp; KayitIsimEdit.Margins.Left = 20;</div><div>&nbsp; KayitIsimEdit.Margins.Right = 20;</div><div>&nbsp; KayitIsimEdit.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#5AB2FF');</div><div>&nbsp; KayitIsimEdit.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitIsimEdit.clProSettings.IsFill = False;</div><div>&nbsp; KayitIsimEdit.clProSettings.IsRound = True;</div><div>&nbsp; KayitIsimEdit.clProSettings.RoundHeight = 10;</div><div>&nbsp; KayitIsimEdit.clProSettings.RoundWidth = 10;</div><div>&nbsp; KayitIsimEdit.TextSettings.Font.Size = 16;</div><div>&nbsp; KayitIsimEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitIsimEdit.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitIsimEdit.clProSettings.BorderWidth = 2;</div><div>&nbsp; KayitIsimEdit.SetclProSettings(KayitIsimEdit.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitIsimImg = KayitForm.AddNewProImage(KayitIsimEdit,'KayitIsimImg');</div><div>&nbsp; KayitIsimImg.Align = alLeft;</div><div>&nbsp; KayitIsimImg.Margins.Left = 10;</div><div>&nbsp; KayitIsimImg.Margins.Top = 5;</div><div>&nbsp; KayitIsimImg.Margins.Bottom =5;</div><div>&nbsp; KayitIsimImg.Width = 25;</div><div>&nbsp; KayitForm.SetImage(KayitIsimImg,'<a href="https://i.imgur.com/Xbs3SUh.png" target="_blank" rel="nofollow">https://i.imgur.com/Xbs3SUh.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitSoyisimEdit = KayitForm.AddNewProEdit(KayitVerticalScrollBox, 'KayitSoyisimEdit', 'Soyisim');</div><div>&nbsp; KayitSoyisimEdit.Align = alTop;</div><div>&nbsp; KayitSoyisimEdit.Height = 50;</div><div>&nbsp; KayitSoyisimEdit.Margins.Top =20;</div><div>&nbsp; KayitSoyisimEdit.Margins.Left = 20;</div><div>&nbsp; KayitSoyisimEdit.Margins.Right = 20;</div><div>&nbsp; KayitSoyisimEdit.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#80AF81');</div><div>&nbsp; KayitSoyisimEdit.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitSoyisimEdit.clProSettings.IsFill = False;</div><div>&nbsp; KayitSoyisimEdit.clProSettings.IsRound = True;</div><div>&nbsp; KayitSoyisimEdit.clProSettings.RoundHeight = 10;</div><div>&nbsp; KayitSoyisimEdit.clProSettings.RoundWidth = 10;</div><div>&nbsp; KayitSoyisimEdit.TextSettings.Font.Size = 16;</div><div>&nbsp; KayitSoyisimEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitSoyisimEdit.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitSoyisimEdit.clProSettings.BorderWidth = 2;</div><div>&nbsp; KayitSoyisimEdit.SetclProSettings(KayitSoyisimEdit.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitSoyisimImg = KayitForm.AddNewProImage(KayitSoyisimEdit,'KayitSoyisimImg');</div><div>&nbsp; KayitSoyisimImg.Align = alLeft;</div><div>&nbsp; KayitSoyisimImg.Margins.Left = 10;</div><div>&nbsp; KayitSoyisimImg.Margins.Top = 5;</div><div>&nbsp; KayitSoyisimImg.Margins.Bottom =5;</div><div>&nbsp; KayitSoyisimImg.Width = 25;</div><div>&nbsp; KayitForm.SetImage(KayitSoyisimImg,'<a href="https://i.imgur.com/elfB1uV.png" target="_blank" rel="nofollow">https://i.imgur.com/elfB1uV.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitTelefonEdit = KayitForm.AddNewProEdit(KayitVerticalScrollBox, 'KayitTelefonEdit', 'Telefon');</div><div>&nbsp; KayitTelefonEdit.Align = alTop;</div><div>&nbsp; KayitTelefonEdit.Height = 50;</div><div>&nbsp; KayitTelefonEdit.Margins.Top =20;</div><div>&nbsp; KayitTelefonEdit.Margins.Left = 20;</div><div>&nbsp; KayitTelefonEdit.Margins.Right = 20;</div><div>&nbsp; KayitTelefonEdit.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#B4B4B8');</div><div>&nbsp; KayitTelefonEdit.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitTelefonEdit.clProSettings.IsFill = False;</div><div>&nbsp; KayitTelefonEdit.clProSettings.IsRound = True;</div><div>&nbsp; KayitTelefonEdit.clProSettings.RoundHeight = 10;</div><div>&nbsp; KayitTelefonEdit.clProSettings.RoundWidth = 10;</div><div>&nbsp; KayitTelefonEdit.TextSettings.Font.Size = 16;</div><div>&nbsp; KayitTelefonEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitTelefonEdit.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitTelefonEdit.clProSettings.BorderWidth = 2;</div><div>&nbsp; KayitTelefonEdit.SetclProSettings(KayitTelefonEdit.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitTelefonEditImg = KayitForm.AddNewProImage(KayitTelefonEdit,'KayitTelefonEditImg');</div><div>&nbsp; KayitTelefonEditImg.Align = alLeft;</div><div>&nbsp; KayitTelefonEditImg.Margins.Left = 10;</div><div>&nbsp; KayitTelefonEditImg.Margins.Top = 5;</div><div>&nbsp; KayitTelefonEditImg.Margins.Bottom =5;</div><div>&nbsp; KayitTelefonEditImg.Width = 25;</div><div>&nbsp; KayitForm.SetImage(KayitTelefonEditImg,'<a href="https://i.imgur.com/PrNjEw2.png" target="_blank" rel="nofollow">https://i.imgur.com/PrNjEw2.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; // Kullanıcı adı edit ayarları</div><div>&nbsp; KayitEmailEdit = KayitForm.AddNewProEdit(KayitVerticalScrollBox, 'KayitEmailEdit', 'E-posta');</div><div>&nbsp; KayitEmailEdit.Align = alTop;</div><div>&nbsp; KayitEmailEdit.Height = 50;</div><div>&nbsp; KayitEmailEdit.Margins.Top =20;</div><div>&nbsp; KayitEmailEdit.Margins.Left = 20;</div><div>&nbsp; KayitEmailEdit.Margins.Right = 20;</div><div>&nbsp; KayitEmailEdit.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#EE4E4E');</div><div>&nbsp; KayitEmailEdit.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitEmailEdit.clProSettings.IsFill = False;</div><div>&nbsp; KayitEmailEdit.clProSettings.IsRound = True;</div><div>&nbsp; KayitEmailEdit.clProSettings.RoundHeight = 10;</div><div>&nbsp; KayitEmailEdit.clProSettings.RoundWidth = 10;</div><div>&nbsp; KayitEmailEdit.TextSettings.Font.Size = 16;</div><div>&nbsp; KayitEmailEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitEmailEdit.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitEmailEdit.clProSettings.BorderWidth = 2;</div><div>&nbsp; KayitEmailEdit.SetclProSettings(KayitEmailEdit.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitEmailImg = KayitForm.AddNewProImage(KayitEmailEdit,'KayitEmailImg');</div><div>&nbsp; KayitEmailImg.Align = alLeft;</div><div>&nbsp; KayitEmailImg.Margins.Left = 10;</div><div>&nbsp; KayitEmailImg.Margins.Top = 5;</div><div>&nbsp; KayitEmailImg.Margins.Bottom =5;</div><div>&nbsp; KayitEmailImg.Width = 25;</div><div>&nbsp; KayitForm.SetImage(KayitEmailImg,'<a href="https://i.imgur.com/g9t6md5.png" target="_blank" rel="nofollow">https://i.imgur.com/g9t6md5.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp; // Şifre edit ayarları</div><div>&nbsp; KayitParolaEdit = KayitForm.AddNewProEdit(KayitVerticalScrollBox, 'KayitParolaEdit', 'Parola');</div><div>&nbsp; KayitParolaEdit.Align = alTop;</div><div>&nbsp; KayitParolaEdit.Height = 50;</div><div>&nbsp; KayitParolaEdit.Margins.Top =20;</div><div>&nbsp; KayitParolaEdit.Margins.Left = 20;</div><div>&nbsp; KayitParolaEdit.Margins.Right = 20;</div><div>&nbsp; KayitParolaEdit.Password = True;</div><div>&nbsp; KayitParolaEdit.TextSettings.Font.Size = 16;</div><div>&nbsp; KayitParolaEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#151515');</div><div>&nbsp; KayitParolaEdit.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#F3F7EC');</div><div>&nbsp; KayitParolaEdit.clProSettings.IsTransparent = True;</div><div>&nbsp; KayitParolaEdit.clProSettings.IsFill = False;</div><div>&nbsp; KayitParolaEdit.clProSettings.IsRound = True;</div><div>&nbsp; KayitParolaEdit.clProSettings.RoundHeight = 10;</div><div>&nbsp; KayitParolaEdit.clProSettings.RoundWidth = 10;</div><div>&nbsp; KayitParolaEdit.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitParolaEdit.clProSettings.BorderWidth = 2;</div><div>&nbsp; KayitParolaEdit.SetclProSettings(KayitParolaEdit.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitHiddenPasswordBtn = KayitForm.AddNewProButton(KayitParolaEdit,'KayitHiddenPasswordBtn', '');</div><div>&nbsp; KayitHiddenPasswordBtn.Align = alRight;</div><div>&nbsp; KayitHiddenPasswordBtn.Margins.Right = 10 ;</div><div>&nbsp; KayitHiddenPasswordBtn.Margins.Top =5 ;</div><div>&nbsp; KayitHiddenPasswordBtn.Margins.Bottom = 5 ;</div><div>&nbsp; KayitHiddenPasswordBtn.Width = 25;</div><div>&nbsp; KayitForm.SetImage(KayitHiddenPasswordBtn,'<a href="https://i.imgur.com/dQ1keru.png" target="_blank" rel="nofollow">https://i.imgur.com/dQ1keru.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitpasswordImg = KayitForm.AddNewProImage(KayitParolaEdit,'KayitpasswordImg');</div><div>&nbsp; KayitpasswordImg.Align = alLeft;</div><div>&nbsp; KayitpasswordImg.Margins.Left = 10;</div><div>&nbsp; KayitpasswordImg.Margins.Top = 5;</div><div>&nbsp; KayitpasswordImg.Margins.Bottom =5;</div><div>&nbsp; KayitpasswordImg.Width = 25;</div><div>&nbsp; KayitForm.SetImage(KayitpasswordImg,'<a href="https://i.imgur.com/G2qFyZf.png" target="_blank" rel="nofollow">https://i.imgur.com/G2qFyZf.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; YasEdit = KayitForm.AddNewProDateEdit(KayitVerticalScrollBox, 'YasEdit');</div><div>&nbsp; YasEdit.Align = alTop;</div><div>&nbsp; YasEdit.Height = 50;</div><div>&nbsp; YasEdit.Margins.Top =20;</div><div>&nbsp; YasEdit.Margins.Left = 20;</div><div>&nbsp; YasEdit.Margins.Right = 20;</div><div>&nbsp; YasEdit.TextSettings.Font.Size = 40;</div><div>&nbsp; YasEdit.clProSettings.FontVertAlign = palcenter;</div><div>&nbsp; YasEdit.clProSettings.FontHorzAlign = palcenter;</div><div>&nbsp; YasEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#151515');</div><div>&nbsp; YasEdit.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#AF8260');</div><div>&nbsp; YasEdit.clProSettings.IsTransparent = True;</div><div>&nbsp; YasEdit.clProSettings.IsFill = False;</div><div>&nbsp; YasEdit.clProSettings.IsRound = True;</div><div>&nbsp; YasEdit.clProSettings.RoundHeight = 10;</div><div>&nbsp; YasEdit.clProSettings.RoundWidth = 10;</div><div>&nbsp; YasEdit.clProSettings.FontColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; YasEdit.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; YasEdit.clProSettings.BorderWidth = 2;</div><div>&nbsp; YasEdit.SetclProSettings(YasEdit.clProSettings);</div><div><br></div><div>&nbsp; YasEditImg = KayitForm.AddNewProImage(YasEdit ,'YasEditImg');</div><div>&nbsp; YasEditImg.Align = alLeft;</div><div>&nbsp; YasEditImg.Margins.Left = 10;</div><div>&nbsp; YasEditImg.Margins.Top = 5;</div><div>&nbsp; YasEditImg.Margins.Bottom =5;</div><div>&nbsp; YasEditImg.Width = 25;</div><div>&nbsp; KayitForm.SetImage(YasEditImg,'<a href="https://i.imgur.com/sfIaXkU.png" target="_blank" rel="nofollow">https://i.imgur.com/sfIaXkU.png</a>');</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div><br></div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div><br></div><div>&nbsp; // Kayıt ol butonu ayarları</div><div>&nbsp; KayitKaydolBtn = KayitForm.AddNewProButton(KayitVerticalScrollBox, 'KayitKaydolBtn', 'Kayıt Ol');</div><div>&nbsp; KayitKaydolBtn.Align = alCenter;</div><div>&nbsp; KayitKaydolBtn.Height = 50;</div><div>&nbsp; KayitKaydolBtn.Width = KayitPnl.Width*40/100;</div><div>&nbsp; KayitKaydolBtn.Margins.Top =50;</div><div>&nbsp; KayitKaydolBtn.Margins.Left = 20;</div><div>&nbsp; KayitKaydolBtn.Margins.Right = 20;</div><div>&nbsp; KayitKaydolBtn.Margins.Bottom = 70;</div><div>&nbsp; KayitKaydolBtn.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#EE4E4E');</div><div>&nbsp; KayitKaydolBtn.clProSettings.RoundHeight = 10;</div><div>&nbsp; KayitKaydolBtn.clProSettings.RoundWidth = 10;</div><div>&nbsp; KayitKaydolBtn.clProSettings.FontColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitKaydolBtn.clProSettings.BorderColor = clAlphaColor.clHexToColor('#070807');</div><div>&nbsp; KayitKaydolBtn.clProSettings.FontSize = 16;</div><div>&nbsp; KayitKaydolBtn.clProSettings.BorderWidth = 2;</div><div>&nbsp; KayitKaydolBtn.SetclProSettings(KayitKaydolBtn.clProSettings);</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div><br></div><div>&nbsp; KayitForm.SetFormBGImage('<a href="https://i.imgur.com/IKFa7gu.jpeg" target="_blank" rel="nofollow">https://i.imgur.com/IKFa7gu.jpeg</a>');</div><div>&nbsp; KayitForm.AddNewEvent(KayitHiddenPasswordBtn,tbeOnClick,'KayitHiddenPasswordBtnClick');</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitForm.AddNewEvent(KayitKaydolBtn,tbeOnClick,'InsertDataBase');</div><div>&nbsp;&nbsp;</div><div>&nbsp;&nbsp;</div><div>&nbsp; Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath + 'ClomosyDatabase.db3', '');</div><div>&nbsp;&nbsp;</div><div>&nbsp; KayitForm.Run;</div><div>}</div><div><br></div><div><br></div><div><b><font color="#990000">Tablo başarılı bir şekilde oluşuyor sql bağlanıyor fakat veri insert de sıkıntı çıkıyor galiba</font></b></div>]]>
   </description>
   <pubDate>Fri, 09 Aug 2024 11:11:33 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=854&amp;PID=1608#1608</guid>
  </item> 
 </channel>
</rss>