tags:

views:

13

answers:

0
-(NSString *)insertCigStatusIntoDatabase:(sqlite3 *)database{
    database1=database;
    if (insert_statement1 == nil) {
        const char *sql = "insert into SmokerCigInformation(nthDay) values(?)";
        if (sqlite3_prepare_v2(database1, sql, -1, &insert_statement1, NULL) != SQLITE_OK) {
            NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(database1));
        }
     sqlite3_bind_text(insert_statement1, 1, [nthDay UTF8String], -1, SQLITE_TRANSIENT);
       }
    int success = sqlite3_step(insert_statement1);
    NSLog(@"%d",success);

    sqlite3_reset(insert_statement1);
    if (success == SQLITE_DONE) {

     // return sqlite3_last_insert_rowid(database);
     return nthDay;
    }
    NSAssert1(0, @"Error: failed to insert into the database with message '%s'.", sqlite3_errmsg(database));
    return @"-1";
}