mardi 25 août 2015

Data are not inserting into sqliteDB iOS

I have created a table(REPORTDATA) in existing database. I am trying to insert the values in to table. But it is not inserted. I am using the following code.

dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
docsDir = dirPaths[0];
databasePath = [docsDir stringByAppendingPathComponent:@"Album.db"];
const char *dbpath = [databasePath UTF8String];
NSString *insertSQL;
if (sqlite3_open(dbpath, & albumDB) == SQLITE_OK)
{
    int rowCount = [self GetArticlesCount];
    rowCount += 1;
    NSString *tempcount = [NSString stringWithFormat:@"%d", rowCount];
    insertSQL = [NSString stringWithFormat: @"INSERT INTO REPORTDATA (Num, Json) VALUES ('%@','%@')", tempcount, tempcount];
    char *errmsg=nil;
    if(sqlite3_exec(albumDB, [insertSQL UTF8String], NULL, NULL, &errmsg)==SQLITE_OK)
    {
    }
    else
    {
        NSLog(@"Error Message is =%s",errmsg);
    }
}
sqlite3_close(albumDB);

I am getting Error Message is =(null).

Please advice.

Aucun commentaire:

Enregistrer un commentaire