iphone - 无法从 sqlite 数据库中删除行

Question

任何人都可以帮我解决代码中的问题吗？我无法从数据库中删除行。

-(void) deleteData {

    sqlite3_stmt    *statement;

    NSString *destinationPath = [self getDestinationPath];

    const char *dbpath = [destinationPath UTF8String];

    if (sqlite3_open(dbpath, &database) == SQLITE_OK)
    {


        NSString *updateSQL = [NSString stringWithFormat: @"DELETE FROM BirthdayListDB WHERE id=\"%@\"",details.ids];

        const char *insert_stmt = [updateSQL UTF8String];

        sqlite3_prepare_v2(database, insert_stmt, -1, &statement, NULL);
        if (sqlite3_step(statement) == SQLITE_DONE)
        {
            NSLog(@"Row deleted");

        } 

        else
        {
            NSLog(@"Failed to delete row");
        }
        sqlite3_finalize(statement);
        sqlite3_close(database);
    }

}

这里(sqlite3_stmt *statement;)我没有得到语句值。我得到的语句为空值。任何 1 都可以帮助我解决这个问题吗？

谢谢!

Answer 1

直接替换即可

    NSString *updateSQL = [NSString stringWithFormat: @"DELETE FROM BirthdayListDB WHERE id=\"%@\"",details.ids];

与

    NSString *updateSQL = [NSString stringWithFormat: @"DELETE FROM BirthdayListDB WHERE id='%@'",details.ids];

谢谢