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");
}
}
}
{
[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
Post a Comment