<?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 : Local Connection Not Ready</title>
  <link>https://forum.clomosy.com.tr/</link>
  <description><![CDATA[XML içerik linki; Clomosy | Forum : Genel &#304;&#351;lemler : Local Connection Not Ready]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Mon, 04 May 2026 14:25:24 +0000</pubDate>
  <lastBuildDate>Wed, 17 Jul 2024 17:53: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=688</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[Local Connection Not Ready : sqlite query&amp;#039;sinde yapt&#305;mCREATE...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1062#1062</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=198">Habip</a><br /><strong>Konu:</strong> 688<br /><strong>Gönderim Zamanı:</strong> 17&nbsp;Temmuz&nbsp;2024 Saat 17:53<br /><br />sqlite query'sinde yaptım<div><br></div><div><span ="hljs-keyword">CREATE</span> <span ="hljs-keyword">TABLE</span>&nbsp;SalonBilgi (&nbsp;</div><div>&nbsp;SalonID <span ="hljs-">INT</span> <span ="hljs-keyword">IDENTITY</span>(<span ="hljs-number">1</span>,<span ="hljs-number">1</span>) <span ="hljs-keyword">PRIMARY</span> KEY,&nbsp;</div><div>&nbsp;SalonAdi NVARCHAR(<span ="hljs-number">50</span>),&nbsp;</div><div>&nbsp;SalonSehir NVARCHAR(<span ="hljs-number">50</span>),&nbsp;</div><div>&nbsp;SalonIlce NVARCHAR(<span ="hljs-number">50</span>));</div>]]>
   </description>
   <pubDate>Wed, 17 Jul 2024 17:53:13 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1062#1062</guid>
  </item> 
  <item>
   <title><![CDATA[Local Connection Not Ready : Merhaba Habib,Tablo create&amp;#039;ni...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1060#1060</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=106">Developer</a><br /><strong>Konu:</strong> 688<br /><strong>Gönderim Zamanı:</strong> 17&nbsp;Temmuz&nbsp;2024 Saat 17:50<br /><br />Merhaba Habib,<div>Tablo create'ni sizin paylaştığınız kod içerisinde bulamadım. Farklı bir yerde mi yaptınız tablo create kodlamasını.</div>]]>
   </description>
   <pubDate>Wed, 17 Jul 2024 17:50:01 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1060#1060</guid>
  </item> 
  <item>
   <title><![CDATA[Local Connection Not Ready :    ]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1057#1057</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=198">Habip</a><br /><strong>Konu:</strong> 688<br /><strong>Gönderim Zamanı:</strong> 17&nbsp;Temmuz&nbsp;2024 Saat 17:46<br /><br /><img src="uploads/198/resim_2024-07-17_174637593.png" height="197" width="410" border="0" />]]>
   </description>
   <pubDate>Wed, 17 Jul 2024 17:46:43 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1057#1057</guid>
  </item> 
  <item>
   <title><![CDATA[Local Connection Not Ready :  Tablo mevcur olmas&#305;na ra&#287;men...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1055#1055</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=198">Habip</a><br /><strong>Konu:</strong> 688<br /><strong>Gönderim Zamanı:</strong> 17&nbsp;Temmuz&nbsp;2024 Saat 17:45<br /><br /><img src="" border="0" /><div><br></div><div>Tablo mevcur olmasına rağmen bu hatayı verdi bu sefer de.</div>]]>
   </description>
   <pubDate>Wed, 17 Jul 2024 17:45:28 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1055#1055</guid>
  </item> 
  <item>
   <title><![CDATA[Local Connection Not Ready : Merhaba Habib,Sqlite veritaban&#305;n&#305;...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1051#1051</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=106">Developer</a><br /><strong>Konu:</strong> 688<br /><strong>Gönderim Zamanı:</strong> 17&nbsp;Temmuz&nbsp;2024 Saat 17:37<br /><br />Merhaba Habib,<div>Sqlite veritabanını bağlantı sağlamadan&nbsp;&nbsp;sehirComboDataLoad; veri yüklemeye çalışmışsın.</div>]]>
   </description>
   <pubDate>Wed, 17 Jul 2024 17:37:31 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1051#1051</guid>
  </item> 
  <item>
   <title><![CDATA[Local Connection Not Ready : // veritaban&#305;nda bulunan spor...]]></title>
   <link>https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1043#1043</link>
   <description>
    <![CDATA[<strong>Yazar:</strong> <a href="https://forum.clomosy.com.tr/member_profile.asp?PF=198">Habip</a><br /><strong>Konu:</strong> 688<br /><strong>Gönderim Zamanı:</strong> 17&nbsp;Temmuz&nbsp;2024 Saat 15:33<br /><br /><div>// veritabanında bulunan spor salonları kullanıcının seçim yapması üzerine listelenir.</div><div>//Filtre butonu ile filtre menüsü açılır ve comboboxtan seçilen değerlere göre filtreleme işlemi yapılır.</div><div>//Spor salonu seçildiğinde kullanıcı bilgilerinin alınacağı kullanıcı kayıt sayfasına yönlendirir</div><div><br></div><div><br></div><div>Var&nbsp; &nbsp;</div><div>SporSalonlari:TclForm;</div><div>SporSalonlariListView: TClListView;</div><div>SporSalonuAd,SporSalonuKonum:TClProLabel;</div><div>SporSalonlariSearchEdit: TClProSearchEdit;</div><div>filtreBtn,uygulaBtn:TClProButton;</div><div>filtreMenu:TclMenuFrame;</div><div>sehirCombo,ilceCombo:TCLComboBox;</div><div>kullaniciKayitUnit:TclUnit;</div><div>database, password : String;</div><div>Qry : TClSQLiteQuery;</div><div>i:Integer;</div><div>void AddDataToListview</div><div>{</div><div>&nbsp; try</div><div>&nbsp; if(i==0){</div><div>&nbsp; &nbsp; Qry = Clomosy.DBSQLiteQueryWith('SELECT SalonAdi as MAIN_TEXT, SalonSehir as SUB_TEXT,SalonIlce as FOOTER_TEXT from SalonBilgi');</div><div>&nbsp; &nbsp; Qry.OpenOrExecute;</div><div>&nbsp; }</div><div>&nbsp; else {</div><div>&nbsp; Qry = Clomosy.DBSQLiteQueryWith('SELECT SalonAdi as MAIN_TEXT, SalonSehir as SUB_TEXT,SalonIlce as FOOTER_TEXT from SalonBilgi&nbsp;</div><div>&nbsp; Where SalonSehir LIKE&nbsp; '+QuotedStr('%'+sehirCombo.GetItemIndex(sehirCombo.ItemIndex)+'%')+' and SalonIlce LIKE&nbsp; '+QuotedStr('%'+ilceCombo.GetItemIndex(ilceCombo.ItemIndex)+'%'));&nbsp;</div><div>&nbsp; Qry.OpenOrExecute;</div><div>&nbsp; &nbsp; }</div><div>&nbsp; &nbsp; &nbsp; SporSalonlariListView.clLoadListViewDataFromDataset(Qry)</div><div>&nbsp; &nbsp;&nbsp;</div><div>&nbsp; except</div><div>&nbsp; &nbsp; ShowMessage('Exception class: '+LastExceptionClassName+' Exception Message: ' +LastExceptionMessage);</div><div>&nbsp; }</div><div>}</div><div>void GoToKullaniciGirisUnit;</div><div>{</div><div>&nbsp; SporSalonlari.clShow;</div><div>&nbsp; kullaniciKayitUnit.UnitName = 'kullaniciKayitUnit';</div><div>&nbsp; kullaniciKayitUnit.CallerForm = SporSalonlari;</div><div>&nbsp; kullaniciKayitUnit.Run;</div><div>}</div><div><br></div><div>void ShowFiltreMenuFrame;</div><div>{</div><div>&nbsp; filtreMenu.Visible = True;</div><div>&nbsp; clRTMethod(filtreMenu, 'BringToFront');</div><div>}</div><div>void HideFiltreMenuFrame;</div><div>{</div><div>&nbsp; AddDataToListview;</div><div>&nbsp; filtreMenu.Visible = False;</div><div>&nbsp; clRTMethod(uygulaBtn, 'BringToFront');</div><div>}</div><div>void sehirComboDataLoad</div><div>&nbsp;var</div><div>&nbsp; &nbsp;sehirlerQuery :TClSQLiteQuery;</div><div>&nbsp;{</div><div>&nbsp; &nbsp;sehirlerQuery = TClSQLiteQuery.Create(Nil);</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp;try</div><div>&nbsp; &nbsp; &nbsp;sehirlerQuery = Clomosy.DBSQLiteQueryWith('SELECT DISTINCT SalonSehir FROM SalonBilgi');</div><div>&nbsp; &nbsp; &nbsp;sehirlerQuery.OpenOrExecute;</div><div>&nbsp; &nbsp; &nbsp;while (not sehirlerQuery.Eof)</div><div>&nbsp; &nbsp; &nbsp;{</div><div>&nbsp; &nbsp; &nbsp; &nbsp;sehirCombo.AddItem(sehirlerQuery.FieldByName('SporSalonuSehir').AsString,'');</div><div>&nbsp; &nbsp; &nbsp; &nbsp;sehirlerQuery.Next;</div><div>&nbsp; &nbsp; &nbsp;}</div><div>&nbsp; &nbsp;except</div><div>&nbsp; &nbsp; ShowMessage('Exception class: '+LastExceptionClassName+' Exception Message: ' +LastExceptionMessage);</div><div>&nbsp; &nbsp;}</div><div>&nbsp;}</div><div><br></div><div><br></div><div>void sehirComboChanged;</div><div>&nbsp;var</div><div>&nbsp; &nbsp;ilcelerQuery :TClSQLiteQuery;</div><div>&nbsp;{</div><div>&nbsp; &nbsp;ilcelerQuery = TClSQLiteQuery.Create(Nil);</div><div>&nbsp; &nbsp;</div><div>&nbsp; &nbsp; &nbsp;ilceCombo.Clear;</div><div>&nbsp; &nbsp; &nbsp;ilceCombo.AddItem('Seçiniz','');</div><div>&nbsp; &nbsp;try</div><div>&nbsp; &nbsp; &nbsp;ilcelerQuery = Clomosy.DBSQLiteQueryWith('SELECT DISTINCT SporSalonuIlce FROM SalonBilgi Where SporSalonuSehir LIKE&nbsp; '+QuotedStr('%'+sehirCombo.GetItemIndex(sehirCombo.ItemIndex)+'%'));</div><div>&nbsp; &nbsp; &nbsp;ilcelerQuery.OpenOrExecute;;</div><div>&nbsp; &nbsp; &nbsp;while (not ilcelerQuery.Eof)</div><div>&nbsp; &nbsp; &nbsp;{</div><div>&nbsp; &nbsp; &nbsp;</div><div>&nbsp; &nbsp; &nbsp; &nbsp;ilceCombo.AddItem(ilcelerQuery.FieldByName('SporSalonuIlce').AsString,'');</div><div>&nbsp; &nbsp; &nbsp; &nbsp;ilcelerQuery.Next;</div><div>&nbsp; &nbsp; &nbsp;}</div><div>&nbsp; &nbsp;finally</div><div>&nbsp; &nbsp; &nbsp;ilcelerQuery.Free;</div><div>&nbsp; &nbsp;}</div><div>&nbsp;</div><div>&nbsp; i=i+1;</div><div>}</div><div>void ItemSelected</div><div>var</div><div>stringValue:string;</div><div>{</div><div>&nbsp;stringValue = SporSalonlariListView.clSelectedItemData('MAIN_TEXT');</div><div>&nbsp; if(stringValue=='Çankaya Spor Salonu')</div><div>&nbsp; {</div><div>&nbsp; &nbsp; ShowMessage('Seçilen spor salonunun kontenjanı doludur');&nbsp;&nbsp;</div><div>&nbsp; }</div><div>&nbsp; else</div><div>&nbsp; {</div><div>&nbsp; &nbsp; GoToKullaniciGirisUnit;</div><div>&nbsp; }</div><div>}</div><div>{</div><div>&nbsp; SporSalonlari = TclForm.Create(Self);</div><div>&nbsp; SporSalonlari.SetFormColor('#131842', '', clGNone);</div><div>&nbsp; kullaniciKayitUnit=TclUnit.Create;</div><div>&nbsp;&nbsp;</div><div>&nbsp; i=0;</div><div>&nbsp;&nbsp;</div><div>&nbsp; filtreMenu = SporSalonlari.AddNewMenuFrame(SporSalonlari,'filtreMenu');</div><div>&nbsp; filtreMenu.Align = alContents;</div><div>&nbsp; filtreMenu.Margins.Top = 50;</div><div>&nbsp; filtreMenu.MenuBar.Width = 250;</div><div>&nbsp; filtreMenu.Visible = False;</div><div>&nbsp; filtreMenu.ClMenuPosition = clRight;</div><div>&nbsp;</div><div>&nbsp; filtreBtn = SporSalonlari.AddNewProButton(SporSalonlari, 'filtreBtn', '');</div><div>&nbsp; clComponent.SetupComponent(filtreBtn,'{</div><div>&nbsp; &nbsp; "MarginBottom":700,</div><div>&nbsp; &nbsp; "MarginLeft":298,</div><div>&nbsp; &nbsp; "Width":80,</div><div>&nbsp; &nbsp; "Height":40,</div><div>&nbsp; &nbsp; "RoundHeight":10,</div><div>&nbsp; &nbsp; "RoundWidth":10,</div><div>&nbsp; &nbsp; "TextColor" : "#e57e38",</div><div>&nbsp; &nbsp; "TextBold" : "yes",</div><div>&nbsp; &nbsp; "TextSize":20,</div><div>&nbsp; &nbsp; "BorderColor":"#9DDE8B",</div><div>&nbsp; &nbsp; "BorderWidth":2,</div><div>&nbsp; &nbsp; "BackgroundColor":"#006769"</div><div>&nbsp; }');</div><div>&nbsp; SporSalonlari.AddNewEvent(filtreBtn, tbeOnClick, 'ShowFiltreMenuFrame');</div><div>&nbsp; SporSalonlari.SetImage(filtreBtn,'https://i.imgur.com/sOqdfux.png');</div><div>&nbsp;&nbsp;</div><div>&nbsp; uygulaBtn = SporSalonlari.AddNewProButton(filtreMenu.VertScrollBox, 'uygulaBtn', 'Uygula');</div><div>&nbsp; clComponent.SetupComponent(uygulaBtn,'{</div><div>&nbsp; &nbsp; "Align":"Bottom",</div><div>&nbsp; &nbsp; "Width":100,</div><div>&nbsp; &nbsp; "Height":50,</div><div>&nbsp; &nbsp; "RoundHeight":10,</div><div>&nbsp; &nbsp; "RoundWidth":10,</div><div>&nbsp; &nbsp; "TextColor" : "#ffffff",</div><div>&nbsp; &nbsp; "TextBold" : "yes",</div><div>&nbsp; &nbsp; "TextSize":20,</div><div>&nbsp; &nbsp; "BorderColor":"#9DDE8B",</div><div>&nbsp; &nbsp; "BorderWidth":2,</div><div>&nbsp; &nbsp; "BackgroundColor":"#006769"</div><div>&nbsp; }');</div><div><br></div><div>&nbsp;&nbsp;</div><div>&nbsp;</div><div>&nbsp; sehirCombo = SporSalonlari.AddNewComboBox(filtreMenu.VertScrollBox,'sehirCombo');</div><div>&nbsp; sehirCombo.Align = alTop;</div><div>&nbsp; sehirCombo.Width = 150;</div><div>&nbsp; sehirCombo.Margins.Top=10;</div><div>&nbsp; sehirCombo.Margins.Left =50;</div><div>&nbsp; sehirCombo.Margins.Right =50;</div><div>&nbsp; sehirCombo.AddItem('Seçiniz','');</div><div>&nbsp; sehirComboDataLoad;</div><div>&nbsp; ilceCombo = SporSalonlari.AddNewComboBox(filtreMenu.VertScrollBox,'ilceCombo');</div><div>&nbsp; ilceCombo.Align = alTop;</div><div>&nbsp; ilceCombo.Width = 150;</div><div>&nbsp; ilceCombo.Margins.Top=10;</div><div>&nbsp; ilceCombo.Margins.Left =50;</div><div>&nbsp; ilceCombo.Margins.Right =50;</div><div><br></div><div>&nbsp; ilceCombo.AddItem('Seçiniz','');</div><div>&nbsp; SporSalonlari.AddNewEvent(sehirCombo,tbeOnChange,'sehirComboChanged');</div><div>&nbsp;&nbsp;</div><div>&nbsp; SporSalonlariListView=SporSalonlari.AddNewListView(SporSalonlari, 'SporSalonlariListView');</div><div>&nbsp; SporSalonlariListView.align=alClient;</div><div>&nbsp;&nbsp;</div><div>&nbsp; SporSalonlari.AddNewEvent(uygulaBtn, tbeOnClick, 'HideFiltreMenuFrame');</div><div>&nbsp;&nbsp;</div><div>&nbsp; SporSalonlari.AddNewEvent(SporSalonlariListView,tbeOnItemClick,'ItemSelected');</div><div>&nbsp;&nbsp;</div><div>&nbsp; Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath + 'SporSalonlari.db', '');</div><div>&nbsp;&nbsp;</div><div>&nbsp; AddDataToListview;</div><div>&nbsp;&nbsp;</div><div>&nbsp; SporSalonlari.Run;</div><div>}</div><div><img src="uploads/198/Ekran_görüntüsü_2024-07-17_153119.png" height="197" width="532" border="0" /><br></div><div><br></div><div><br></div><div><img src="uploads/198/Ekran_görüntüsü_2024-07-17_153107_2024-07-17_15-33-11.png" height="177" width="227" border="0" /><br></div>]]>
   </description>
   <pubDate>Wed, 17 Jul 2024 15:33:35 +0000</pubDate>
   <guid isPermaLink="true">https://forum.clomosy.com.tr/forum_posts.asp?TID=688&amp;PID=1043#1043</guid>
  </item> 
 </channel>
</rss>