FMDatabase errors out when running update query

Question

I have the below line which crashes on FMDB when it runs with:

-[FMDatabase executeUpdate:error:withArgumentsinArray:orDictionary:orVAList:]

My code is:

NSInteger entryID = 1;
[db executeUpdate:@"UPDATE formQue SET Processed='true' WHERE EntryID=?", entryID];

Happy to show more code etc. but I have narrowed the crash down to happening at this line and it does not really effect any other code.

Table:

formQue(EntryID INTEGER PRIMARY KEY, CustomerID int, Title text, FName text, LName text, DOB text, Country text, Email text, Nationality text, Processed text, courseType text, Notes text, YearEntry text, Event text)

And this is what xcode looks like when the crash happens

Answer 1

The problem is that FMDB expects the bind arguments to be objects. You are using an NSInteger which is a simple C type.

From the FMDB class documentation:

Optional parameters to bind to ? placeholders in the SQL statement. These should be Objective-C objects (e.g. NSString, NSNumber, etc.), not fundamental C data types (e.g. int, char *, etc.).

Try boxing the argument into an NSNumber:

NSInteger entryID = 1;
[db executeUpdate:@"UPDATE formQue SET Processed='true' WHERE EntryID=?", [NSNumber numberWithIntger:entryID]];

Or more succinctly using the modern syntax:

NSInteger entryID = 1;
[db executeUpdate:@"UPDATE formQue SET Processed='true' WHERE EntryID=?", @(entryID)];