how to fetch data from sqlite into an array

Question

This is my code. It is only returning the first row from database. I know something is really wrong but don't know what. Please help.

if(sqlite3_open([databasePath UTF8String],&texttalkdb)==SQLITE_OK)
{
    sqlite3_stmt *statement;

    if(sqlite3_prepare_v2(texttalkdb, [sql UTF8String], -1,&statement, NULL)==SQLITE_OK)
    {
        if(sqlite3_step(statement)==SQLITE_ROW)
        {
            for(int i=0;i<=20;i++)
        {
            char *pass=(char*)sqlite3_column_text(statement,i);
            NSString *passStr = [NSString stringWithFormat:@"%s",pass];

                NSString *msg=[[NSString alloc]initWithUTF8String:pass];
                [arr addObject:msg];
          }
        }
        sqlite3_finalize(statement);
    }
    sqlite3_close(texttalkdb);
}
NSLog(@"%@",arr);
return arr;

Prasanth S · Accepted Answer · 2014-10-31 09:54:02Z

2

Try this

if(sqlite3_prepare_v2(texttalkdb, [sql UTF8String], -1,&statement, NULL)==SQLITE_OK)
{
            while( sqlite3_step(statement) == SQLITE_ROW )
            {
            //get records   
        }
}

answered Oct 31, 2014 at 9:54

Prasanth S

3,8329 gold badges46 silver badges78 bronze badges

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

Comments

Rajesh Loganathan · Accepted Answer · 2014-10-31 10:11:40Z

Step 1: This is for check the getting values is empty or not

 +(NSString*)charToString:(char*)chart
 {
    NSString *string = @" ";
    if(string)
    {
      chart = [self checkEmptyChar:chart];
      string=[NSString stringWithUTF8String:chart];
    }
   return string;
 }

Step 2: This is for checking character

+(char *)checkEmptyChar:(char *)check
{
  NSString *string = @" ";
  if (check == NULL)
    check = string;
  return check;
}

Step 3: To fetch SQLite Coding

 if (sqlite3_prepare_v2(database, [query UTF8String], -1, &stment, nil) == SQLITE_OK)

    {
        while (sqlite3_step(stment) == SQLITE_ROW)

        {

            for(int i=0;i<=20;i++)

            {
                 NSString *msg = [self charToString: (char *)sqlite3_column_text(stment, i)];

                 [array addObject:msg];
            } 

        }

        sqlite3_reset(stment);
    }

    sqlite3_finalize(stment);
 }

sqlite3_close(database);

Collectives™ on Stack Overflow

how to fetch data from sqlite into an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related