-(BOOL) updatedata:(NSString*)name mobileno:(NSString*)mobileno
email:(NSString*)email gender:(NSString*)gender address1:(NSString*)address1 address2:(NSString*)address2 city:(NSString*)city state:(NSString*)state country:(NSString*)country pincode:(NSString*)pincode dob:(NSString*)dob
{
// trying new
const char *dbpath = [databasePath UTF8String];
if (sqlite3_open(dbpath, &database) == SQLITE_OK)
{
const char *sqlQuery = "UPDATE studentsDetail SET name = ?,mobileno = ?,email = ?,gender = ?,address1 = ?,address2 = ?,city = ?,state = ?,country = ?,pincode = ?,dob = ? WHERE name == ?";
sqlite3_stmt *query = nil;
int retVal;
if ((retVal = sqlite3_prepare_v2(database, sqlQuery, -1, &query, NULL)) == SQLITE_OK) {
sqlite3_bind_text(query, 1, [name UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 2, [mobileno UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 3, [email UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 4, [gender UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 5, [address1 UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 6, [address2 UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 7, [city UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 8, [state UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 9, [country UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 10, [pincode UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 11, [dob UTF8String], -1, SQLITE_TRANSIENT );
sqlite3_bind_text(query, 12, [name UTF8String], -1, SQLITE_TRANSIENT );
int result;
if ((result =sqlite3_step(query)) != SQLITE_DONE) {
NSLog(@"Failed to execute the query %d",result);
}
else {
NSLog(@"Succesfully updated row !");
}
sqlite3_reset(query);
sqlite3_finalize(query);
}
else {
NSLog(@ "Error in preparing UPDATE statement %d",retVal);
}
int result1 = sqlite3_close(database);
if (result1 != SQLITE_OK){
NSLog(@"Failure in closing connection to database. Result %d",result1);
}
else {
NSLog(@ "Successfully closed DB connection ") ;
}
}
return YES;
}
i am getting an error as:
"Failed to execute the query 5"
which line of the code is wrong in it....