Insert into Sqlite

- (void)PostOrderDetail:(NSMutableDictionary *)OrderDetails
{
    [self createEditableCopyOfDatabaseIfNeeded];
    if(sqlite3_open([[self GetDBPath] UTF8String], &database)== SQLITE_OK) {
        const char *sql = "insert into OrderDetails(ID,Price) values(?,?)";
        sqlite3_stmt *stmt;
        int success;
        if (sqlite3_prepare_v2(database, sql, -1, &stmt, NULL) == SQLITE_OK) {
           
            //NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(database));
       
            sqlite3_bind_text(stmt, 1, [[OrderDetails objectForKey:@"ID"]  UTF8String],-1,SQLITE_TRANSIENT);
            sqlite3_bind_text(stmt, 2, [[OrderDetails objectForKey:@"Price"] UTF8String],-1,SQLITE_TRANSIENT);
           
            sqlite3_reset(stmt);
            if (success != SQLITE_ERROR) {
                int OrderIDInt = sqlite3_last_insert_rowid(database);
                //NSLog(@"return: %d",OrderIDInt);
            }
        }
        else {
            //NSLog(@"error");
        }

   
    }
}

Comments