Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- how to updtae Sqlite last insert row id in iphone?
- -(void)submit
- {
- if( ([UserName.text isEqualToString:@""]) || ([Password.text isEqualToString:@""]) ||
- ([ConfirmPassword.text isEqualToString:@""]) || ([Name.text isEqualToString:@""]) ||
- ([Email.text isEqualToString:@""]) || ([ContactNO.text isEqualToString:@""]) ||
- ([MobileNo.text isEqualToString:@""]) || ([Address.text isEqualToString:@""]) )
- {
- UIAlertView *ErrorAlert = [[UIAlertView alloc] initWithTitle:@"Error!!"
- message:@"Please fill in the details." delegate:nil
- cancelButtonTitle:@"OK"
- otherButtonTitles:nil, nil];
- [ErrorAlert show];
- [ErrorAlert release];
- }
- else
- {
- Confirmation_form *conForm = [[Confirmation_form alloc] initWithNibName:@"Confirmation_form" bundle:nil];
- conForm.data = UserName.text;
- conForm.data1 = Password.text;
- conForm.data2 = ConfirmPassword.text;
- conForm.data3 = Name.text;
- conForm.data4 = Email.text;
- conForm.data5 = ContactNO.text;
- conForm.data6 = MobileNo.text;
- conForm.data7 = Address.text;
- sqlite3_stmt *statement;
- const char *dbpath = [databasePath UTF8String];
- if (sqlite3_open(dbpath, &test1DB) == SQLITE_OK)
- {
- NSString *insertSQL = [NSString stringWithFormat:@"INSERT INTO test(UserName, Password, ConfirmPassword, Name, Email, ContactNO, MobileNo, Address) VALUES ("%@", "%@", "%@", "%@", "%@", "%@", "%@", "%@")",UserName.text, Password.text, ConfirmPassword.text, Name.text, Email.text, ContactNO.text, MobileNo.text, Address.text];
- const char *insert_stmt = [insertSQL UTF8String];
- sqlite3_prepare_v2(test1DB, insert_stmt, -1, &statement, NULL);
- if(sqlite3_step(statement) == SQLITE_DONE)
- {
- //status.text = @"Contact added";
- UserName.text = @"";
- Password.text = @"";
- ConfirmPassword.text = @"";
- Name.text = @"";
- Email.text = @"";
- ContactNO.text = @"";
- MobileNo.text = @"";
- Address.text = @"";
- sqlite3_last_insert_rowid;
- rowID = sqlite3_last_insert_rowid(test1DB);
- NSLog(@"last inserted rowId = %d",rowID);
- sqlite3_reset(statement);
- sqlite3_finalize(statement);
- sqlite3_close(test1DB);
- [self.navigationController pushViewController:conForm animated:YES];
- }
- }
- }
- }
- -(IBAction)Update;
- {
- sqlite3_stmt *statement;
- const char *dbpath = [databasePath UTF8String];
- if (sqlite3_open(dbpath, &test1DB) == SQLITE_OK)
- {
- NSString *insertSQL = [NSString stringWithFormat:@"UPDATE test SET UserName='%@',Password='%@',ConfirmPassword='%@',Name='%@',Email='%@',ContactNO='%@',MobileNO='%@',Address='%@'WHERE ID='%@'",UserName.text,Password.text,ConfirmPassword.text, Name.text, Email.text, ContactNO.text, MobileNo.text, Address.text, sqlite3_last_insert_rowid(test1DB)];
- const char *insert_stmt = [insertSQL UTF8String];
- sqlite3_prepare_v2(test1DB, insert_stmt, -1, &statement, NULL);
- if(sqlite3_step(statement) == SQLITE_DONE)
- {
- sqlite3_step(statement);
- UIAlertView *alert = [[UIAlertView alloc]initWithTitle:@"UIAlertView" message:@"Record added" delegate:self cancelButtonTitle:@"OK" otherButtonTitles:nil];
- [alert show];
- [alert release];
- alert = nil;
- sqlite3_finalize(statement);
- sqlite3_close(test1DB);
- }
- else {
- sqlite3_step(statement);
- UIAlertView *alert = [[UIAlertView alloc]initWithTitle:@"UIAlertView" message:@"Record notadded" delegate:self cancelButtonTitle:@"OK" otherButtonTitles:nil];
- [alert show];
- [alert release];
- alert = nil;
- }
- }
Add Comment
Please, Sign In to add comment