1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| const char *sqlStatement = "SELECT id,nom,age FROM table ORDER BY age DESC LIMIT 2";
sqlite3_stmt *compiledStatement;
if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {
BOOL firstWhile = NO;
while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
if(firstWhile){
idSqlite2 = sqlite3_column_int(compiledStatement, 0);
nomSqlite2 = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 1)];
ageSqlite2 = sqlite3_column_int(compiledStatement, 2);
}
if(!firstWhile){
idSqlite = sqlite3_column_int(compiledStatement, 0);
nomSqlite = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 1)];
ageSqlite = sqlite3_column_int(compiledStatement, 2);
firstWhile = YES;
}
}
} |
Partager