mardi 5 avril 2016

sqlite querry returns error objective c iOS

i'm making a view lyric apps,
and i have a feature "Favourite lyric" in my apps,

but when i compile my add to favourite, it doesn't work,
it's print Error



i guess it doesn't work in here sqlite3_step(stmt)==SQLITE_DONE

here's my insert fav method :

-(void)insertFav:(Favorite*)fav{

    fileMgrs = [NSFileManager defaultManager];
    sqlite3_stmt *stmt=nil;


    NSString *sqlQuery=[NSString stringWithFormat:@"INSERT INTO listfavorite (email,id) VALUES ('%@','%d') ;",fav.email,fav.id];

    NSLog(@"query:%@",sqlQuery);
    const char *sql =[sqlQuery cStringUsingEncoding:NSUTF8StringEncoding];


    //Open db
    NSString *cruddatabase = [self.GetCacheDirectory stringByAppendingPathComponent:@"mydatabase.sqlite"];
    sqlite3_open([cruddatabase UTF8String], &db);
    sqlite3_prepare_v2(db, sql, -1, &stmt, NULL);

    if(sqlite3_step(stmt)==SQLITE_DONE)
    {
        NSLog(@"masuk woy");
    }

    else{
        NSLog(@"ERROR");

    }

    sqlite3_reset(stmt);

    sqlite3_finalize(stmt);
    sqlite3_close(db);
}

Here's my listfavorite database table : database

Aucun commentaire:

Enregistrer un commentaire