Problem With Sqlite Data Retrieving

Question

I have an SQLite database, and when I am trying to get the data from the database, I get the last inserted element repeatedly. How can I get all the elements with no repetition.

The code I've written:

- (NSMutableArray *) gettingData {


    sqlDict = [[NSMutableDictionary alloc] init];

    membersInfoArray =[[NSMutableArray alloc]init ];


     [self checkAndCreateDatabase];

    if (sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
     {

    const char *sql = "select * from ProductList";

     sqlite3_stmt *selectstmt;
    if(sqlite3_prepare_v2(database, sql, -1, &selectstmt, NULL) == SQLITE_OK) 
    {
        while(sqlite3_step(selectstmt) == SQLITE_ROW)
        {


       NSString *prdbcode = [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectstmt, 0)];

     [sqlDict setObject:prdbcode forKey:@"Barcode"];


     [prdbcode release];


      NSString *prdname = [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectstmt, 1)]; 


     [sqlDict setObject:prdname forKey:@"ProductName"];

      [prdname release];
       NSString *prdDesc = [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectstmt, 2)];
      [sqlDict setObject:prdDesc forKey:@"ProductDescription"];
      [prdDesc release];
      NSString *prdstatus = [NSString stringWithUTF8String:(char *)sqlite3_column_text(selectstmt, 3)];

     [sqlDict setObject:prdstatus forKey:@"ProductStatus"];
     [prdstatus release];
     [membersInfoArray addObject:sqlDict];
     [sqlDict release];

        }

     }

     sqlite3_finalize(selectstmt);   

     }

     sqlite3_close(database);
     return membersInfoArray;
    }

I am retrieving the data as follows:

NSMutableArray *sqlArray = [sqlViewController gettingData];

Thank you.

@Prabah Nothing wrong in above method. How do you access the values ? Can you please post that code too ? — Janak Nirmal
– Janak Nirmal, Commented May 3, 2011 at 5:27
@Prabah try cleaning the build from the application and deleting your application from simulator and re run. There is nothing wrong with the code above you are writing. And should not be the case, still open database from the installed location and verify the records. — Janak Nirmal
– Janak Nirmal, Commented May 3, 2011 at 5:49

Sandeep Singh · Accepted Answer · 2011-05-04 07:01:31Z

1

Just Declare your array globally instead of declare locally in your method. Your problem will resolved.

answered May 4, 2011 at 7:01

Sandeep Singh

8262 gold badges10 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Problem With Sqlite Data Retrieving

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related