SQLite SELECT issues

[CCChris]

I created an SQLite DB in the SQLite Manager Firefox plugin. The DB contains a table called words. It has 2 columns (id PK and word varchar). Inserted into the table is 4751 records.

When I execute the following query in SQLite Manager it returns a result:

SELECT word FROM words LIMIT 1

When I do the same statement in my app, I get 0 results.

Here my app code:

const char *dbpath = [databasePath UTF8String];
sqlite3_stmt *statement;

if (sqlite3_open(dbpath, &theDB) == SQLITE_OK) {
    NSString *querySQL = [NSString stringWithFormat: @"SELECT word FROM words LIMIT 1"];

    const char *query_stmt = [querySQL UTF8String];

    if (sqlite3_prepare_v2(theDB, query_stmt, -1, &statement, NULL) == SQLITE_OK) {
        NSLog(@"TEST 1");
        while (sqlite3_step(statement) == SQLITE_ROW) {
            NSLog(@"TEST 2");
        }
        sqlite3_finalize(statement);
    } else {
        NSLog(@"%s", sqlite3_errmsg(theDB));
    }
}

The "TEST 1" NSLog runs fine, so the statement prepares just fine, but "TEST 2" never outputs.