Problem With SQLITE

[Khurshid]

hi
i have build an application that is using sqlite3. i can add and delete data from sqlite.
problem is with updating data.
i am using tableview to display account names, and when user select row from tableview, i display all detail about selected account in a detailview. here (in detail view ) user will see existing values and can change/update that value
now my problem is that updation is not taking place i can edit values but icant see updated values in sqlite DB or in table view.
any help regarding this will be appreciated

Thanks.

[nestedloop]

Please post code of your Update method (the one where you update the data in the DB).

[Khurshid]

Originally Posted by nestedloop

Please post code of your Update method (the one where you update the data in the DB).

- (void) updateData {

if(updateStmt == nil) {

const char *sql = "update tbl Set f1 = ?,f2 = ?,f3 = ?,f4 = ?,f5= ?,f6 = ? Where ID = ?";
if(sqlite3_prepare_v2(database, sql, -1, &updateStmt, NULL) != SQLITE_OK)
NSAssert1(0, @"Error while creating update statement. '%s'", sqlite3_errmsg(database));
}

sqlite3_bind_text(updateStmt, 1, [name UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 2, [a UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 3, [b UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 4, [c UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 5, [d UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(updateStmt, 6, [he UTF8String], -1, SQLITE_TRANSIENT);

sqlite3_bind_int(updateStmt, 7, uniqueId);

if(SQLITE_DONE != sqlite3_step(updateStmt))
NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database));
else
//SQLite provides a method to get the last primary key inserted by using sqlite3_last_insert_rowid
//uniqueId = sqlite3_last_insert_rowid(database);

//Reset the add statement.
sqlite3_reset(updateStmt);

[nestedloop]

This seems alright... Have you checked if the variables (name, a, b, c, d, he, uniqueId) have the correct values when running the update function? I mean, after you modify the data in the UI, do they contain the new values, that are to be written in DB?

Cheers.

[Khurshid]

Originally Posted by nestedloop

This seems alright... Have you checked if the variables (name, a, b, c, d, he, uniqueId) have the correct values when running the update function? I mean, after you modify the data in the UI, do they contain the new values, that are to be written in DB?

Cheers.

thanks for your time i solved issue.

[nestedloop]

What was the problem?

[Khurshid]

Originally Posted by nestedloop

What was the problem?

problem was with id (pk)
now i have set the value of PK to value of pk of data that is being edited