FMDB更新查询不工作

好了,伙计们,

多亏了我的同事,我找到了答案。

方法[db executeQuery:updateMeeting]错误,您应该使用[db execute Update:updateMeet];

这很烦人,因为我认为更新也是一个查询,但黑客。。。它现在起作用了:)

你应该用这个

[db executeUpdate:@"INSERT INTO myTable VALUES (?)", yourVar];

而不是

stringWithFormat

此外,我将此用于交易

FMDatabaseQueue *queue = [FMDatabaseQueue databaseQueueWithPath:YOUR_PATH];

[queue inTransaction:^(FMDatabase *db, BOOL *rollback) {
    [db executeUpdate:@"UPDATE meetings SET MEETING_DESCRIPTION=? WHERE MEETING_ID=?",meeting.meetingDescription, meeting.meetingId"];

    if (!db) {
        NSLog(@"Some problems... again...")
        *rollback = YES;
        return;
    } }];

如果您需要全局队列,您有解决方案 FMDatabaseQueue Error: database is locked

试试看,也许这可以解决你的问题。快乐编码!!!!

FMDatabase *db = [self openDatabase];

    if (![db open]) {
        return;
    }

    NSString *updateMeeting = [NSString stringWithFormat:@"UPDATE meetings SET MEETING_DESCRIPTION = ? WHERE MEETING_ID = ?"];

    NSArray *paramList = @[meeting.meetingDescription, meeting.meetingId];
    [db beginTransaction];
    [db executeQuery:updateMeeting withArgumentsInArray:paramList];
    [db commit];
    [db close];