CODEWITHSUNDEEP
iphoneiosipad
pradeepj
pradeepj

Reputation: 516

Not saving data in SQLite

Every thing goes in code, but not saving data in SQLite db. Can any one help on this?

Find my code below:

-(IBAction)signin:(id)sender{
    NSLog(@"%@",perDas.string1);
    nameString=[[NSString alloc]initWithString:perDas.string1];
     statusString=[[NSString alloc]initWithFormat:@"IN"];
    {
        NSLog(@"passed");
        sqlite3_stmt    *statement;

        const char *dbpath = [perDas.databasePath UTF8String];

        if (sqlite3_open(dbpath, &database) == SQLITE_OK)
        {
            NSLog(@"pass");
            NSString *insertSQL = [NSString stringWithFormat: @"INSERT INTO status  VALUES (\"%@\", \"%@\", datetime(), \"%@\")", nameString, statusString,empString];
            NSLog(@"%@",insertSQL);
            const char *insert_stmt = [insertSQL UTF8String];

            sqlite3_prepare_v2(database, insert_stmt, -1, &statement, NULL);

            sqlite3_finalize(statement);
            sqlite3_close(database);

    }
    }}

Thanks in advance

Upvotes: 2

Views: 584

Answers (2)

Krunal
Krunal

Reputation: 6490

-(IBAction)signin:(id)sender{
    NSArray *dirPath;
    NSString *docDir;
    NSString *databasePath;

    dirPath=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    docDir=[dirPath objectAtIndex:0];
    databasePath=[docDir stringByAppendingPathComponent:@"YourDB.sql"];

    const char *dbPath=[databasePath UTF8String];

    if(sqlite3_open(dbPath, &db)==SQLITE_OK)
    {

        NSString *insertSQL =  [NSString stringWithFormat: @"INSERT INTO status  VALUES (\"%@\", \"%@\", datetime(), \"%@\")", nameString, statusString,empString];


        const char *insertStmt=[insertSQL UTF8String];

        char *errmsg=nil;

        if(sqlite3_exec(db, insertStmt, NULL, NULL, &errmsg)==SQLITE_OK)
        {
             NSLog(@"ADDED!");
        }

        sqlite3_close(db);
    }
 }

Upvotes: 1

CarlJ
CarlJ

Reputation: 9481

you should check if your sql statement is correct:

if (sqlite3_prepare_v2(database, insert_stmt, -1, &statement, NULL) == SQLITE_OK) {
...
}

and if you only INSERT a subset of your row set, use this INSERT Statement form:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

Upvotes: 0

Related Questions