Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 8th, 2012  |  syntax: None  |  size: 0.94 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Sqlite error in Objective C
  2. if(sqlite3_open([databasePath UTF8String], &yerocDB)==SQLITE_OK)
  3. {  
  4.     sqlite3_stmt *compiledstatement;
  5.  
  6.     NSString *deleteSql=[NSString stringWithFormat: @"delete from Favorites_Table where playlist_name = Studying and date = 1/1/2012"];
  7.     const char *sqlstmt = [deleteSql UTF8String];
  8.  
  9.     if(sqlite3_prepare_v2(yerocDB, sqlstmt, -1, &compiledstatement, NULL)==SQLITE_OK)
  10.     {
  11.         int result = sqlite3_step(compiledstatement);
  12.  
  13.         if(SQLITE_DONE != result)
  14.  
  15.             NSAssert1(0,@"Error while creating delete statement => %s",sqlite3_errmsg(yerocDB) );
  16.     }else{
  17.         NSLog(@"didn't delete error: %s", sqlite3_errmsg(yerocDB));
  18.     }
  19.     sqlite3_finalize(compiledstatement);
  20. }
  21.        
  22. didn't delete error: no such column: Studying
  23.        
  24. delete from Favorites_Table
  25. where playlist_name = Studying and date = 1/1/2012
  26.        
  27. delete from Favorites_Table
  28. where playlist_name = 'Studying' and date = '2012-01-01'