无法从SQLite数据库中删除行,但未发出错误

试试这个说法

NSString*sqlStr=[NSString stringWithFormat:@“从“%@”中删除,其中city为“%@%”,tableName,city];

检查要喜欢的操作数是否为字符串(应在其周围加上引号)。我从来没有用过XCode,但是如果你把第5行改为:

NSString *sqlStr = [NSString stringWithFormat:@"DELETE FROM %@ WHERE city LIKE '%@'", tableName, city];

这样行吗?

你刚刚准备好声明,你应该单步声明。

-(void) deleteSelectedRowFromTable: (NSString *) tableName cityName:(NSString *)city 
{

[self openDB];
NSString *sqlStr = [NSString stringWithFormat:@"DELETE FROM %@ WHERE city LIKE %@", tableName, city];
const char *sql = [sqlStr UTF8String];
sqlite3_stmt *statement;

if (sqlite3_prepare_v2(db, sql, -1, &statement, nil) != SQLITE_OK) 
{
      /**this one will execute when there is error in your query**/
    NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(db));
}
else
{
     /************just add this one****************/
     sqlite3_step(statement);
}

sqlite3_finalize(statement);
sqlite3_close(db);

}

我希望这个能帮助你。