table value is not updated using update statement
<p>i need to update a column value into table.</p>

<p>for that my code is,</p>

<pre><code>NSString *sql_str = [NSString stringWithFormat:@"update %@ Set Quantiry = %@ Where ItemName = %@", tableName,quantity,itemname];
    const char *sqlStatement = (char *)[sql_str UTF8String];
    NSLog(@"query %s",sqlStatement);
    sqlite3_stmt *compiledStatement;

    sqlite3_prepare_v2(database, sqlStatement, -1, &amp;compiledStatement, NULL);

    sqlite3_close(database);
</code></pre>

<p>displayed query in console is <code>update allcategories Set Quantiry = 11 Where ItemName = Bananas</code></p>

<p>but the value in table is not updated.</p>

<p>what the wrong,can any one please help me.</p>

<p>Thank u in advance.</p>
