<?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 : execute select hatası</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : execute select hatası]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 12:41:17 +0000</pubDate>
  <lastBuildDate>Wed, 23 Jul 2025 15:51:21 +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=1125</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[execute select hatası : Merhaba K&#252;bra , ben a&#351;a&#287;&#305;daki...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2318#2318</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=310">Sudesigirci</a><br /><strong>Konu:</strong> 1125<br /><strong>Gönderim Zamanı:</strong> 23&nbsp;Temmuz&nbsp;2025 Saat 15:51<br /><br />Merhaba Kübra , ben aşağıdaki şekilde entegre ettiğimde bir sorun yaşamadım kodu tekrar deneyebilir misin aşağıdaki şekilde&nbsp;<div><div><br></div><div>void RegisterBtnClick;</div><div>{</div><div><br></div><div>&nbsp;&nbsp;</div><div>&nbsp; &nbsp; &nbsp;if Length(Trim(UsernameEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PasswordEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PasswordAgainEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(EmailEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PhoneEdit.Text)) &lt; 10 ||</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PlateEdit.Text)) == 0</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Lütfen tüm alanları doldurun.');</div><div>&nbsp; &nbsp; &nbsp; Exit;</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; if PasswordEdit.Text &lt;&gt; PasswordAgainEdit.Text</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Şifreler uyuşmuyor!');</div><div>&nbsp; &nbsp; &nbsp; Exit;</div><div>&nbsp; &nbsp; }</div><div>&nbsp;&nbsp;</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.SQL.Text='CREATE TABLE IF NOT EXISTS Users (' +</div><div>&nbsp; &nbsp; &nbsp; 'ID INTEGER PRIMARY KEY AUTOINCREMENT, ' +</div><div>&nbsp; &nbsp; &nbsp; 'Username TEXT, Password TEXT, Email TEXT, Phone TEXT, Plate TEXT)';</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.SQL.Text='SELECT * FROM Users WHERE Username = ' + QuotedStr(UsernameEdit.Text);</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp; if (Clomosy.DBSQLiteQuery.Found ){</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Bu kullanıcı adı zaten kayıtlı!');</div><div>&nbsp; &nbsp; &nbsp; exit;</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp;&nbsp;</div><div>&nbsp; &nbsp;Clomosy.DBSQLiteQuery.SQL.Text =</div><div>&nbsp; &nbsp; &nbsp; 'INSERT INTO Users (Username, Password, Email, Phone, Plate) VALUES (' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(UsernameEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(PasswordEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(EmailEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(PhoneEdit.Text) + ',' +</div><div>&nbsp; &nbsp; &nbsp; QuotedStr(PlateEdit.Text) + ')';</div><div>&nbsp; &nbsp; &nbsp;&nbsp;</div><div>&nbsp; &nbsp; try</div><div>&nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; ShowMessage('Kayıt başarılı!');</div><div>&nbsp; &nbsp; Clomosy.RunUnit('UnitLogin');</div><div>&nbsp;&nbsp;</div><div>&nbsp; except</div><div>&nbsp;&nbsp;</div><div>&nbsp; &nbsp; ShowMessage('Hata oluştu: ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div></div><div><br></div>]]>
   </description>
   <pubDate>Wed, 23 Jul 2025 15:51:21 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2318#2318</guid>
  </item> 
  <item>
   <title><![CDATA[execute select hatası : Merhaba, yazd&#305;&#287;&#305;n &#351;ekilde denedim...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2317#2317</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=331">kübra</a><br /><strong>Konu:</strong> 1125<br /><strong>Gönderim Zamanı:</strong> 23&nbsp;Temmuz&nbsp;2025 Saat 14:35<br /><br />Merhaba, yazdığın şekilde denedim ama hala aynı hatayı veriyor.]]>
   </description>
   <pubDate>Wed, 23 Jul 2025 14:35:19 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2317#2317</guid>
  </item> 
  <item>
   <title><![CDATA[execute select hatası : Merhaba K&#252;bra , Clomosy.DBSQLiteQuery.SQL.Text...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2316#2316</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=310">Sudesigirci</a><br /><strong>Konu:</strong> 1125<br /><strong>Gönderim Zamanı:</strong> 23&nbsp;Temmuz&nbsp;2025 Saat 14:22<br /><br /><div>Merhaba Kübra ,&nbsp; &nbsp;</div><div>Clomosy.DBSQLiteQuery.SQL.Text =&nbsp;</div><div>&nbsp; &nbsp; &nbsp; 'INSERT INTO Users (Username, Password, Email, Phone,Plate) VALUES (' +</div><div><div style=": rgb251, 251, 253;">&nbsp; QuotedStr(UsernameEdit.Text) + ', ' +</div><div style=": rgb251, 251, 253;">&nbsp; QuotedStr(PasswordEdit.Text) + ', ' +</div><div style=": rgb251, 251, 253;">&nbsp; QuotedStr(EmailEdit.Text) + ', ' +</div><div style=": rgb251, 251, 253;">&nbsp; QuotedStr(PhoneEdit.Text) + ', ' +</div><div style=": rgb251, 251, 253;">&nbsp; QuotedStr(PlateEdit.Text) + '); ' +</div><div style=": rgb251, 251, 253;">&nbsp; 'SELECT "" as dummy');</div></div><div><br></div><div>&nbsp; &nbsp; try</div><div>&nbsp; &nbsp; &nbsp; Clomosy.DBSQLiteQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Kayıt başarıyla tamamlandı.');</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Clomosy.RunUnit('UnitLogin');</div><div>&nbsp; &nbsp; except</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Exception class: ' + LastExceptionClassName + ' Exception Message: ' + LastExceptionMessage);</div><div>&nbsp; &nbsp; } bunu koduna entegre edip deneyebilir misin&nbsp;</div><div>iyi çalışmalar dilerim</div>]]>
   </description>
   <pubDate>Wed, 23 Jul 2025 14:22:50 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2316#2316</guid>
  </item> 
  <item>
   <title><![CDATA[execute select hatası : var RegisterForm: TclForm; UsernameEdit,...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2315#2315</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=331">kübra</a><br /><strong>Konu:</strong> 1125<br /><strong>Gönderim Zamanı:</strong> 23&nbsp;Temmuz&nbsp;2025 Saat 13:49<br /><br /><div>var&nbsp;</div><div>&nbsp; RegisterForm: TclForm;</div><div>&nbsp; UsernameEdit, PasswordEdit, PasswordAgainEdit, EmailEdit, PhoneEdit, PlateEdit: TclProEdit;</div><div>&nbsp; RegisterBtn, BackToLoginBtn: TclProButton;</div><div>&nbsp; MainPanel: TclProPanel;</div><div>&nbsp; TitleLbl: TclProLabel;</div><div>&nbsp; HiddenPasswordBtn, NormalPasswordBtn: TclProButton;</div><div>&nbsp; HiddenPasswordAgainBtn, NormalPasswordAgainBtn: TclProButton;</div><div>&nbsp; CheckQuery, InsertQuery, TableCreateQuery: TclSQLiteQuery;</div><div><br></div><div>void BackToLoginBtnClick;</div><div>{</div><div>&nbsp; Clomosy.RunUnit('UnitLogin');</div><div>}</div><div><br></div><div>void RegisterBtnClick;</div><div>{</div><div>&nbsp; try</div><div>&nbsp; {</div><div>&nbsp; &nbsp; if Length(Trim(UsernameEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PasswordEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PasswordAgainEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(EmailEdit.Text)) == 0 ||&nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PhoneEdit.Text)) &lt; 10 ||</div><div>&nbsp; &nbsp; &nbsp; &nbsp;Length(Trim(PlateEdit.Text)) == 0</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Lütfen tüm alanları doldurun.');</div><div>&nbsp; &nbsp; &nbsp; Exit;</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; if PasswordEdit.Text &lt;&gt; PasswordAgainEdit.Text</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Şifreler uyuşmuyor!');</div><div>&nbsp; &nbsp; &nbsp; Exit;</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; TableCreateQuery = Clomosy.DBSQLiteQueryWith(</div><div>&nbsp; &nbsp; &nbsp; 'CREATE TABLE IF NOT EXISTS Users (' +</div><div>&nbsp; &nbsp; &nbsp; 'ID INTEGER PRIMARY KEY AUTOINCREMENT, ' +</div><div>&nbsp; &nbsp; &nbsp; 'Username TEXT, Password TEXT, Email TEXT, Phone TEXT, Plate TEXT)');</div><div>&nbsp; &nbsp; TableCreateQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp; CheckQuery = Clomosy.DBSQLiteQueryWith(</div><div>&nbsp; &nbsp; &nbsp; 'SELECT * FROM Users WHERE Username = ' + QuotedStr(UsernameEdit.Text));</div><div>&nbsp; &nbsp; CheckQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp; if CheckQuery.Found</div><div>&nbsp; &nbsp; {</div><div>&nbsp; &nbsp; &nbsp; ShowMessage('Bu kullanıcı adı zaten kayıtlı!');</div><div>&nbsp; &nbsp; &nbsp; Exit;</div><div>&nbsp; &nbsp; }</div><div><br></div><div>&nbsp; &nbsp; InsertQuery = Clomosy.DBSQLiteQueryWith(</div><div>&nbsp; 'INSERT INTO Users (Username, Password, Email, Phone, Plate) VALUES (' +</div><div>&nbsp; QuotedStr(UsernameEdit.Text) + ', ' +</div><div>&nbsp; QuotedStr(PasswordEdit.Text) + ', ' +</div><div>&nbsp; QuotedStr(EmailEdit.Text) + ', ' +</div><div>&nbsp; QuotedStr(PhoneEdit.Text) + ', ' +</div><div>&nbsp; QuotedStr(PlateEdit.Text) + '); ' +</div><div>&nbsp; 'SELECT "" as dummy');</div><div>InsertQuery.OpenOrExecute;</div><div><br></div><div>&nbsp; &nbsp; ShowMessage('Kayıt başarılı! Giriş ekranına yönlendiriliyorsunuz.');</div><div>&nbsp; &nbsp; Clomosy.RunUnit('UnitLogin');</div><div>&nbsp; &nbsp; RegisterForm.Close;</div><div>&nbsp; }</div><div>&nbsp; except</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Kayıt sırasında hata: ' + LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div>}</div><div><br></div><div>{</div><div>&nbsp; RegisterForm = TclForm.Create(Self);</div><div>&nbsp; RegisterForm.SetFormBGImage('<a href="https://resmim.net/cdn/2025/07/21/XjZDYD.jpg" target="_blank" rel="nofollow">https://resmim.net/cdn/2025/07/21/XjZDYD.jpg</a>');</div><div><br></div><div>&nbsp; MainPanel = RegisterForm.AddNewProPanel(RegisterForm, 'MainPanel');</div><div>&nbsp; MainPanel.Align = alClient;</div><div><br></div><div>&nbsp; TitleLbl = RegisterForm.AddNewProLabel(MainPanel, 'TitleLbl', 'Üye Ol');</div><div>&nbsp; TitleLbl.Align = alTop;</div><div>&nbsp; TitleLbl.Height = 40;</div><div>&nbsp; TitleLbl.Margins.Top = 60;</div><div>&nbsp; TitleLbl.clProSettings.FontSize = 22;</div><div>&nbsp; TitleLbl.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>&nbsp; TitleLbl.SetclProSettings(TitleLbl.clProSettings);</div><div><br></div><div>&nbsp; UsernameEdit = RegisterForm.AddNewProEdit(MainPanel, 'UsernameEdit', 'Kullanıcı Adı');</div><div>&nbsp; UsernameEdit.Align = alTop;</div><div>&nbsp; UsernameEdit.Margins.Top = 50;</div><div>&nbsp; UsernameEdit.clProSettings.IsRound = True;</div><div>&nbsp; UsernameEdit.SetclProSettings(UsernameEdit.clProSettings);</div><div><br></div><div>&nbsp; PasswordEdit = RegisterForm.AddNewProEdit(MainPanel, 'PasswordEdit', 'Şifre');</div><div>&nbsp; PasswordEdit.Align = alTop;</div><div>&nbsp; PasswordEdit.Margins.Top = 10;</div><div>&nbsp; PasswordEdit.Password = True;</div><div>&nbsp; PasswordEdit.clProSettings.IsRound = True;</div><div>&nbsp; PasswordEdit.SetclProSettings(PasswordEdit.clProSettings);</div><div><br></div><div>&nbsp; PasswordAgainEdit = RegisterForm.AddNewProEdit(MainPanel, 'PasswordAgainEdit', 'Şifre Tekrar');</div><div>&nbsp; PasswordAgainEdit.Align = alTop;</div><div>&nbsp; PasswordAgainEdit.Margins.Top = 10;</div><div>&nbsp; PasswordAgainEdit.Password = True;</div><div>&nbsp; PasswordAgainEdit.clProSettings.IsRound = True;</div><div>&nbsp; PasswordAgainEdit.SetclProSettings(PasswordAgainEdit.clProSettings);</div><div><br></div><div>&nbsp; EmailEdit = RegisterForm.AddNewProEdit(MainPanel, 'EmailEdit', 'E-Posta');</div><div>&nbsp; EmailEdit.Align = alTop;</div><div>&nbsp; EmailEdit.Margins.Top = 10;</div><div>&nbsp; EmailEdit.clProSettings.IsRound = True;</div><div>&nbsp; EmailEdit.SetclProSettings(EmailEdit.clProSettings);</div><div><br></div><div>&nbsp; PhoneEdit = RegisterForm.AddNewProEdit(MainPanel, 'PhoneEdit', 'Telefon (10 hane)');</div><div>&nbsp; PhoneEdit.Align = alTop;</div><div>&nbsp; PhoneEdit.Margins.Top = 10;</div><div>&nbsp; PhoneEdit.MaxLength = 10;</div><div>&nbsp; PhoneEdit.KeyboardType = vktPhonePad;</div><div>&nbsp; PhoneEdit.clProSettings.IsRound = True;</div><div>&nbsp; PhoneEdit.SetclProSettings(PhoneEdit.clProSettings);</div><div><br></div><div>&nbsp; PlateEdit = RegisterForm.AddNewProEdit(MainPanel, 'PlateEdit', 'Araç Plakası');</div><div>&nbsp; PlateEdit.Align = alTop;</div><div>&nbsp; PlateEdit.Margins.Top = 10;</div><div>&nbsp; PlateEdit.clProSettings.IsRound = True;</div><div>&nbsp; PlateEdit.SetclProSettings(PlateEdit.clProSettings);</div><div><br></div><div>&nbsp; RegisterBtn = RegisterForm.AddNewProButton(MainPanel, 'RegisterBtn', 'Kayıt Ol');</div><div>&nbsp; RegisterBtn.Align = alTop;</div><div>&nbsp; RegisterBtn.Margins.Top = 25;</div><div>&nbsp; RegisterBtn.clProSettings.IsRound = True;</div><div>&nbsp; RegisterBtn.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#93c1ec');</div><div>&nbsp; RegisterBtn.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>&nbsp; RegisterBtn.SetclProSettings(RegisterBtn.clProSettings);</div><div>&nbsp; RegisterForm.AddNewEvent(RegisterBtn, tbeOnClick, 'RegisterBtnClick');</div><div><br></div><div>&nbsp; BackToLoginBtn = RegisterForm.AddNewProButton(MainPanel, 'BackToLoginBtn', 'Giriş Ekranına Dön');</div><div>&nbsp; BackToLoginBtn.Align = alTop;</div><div>&nbsp; BackToLoginBtn.Margins.Top = 10;</div><div>&nbsp; BackToLoginBtn.clProSettings.IsRound = True;</div><div>&nbsp; BackToLoginBtn.clProSettings.BackgroundColor = clAlphaColor.clHexToColor('#93c1ec');</div><div>&nbsp; BackToLoginBtn.clProSettings.FontColor = clAlphaColor.clHexToColor('#FFFFFF');</div><div>&nbsp; BackToLoginBtn.SetclProSettings(BackToLoginBtn.clProSettings);</div><div>&nbsp; RegisterForm.AddNewEvent(BackToLoginBtn, tbeOnClick, 'BackToLoginBtnClick');</div><div><br></div><div>&nbsp; RegisterForm.Run;</div><div>}&nbsp; &nbsp; &nbsp; &nbsp;</div><div><br></div><div>Register kodum yukarıdaki gibi. Çalıştırdığım zaman aşağıdaki hatayı veriyor.</div><div><br></div><div>Kayıt sırasında hata:&#091;FireDAC&#093;&#091;Phys&#093;&#091;SQLite&#093;-308.Cannot open / define command, which does not return result sets.Hint: use Execute/ExecSQL method for non-SELECT commands</div><div><br></div><div>Konuda bilgisi olan yardımcı olabilirse çok sevinirim. Teşekkürler.</div>]]>
   </description>
   <pubDate>Wed, 23 Jul 2025 13:49:51 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=1125&amp;PID=2315#2315</guid>
  </item> 
 </channel>
</rss>