Click here to Skip to main content
15,948,339 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
// This is deletion button
- (IBAction)deletedata:(id)sender {
NSArray *data1 = [[DBManager getSharedInstance]deletebyregisterno: findByRegisterNumberTextField.text];
if (data1 == nil) {
UIAlertView *alert = [[UIAlertView alloc]initWithTitle:
@"Data not found" message:nil delegate:nil cancelButtonTitle:
@"OK" otherButtonTitles:nil];
[alert show];
}
else
{
NSLog(@"delete success");

}
}


// this is in DBManger : NSObject

-(NSArray*) deletebyregisterno:(NSString*)registerNumber
{
NSLog(@"here");

const char *dbpath = [databasePath UTF8String];
if (sqlite3_open(dbpath, &database) == SQLITE_OK)
{
NSLog(@"here inside");

NSString *querySQL1 = [NSString stringWithFormat:@"delete from studentDetail where regno=\"%@\"",registerNumber];
const char *querySQL1_stat = [querySQL1 UTF8String];
if (sqlite3_prepare_v2(database, querySQL1_stat,-1, &statement, NULL)== SQLITE_OK)
{
if (sqlite3_step(statement) == SQLITE_DONE)
{
return YES;
NSLog(@"Deleted row");
}
}
else {
return NO;
}
sqlite3_reset(statement);
}
return nil;

}

on clicking deletion button is dispalys no data found...
what is wrong in it....
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900