FMDB SQLite question: row count of a query?
Shorter code to accomplish the same thing:
NSUInteger count = [db intForQuery:@"SELECT COUNT(field) FROM table_name"];
Make sure to include the FMDatabaseAdditions.h
header file to use intForQuery:
.
try this. It works for me. Iterating all the records is not recommended.
FMResultSet *rs = [db executeQuery:@"select count(FIELD) as cnt from TABLENAME"];while ([rs next]) { NSLog(@"Total Records :%d", [rs intForColumn:@"cnt"]);}
May be you should check your Where clause.
Swift 2 Example
This code snippet will print the count for you.
if let rs = db.executeQuery("SELECT COUNT(*) as Count FROM TABLE_NAME", withArgumentsInArray: nil) { while rs.next() { print("Total Records:", rs.intForColumn("Count")) }}
If it did not work, a few suggestions:
a) Look for a line in your project that says let database =
or var database =
. If you find one then change db
to database
b) Did you change the TABLE_NAME in the Select statement to whatever your table is called?