开发者

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..

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜