Insert statement not working for second table on same database in sqlite3 iphone

Question

I have 2 tables on same database.

For first table data is inserted successfully using below code:

       NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,  NSUserDomainMask, YES);
       NSString *documentsDirectory = [paths objectAtIndex:0];
        NSString *databasePath = [documentsDirectory stringByAppendingPathComponent:@"test.sqlite"];
if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {

(sqlite3_exec(database, "BEGIN TRANSACTION", 0, 0, 0))==SQLITE_OK

   if ( sqlite3_exec(database, [insertStatement UTF8String], NULL, NULL, &error) == SQLITE_OK)
        {

            NSLog(@"------- inserted here ----");
        }
        else
        {
            NSLog(@"Error: %s", error);

     if(sqlite3_exec(database, "COMMIT", 0, 0, 0) ==SQLITE_OK){
           NSLog(@"-------data sucessfully inserted ");
      }
      else {
         NSLog(@"-------data insertion failed");
          sqlite3_exec(database, "ROLLBACK", 0, 0, 0);
      }

       (sqlite3_exec(database, "END TRANSACTION", 0, 0, 0));
        sqlite3_close(database);


}
else {
   NSLog(@"-------sqlite open error ");
}

The data is inserted successfully as I log.

But when I use the same code for inserting into second table, no data is inserted I get log of

NSLog(@"-------data insertion failed")

I am also opening and closing database at each operation and releasing the handle.

I think sqlite is not allowing me to write on database but don't understand why? Since I have closed database with earlier operation.

Does anyone encountered same problem with no data insertion for 2nd table on same database file.

Addt note: there are no syntax errors and if I don't insert on 1st table then insertion is done on 2nd table which is weird.

check your query ? whether it is proper or not.

Krunal
– Krunal

2012-08-17 12:42:48 +00:00
Commented Aug 17, 2012 at 12:42 — Krunal
– Krunal, Commented Aug 17, 2012 at 12:42

marc_s · Accepted Answer · 2015-08-13 05:08:22Z

3

Try with this code,

-(NSString*) GetDatabasePath
{
    NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, 
        NSUserDomainMask, YES) ;
    NSString *documentsDirectory = [paths objectAtIndex:0] ;
    return [documentsDirectory stringByAppendingPathComponent:@"test.sqlite"] ;
}

-(void)InsertPurchase 
{
        sqlite3_stmt *statement=nil;
        NSString *path = [self GetDatabasePath];
        NSString *query;

        if(sqlite3_open([path UTF8String],&db) == SQLITE_OK)
        {
            query = [NSString stringWithFormat: @"Your insert query"];

            if(sqlite3_prepare_v2(db, [query UTF8String], -1, &statement, NULL)
                        == SQLITE_OK)
            {
                sqlite3_step(statement);
            }
            sqlite3_finalize(statement);
        }
        sqlite3_close(db);
}

edited Aug 13, 2015 at 5:08

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Aug 17, 2012 at 12:45

Krunal

6,49022 gold badges95 silver badges156 bronze badges

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

3 Comments

Mike Over a year ago

i am using the same just additional transactions for faster execution, but my q is why my second table is not getting inserted for the same db? Even after closing end ending the transactions after first insertion? Moreover if i override first then second table works well, is it something to do with write issues within same db but in diff. table

Mike Over a year ago

i happen to replace my ( sqlite3_exec(database, [insertStatement UTF8String], NULL, NULL, &error) == SQLITE_OK) with your prepare statment and it works. Thankx Krunal

Krunal Over a year ago

accepting ans means click on the check mark which is on left side of my answer, when you click it will turn green. see here for e.g.:meta.stackexchange.com/questions/5234/…

Collectives™ on Stack Overflow

Insert statement not working for second table on same database in sqlite3 iphone

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related