Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. sqlite3_stmt *statement;
  2.  
  3. NSString *string = [NSString stringWithString:charDesc.text];
  4. [string stringByReplacingOccurrencesOfString:@""" withString:@"''"];
  5.  
  6. if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK){
  7. NSString *insertSQL = [NSString stringWithFormat: @"UPDATE CHARACTER SET charName = "%@", charDescription = "%@" WHERE charID = %i", charName.text, charDesc.text, charID];
  8.  
  9. const char *insert_stmt = [insertSQL UTF8String];
  10.  
  11. sqlite3_prepare_v2(database, insert_stmt, -1, &statement, NULL);
  12. if (sqlite3_step(statement) == SQLITE_DONE){
  13. status.text = @"Succesfully Updated!";
  14. }else{
  15. status.text = @"Failed to Update!";
  16. }
  17.  
  18. sqlite3_finalize(statement);
  19. sqlite3_close(database);
  20. }
  21.  
  22. string=[string stringByReplacingOccurrencesOfString:@""" withString:@"'"];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement