Databases
StackOverflow2013
Postsdbo
POHow to delete call history details using tableview editing method in iPhone
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to delete call history details using tableview editing method in iPhone
    primarykey
    data
    text
    <p>I am new in iPhone application development. I am developing a call history application in iPhone. In this application I am fetching all call details using a call history database, and then displaying in table view. Now I want to perform a delete on the selected row call history value in the database. I don't know how to perform this operation. I am using the following code but it is showing an error like:</p> <blockquote> <p>Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Error while creating delete statement. 'near "&lt;": syntax error''</p> </blockquote> <pre><code>- (void)tableView:(UITableView *)aTableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath { if (editingStyle == UITableViewCellEditingStyleDelete) { [appDelegate.displayHistroryValueAppDelegate removeObjectAtIndex:indexPath.row]; [displayTableView reloadData]; int rowId = [[[appDelegate.displayHistroryValueAppDelegate objectAtIndex:indexPath.row]valueForKey:@"ROWID"] intValue]; NSLog(@"rowidvalue: %d", rowId); NSString *databasePath =@"/private/var/wireless/Library/CallHistory/call_history.db"; // NSString *sqlStatement = [NSString stringWithFormat:@"DELETE FROM calls WHERE ROWID = %d",rowId]; // NSLog(@"DELETE statement: %@", sqlStatement); sqlite3 *database; if (sqlite3_open([databasePath UTF8String], &amp;database) == SQLITE_OK) { //const char *sql = "delete from reminders where ID = ?"; //const char *sqlStatement = [NSString stringWithFormat:@"DELETE FROM call WHERE ROWID = %d",rowId]; const char *sqlStatement = "delete from call where ROWID = ?"; sqlite3_stmt *deletestmt; if(sqlite3_prepare_v2(database, sqlStatement, -1, &amp;deletestmt, NULL) != SQLITE_OK) { NSAssert1(0, @"Error while creating delete statement. '%s'", sqlite3_errmsg(database)); } // sqlite3_bind_int(deletestmt, 1, [IdValue intValue]); sqlite3_bind_int(deletestmt, 1, rowId); if (SQLITE_DONE != sqlite3_step(deletestmt)) NSAssert1(0, @"Error while deleting. '%s'", sqlite3_errmsg(database)); sqlite3_reset(deletestmt); } } } </code></pre> <p>Please help me</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USsara
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI don't think IOS 5 support that functionality. You can't change the call history database.
      singulars
      1. POHow to delete call history details using tableview editing method in iPhone
      1. USDamitha Raveendra
    2. COI think it is possible to delete call history database. I will search and then do that.
      singulars
      1. POHow to delete call history details using tableview editing method in iPhone
      1. USsara
    3. COthanks for your commands
      singulars
      1. POHow to delete call history details using tableview editing method in iPhone
      1. USsara
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload