Clomosy | Forum : sqlite https://forum.clomosy.com.tr/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 01 May 2026 19:24:09 +0000 Tue, 03 Sep 2024 15:19:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.07 360 https://forum.clomosy.com.tr/RSS_post_feed.asp?TID=915 <![CDATA[Clomosy | Forum]]> https://forum.clomosy.com.tr/forum_images/logo.png https://forum.clomosy.com.tr/ <![CDATA[sqlite : Merhaba İsmail,Oluşan yapıda scorsnumber...]]> https://forum.clomosy.com.tr/forum_posts.asp?TID=915&PID=1784#1784 Yazar: Developer
Konu: 915
Gönderim Zamanı: 03 Eylül 2024 Saat 15:19

Merhaba İsmail,
Oluşan yapıda scorsnumber bulamıyor. Ondan dolayı hatayı alıyorsun.
]]> Tue, 03 Sep 2024 15:19:55 +0000 https://forum.clomosy.com.tr/forum_posts.asp?TID=915&PID=1784#1784 <![CDATA[sqlite : void SqLiteConnectionCreateScorTable;...]]> https://forum.clomosy.com.tr/forum_posts.asp?TID=915&PID=1759#1759 Yazar: ismail
Konu: 915
Gönderim Zamanı: 28 Ağustos 2024 Saat 18:06

 void SqLiteConnectionCreateScorTable;
  var
    TableExists2: Boolean;
  {
    try
      Clomosy.DBSQLiteConnect(Clomosy.AppFilesPath + 'scorDB5.db3', '');
 
      // Check if the table exists
      Clomosy.DBSQLiteQuery.Sql.Text = 'SELECT name FROM sqlite_master WHERE type="table" AND name="scorsnumber3";';
      Clomosy.DBSQLiteQuery.OpenOrExecute;
      
      // Check the results
      TableExists2 = not Clomosy.DBSQLiteQuery.Eof;
      
      // Create the table if it does not exist
      if not(TableExists2)
      {
        Clomosy.DBSQLiteQuery.Sql.Text = 'CREATE TABLE scorsnumber3(
    teamscorone TEXT NOT NULL,
    teamscortwo TEXT NOT NULL
        )';
        Clomosy.DBSQLiteQuery.OpenOrExecute;
        
        ShowMessage('Table successfully added to the database!');
       
      } 

    except
     ShowMessage('Exception Class: '+LastExceptionClassName+' Exception Message: '+LastExceptionMessage);
    }
  }
 
 
 
 
 void scortableinsertdata;
 
   {
 

  try
    
  
   Clomosy.DBSQLiteQuery.SQL.Text='INSERT INTO scorsnumber3(teamscorone,teamscortwo) VALUES ('+QuotedStr(teamscor1)+','+QuotedStr(teamscor2)+')';
    Clomosy.DBSQLiteQuery.OpenOrExecute;
    ShowMessage('madde başarıyla eklendi ');

  
  except
     ShowMessage('Exception Class '+LastExceptionClassName+'Exception Message'+LastExceptionMessage);
  }
  
}


 no such scorsnumber3 hatası alıyorum insert kısmını herhangi bir yerde çağırdığım zaman
]]> Wed, 28 Aug 2024 18:06:34 +0000 https://forum.clomosy.com.tr/forum_posts.asp?TID=915&PID=1759#1759