how can i update data in table using sqlite in obj c

Question

hii every one

can any one suggest me one good tutorial which shows update table in sqlite database

Jan Gressmann · Accepted Answer · 2011-05-05 09:48:48Z

1

Open your database with:

sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK;

To update a row:

@synchronized(sqlLock]) {
    // Setup the SQL Statement and compile it for faster access
    const char *sqlStatement = [[NSString stringWithFormat:@"UPDATE TABLE Set Text = ? where ID = '%@'",objectID] UTF8String];
    sqlite3_stmt *compiledStatement;
    if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {     

        sqlite3_bind_text(compiledStatement, 1, [text UTF8String], -1, SQLITE_TRANSIENT);

        if(SQLITE_DONE != sqlite3_step(compiledStatement))
            NSAssert1(0, @"Error while updating. '%s'", sqlite3_errmsg(database));

        sqlite3_reset(compiledStatement);
    }
    // Release the compiled statement from memory
    sqlite3_finalize(compiledStatement);    
}

answered May 5, 2011 at 9:48

Jan Gressmann

5,5415 gold badges35 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how can i update data in table using sqlite in obj c

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related