SQLite, can not delete from table
I want to delete table from my database, this is my coding:
-(void)deleteDataFromDatabase:(NSString *)typeStr
{
if ([typeStr isEqualToString:@"village"])
{
NSLog(@" ======== DELETE DELETE DELETE DELETE DELETE DELETE DELETE DELETE ");
const char *sql = "DELETE FROM Village WHERE pk=?";
if (sqlite3_prepare_v2(dbFavoriteTab, sql, -1, &delete_statement, NULL) == SQLITE_OK)
{
sqlite3_bind_int(delete_statement, 1, primaryKey);
// Execute the query.
int success = sqlite3_step(delete_statement);
// Reset the statement for future use.
sqlite3_reset(delete_stat开发者_如何学运维ement);
// Handle errors.
if (success != SQLITE_DONE)
{
NSLog(@"UNSUCCESSFILLLL IN Village");
NSAssert1(0, @"Error: failed to delete from database with message '%s'.", sqlite3_errmsg(database));
}
else {
NSLog(@" === Delete Successful === ");
}
}
else {
NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(database));
}
}
I am unable to delete database. The console show me UNSUCCESSFUL IN VILLAGE....i am working on since last 3 days..
精彩评论