How delete row from tableview?

[ikaroweb]

Hy guys!

How can I delete a row from a tableview?

I can delete data from the database but not from the tableview.

Thanks.

Ika

[ikaroweb]

Originally Posted by ikaroweb

Hy guys!

How can I delete a row from a tableview?

I can delete data from the database but not from the tableview.

Thanks.

Ika

i've used this line:

//Delete the object from the table.
[self.tableView deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:UITableViewRowAnimationFade];

but without success.

[DaveF]

Originally Posted by ikaroweb

i've used this line:

//Delete the object from the table.
[self.tableView deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:UITableViewRowAnimationFade];

but without success.

And you'll have to update the array containing your table items too.

[ikaroweb]

i've this error:

*** Assertion failure in -[UITableView _endCellAnimationsWithContext:], /SourceCache/UIKit_Sim/UIKit-1261.5/UITableView.m:920
2010-08-02 16:38:24.359 TabBar[829:207] *** Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Invalid update: invalid number of rows in section 0.  The number of rows contained in an existing section after the update (4) must be equal to the number of rows contained in that section before the update (4), plus or minus the number of rows inserted or deleted from that section (0 inserted, 1 deleted).'
*** Call stack at first throw:

[Trisect Development]

I use an NSMutableArray an populate the tableview with it.
Then i delete from the array and populate the tableview again.

[ikaroweb]

Originally Posted by Trisect Development

I use an NSMutableArray an populate the tableview with it.
Then i delete from the array and populate the tableview again.

the problem it's delete the cell from tableview.

[Trisect Development]

If you delete it from the array with the index you got when you click the tableview, then you can populate the tableview with the new array.

Thats the way I do it.

[mickm]

remember that the data for the tableview comes from your declared UITableViewDataSource, which is usually your File's Owner as set in IB, if that is where you set up your view.

the table will ask for it's data, including the number or sections and number of rows in each section with the methods from the UITableViewDataSource protocol:

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView
- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
and
- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath

these almost always come from an array that you have set up with your data, so:

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
{
    return [myData count];
}

so if you delete a row from the table, but don't delete the row from your array of data, this can cause problems.

as mentioned in the earlier posts, it's best to delete the row from your array, and then reload the table, allowing it to adjust itself.

if you want to delete the row from the table, make sure you delete it from the array, so that next time it is loaded, it will be loaded correctly.

[ikaroweb]

Originally Posted by mickm

remember that the data for the tableview comes from your declared UITableViewDataSource, which is usually your File's Owner as set in IB, if that is where you set up your view.

the table will ask for it's data, including the number or sections and number of rows in each section with the methods from the UITableViewDataSource protocol:

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView
- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
and
- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath

these almost always come from an array that you have set up with your data, so:

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section
{
    return [myData count];
}

so if you delete a row from the table, but don't delete the row from your array of data, this can cause problems.

as mentioned in the earlier posts, it's best to delete the row from your array, and then reload the table, allowing it to adjust itself.

if you want to delete the row from the table, make sure you delete it from the array, so that next time it is loaded, it will be loaded correctly.

this is my code:

- (void)tableViewUITableView *)tableView commitEditingStyleUITableViewCellEditingStyle)ed itingStyle forRowAtIndexPathNSIndexPath *)indexPath {

if (editingStyle == UITableViewCellEditingStyleDelete) {
// Delete the row from the data source

NSDictionary *itemAtIndex = (NSDictionary *)[dataList objectAtIndex:indexPath.row];
NSString *indice = [itemAtIndex objectForKey:@"id"];



NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDire ctory, NSUserDomainMask, YES);
NSString *documentsDir = [documentPaths objectAtIndex:0];
NSString *path = [documentsDir stringByAppendingPathComponent:@"codici.sqlite"];


//NSString *defaultDBPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"codici.sqlite"];
NSString *defaultDBPath = path;

NSLog(@"path: %@", defaultDBPath);


// Open the database from the users filessytem
NSInteger dbOpen;
dbOpen = sqlite3_open([defaultDBPath UTF8String], &database);

NSLog(@"sqlite3_step error: '%s'", sqlite3_errmsg(database));

NSLog(@"dbopen: %@", dbOpen);

if(dbOpen == SQLITE_OK) {


// Setup the SQL Statement and compile it for faster access
NSString *strSqlStatement = [@"delete from codici where id =" stringByAppendingFormat:@"('%@')",indice];



char *sqlStatement = (char *)[strSqlStatement UTF8String];

NSInteger dbSvar;
char *err;
dbSvar = sqlite3_exec(database, sqlStatement, NULL, NULL, &err);



if(dbSvar == SQLITE_OK) {
NSLog(@"Data removed from database");





//[tableView deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:UITableViewRowAnimationFade];

//Delete the object from the table.

[self.tableView deleteRowsAtIndexPaths:[NSArray arrayWithObject:indexPath] withRowAnimation:UITableViewRowAnimationFade];
[tableView reloadData];





}
else{

NSLog(@"Error: %@", [NSString stringWithUTF8String:err]);


}


}
sqlite3_close(database);
}


else if (editingStyle == UITableViewCellEditingStyleInsert) {
// Create a new instance of the appropriate class, insert it into the array, and add a new row to the table view
}


}

[ikaroweb]

someone help me?
I tried with a new project and get the same error.

[ikaroweb]

i've added this line:

dataList = [[Data alloc] init:defaultDBPath];

this line reload the datalist with the db updated.

before to delete the row from the table and now works fine!

[mickm]

Originally Posted by ikaroweb

i've added this line:

dataList = [[Data alloc] init:defaultDBPath];

this line reload the datalist with the db updated.

before to delete the row from the table and now works fine!

glad you got it worked out! sorry for losing track of this, just got really busy...

[fousulameen]

just make sure this method is defined or not with out this method row will not be deleted from table

- (void)setEditingBOOL)editing animatedBOOL)animate{

[super setEditing:editing animated:animate];
[self.nametable setEditing:editing animated:YES];
}