issue in inserting data in sqlite database

Question

this is how i try to add data in sqlite database everything works perfectly but data is not getting added in database i dont understand why can you please refer the code and tell me what am i doing wrong

    sqlite3_stmt *stmt;
    int x;

    char *update = "insert into PersonNamesAndBirthDates (Names,Birthdates,Phonenumber,Email,Profilepic) values(?,?,?,?,?);";
    x = sqlite3_prepare_v2(database1, update, -1, &stmt, nil);

    if (x == SQLITE_OK)
    {
        NSLog(@"PersonName is -->%@",[NSString stringWithFormat:@"%@",[_Namebarray objectAtIndex:0]]);
        NSLog(@"BirthDates is -->%@",[NSString stringWithFormat:@"%@",[_Birthdatebarray objectAtIndex:0]]);
        NSLog(@"BirthDates is -->%@",[NSString stringWithFormat:@"%@",[_Phonearray objectAtIndex:0]]);
        NSLog(@"BirthDates is -->%@",[NSString stringWithFormat:@"%@",[_Emailarray objectAtIndex:0]]);
        // if else will come here for checking weather images has added or not if added then store Yes Image if not then simply No image for default image.


        sqlite3_bind_text(stmt, 1, [[NSString stringWithFormat:@"%@",[_Namebarray objectAtIndex:0]] UTF8String],-1, NULL);
        sqlite3_bind_text(stmt, 2, [[NSString stringWithFormat:@"%@",[_Birthdatebarray objectAtIndex:0]] UTF8String],-1, NULL);
        sqlite3_bind_text(stmt, 3, [[NSString stringWithFormat:@"%@",[_Phonearray objectAtIndex:0]] UTF8String],-1, NULL);
        sqlite3_bind_text(stmt, 4, [[NSString stringWithFormat:@"%@",[_Emailarray objectAtIndex:0]] UTF8String],-1, NULL);
        if(selectImage.image)
        {
            sqlite3_bind_text(stmt, 5, [[NSString stringWithFormat:@"%@",[_arrayOfPaths objectAtIndex:0]] UTF8String],-1, NULL);
        }
        else{
            sqlite3_bind_text(stmt, 5, [[NSString stringWithFormat:@"%@",@"No Image"] UTF8String],-1, NULL);
        }
    }
    if (sqlite3_step(stmt) != SQLITE_DONE){}
    NSLog(@"Error: ");
    sqlite3_finalize(stmt);

what do you mean with data is not getting added in database?, are you getting an error? — tkanzakic
– tkanzakic, Commented Apr 24, 2013 at 8:00
where is you database file stored, in the app bundle or in the documents dir? — tkanzakic
– tkanzakic, Commented Apr 24, 2013 at 8:01

Prakash Desai · Accepted Answer · 2013-05-03 04:27:03Z

1

I see no error in your Code do check that your database is open like this

if (sqlite3_open(dbpath, &database1) == SQLITE_OK)

edited May 3, 2013 at 4:27

answered Apr 24, 2013 at 8:09

Prakash Desai

5113 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hot Licks Over a year ago

Further, the return code really should be captured and the value logged if not SQLITE_OK, plus one should log the result of calling sqlite3_errmsg if not OK. Especially when becoming familiar with SQLite, one should make a point to check and log every "abnormal" return code.

Aaron Bratcher · Accepted Answer · 2013-07-11 14:45:41Z

0

There is an example project for using SQLite here: https://github.com/AaronBratcher/ABSQLite

It has code in there for adding and reading data.

answered Jul 11, 2013 at 14:45

Aaron Bratcher

6,4813 gold badges48 silver badges76 bronze badges

Collectives™ on Stack Overflow

issue in inserting data in sqlite database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related