1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| - (void) addCompte {
if(addStmt == nil) {
const char *sql = "insert into Coffee(CoffeeName, Price) Values(?, ?)";
if(sqlite3_prepare_v2(database, sql, -1, &addStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating add statement. '%s'", sqlite3_errmsg(database)); <= ligne 88
}
sqlite3_bind_text(addStmt, 1, [nomcompte UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(addStmt, 2, [mdp UTF8String], -2, SQLITE_TRANSIENT);
if(SQLITE_DONE != sqlite3_step(addStmt))
NSAssert1(0, Error while inserting data. '%s'", sqlite3_errmsg(database));
else
//SQLite provides a methode to get the last primary key inserted by using sqlite3_last_insert_rowid
compteID = sqlite3_last_insert_rowid(database);
//Reset the add statement
sqlite3_reset(addStmt);
} |
Partager