how to check update query
<p>i want to add ycount field to 1;</p>

<p>ie ycount=ycount+1;</p>

<p>this is not working </p>

<pre><code>[self Check_Create_DB];
sqlite3 *database; 
NSString *sqlTmp=[NSString stringWithFormat:@"update images set ycount=ycount+1 where imgid= '%d'",idimg ];
NSLog(@"%@",sqlTmp);
const char *sqlstmt=[sqlTmp UTF8String];
sqlite3_stmt *cmp_sqlstmt;
int returnvalue=sqlite3_prepare_v2(database,sqlstmt,-1,&amp;cmp_sqlstmt,NULL);
NSLog(@"return value.....%d",returnvalue);
if(returnvalue == SQLITE_OK)
{           
    sqlite3_bind_int(cmp_sqlstmt,1,ycount+1);
}
</code></pre>

<p>what is the error in this code</p>
