Sqlite3_prepare_v2 error

Can someone explain to me why this if statement is not triggering? The database opens just fine, I just can not get any values ​​from the database. In addition, the table name is also correct.

    if (sqlite3_prepare_v2(database, [query UTF8String], -1, &statement, nil)== SQLITE_OK) {


        while (sqlite3_step(statement) == SQLITE_ROW) {
            int uniqueId = sqlite3_column_int(statement, 0);

            char *nameChars = (char *) sqlite3_column_text(statement, 1);
            char *addressChars = (char *) sqlite3_column_text(statement, 2);

            NSString *name = [[NSString alloc] initWithUTF8String:nameChars];
            NSString *address = [[NSString alloc] initWithUTF8String:addressChars];

            PersonInfo *info = [[PersonInfo alloc] initWithUniqueID:uniqueId name:name address:address];

            [returnArray addObject:info];


        }

        sqlite3_finalize(statement);
    }
    return returnArray;
}
0
source share

Source: https://habr.com/ru/post/1546955/


All Articles