
Untitled
By: a guest on
May 8th, 2012 | syntax:
None | size: 0.94 KB | hits: 14 | expires: Never
Sqlite error in Objective C
if(sqlite3_open([databasePath UTF8String], &yerocDB)==SQLITE_OK)
{
sqlite3_stmt *compiledstatement;
NSString *deleteSql=[NSString stringWithFormat: @"delete from Favorites_Table where playlist_name = Studying and date = 1/1/2012"];
const char *sqlstmt = [deleteSql UTF8String];
if(sqlite3_prepare_v2(yerocDB, sqlstmt, -1, &compiledstatement, NULL)==SQLITE_OK)
{
int result = sqlite3_step(compiledstatement);
if(SQLITE_DONE != result)
NSAssert1(0,@"Error while creating delete statement => %s",sqlite3_errmsg(yerocDB) );
}else{
NSLog(@"didn't delete error: %s", sqlite3_errmsg(yerocDB));
}
sqlite3_finalize(compiledstatement);
}
didn't delete error: no such column: Studying
delete from Favorites_Table
where playlist_name = Studying and date = 1/1/2012
delete from Favorites_Table
where playlist_name = 'Studying' and date = '2012-01-01'