populate array in sqlite while

Question

I am doing something fundamental wrong but I am searching for better examples on the net and is coming up short :-(

in .h @interface MyDataViewController : UIViewController {

NSArray *array;
}
@property (nonatomic, retain) NSArray *array;

in m

@synthesize array;

succesful dbretrieval:

while (sqlite3_step(statement) == SQLITE_ROW) {
            //I guess this one is wrong but I cant figure it out.. (tired?)
            array = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)];

//testoutput to textfield:
            //myName.text  = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)];
//testoutput to nslog:
            NSLog(@"Data: %@",[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)]);

        }

Outputs the last from sqlitequeryn:

NSLog(@"%@", array);

Stian Storrvik · Accepted Answer · 2011-04-05 21:22:55Z

2

What are your output and what do you expect from this? You are directly putting a NSString into a NSArray, of which might, or might not be done several times for a static NSArray.

If you are planning on putting several strings into your array, you should have a NSMutableArray and simply addObject every time you loop through your while:

NSMutableArray *array = [[NSMutableArray alloc] init];
...code....
while (sqlite3_step(statement) == SQLITE_ROW) {
    [array addObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)]];
}

answered Apr 5, 2011 at 21:22

Stian Storrvik

2,1992 gold badges14 silver badges22 bronze badges

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

3 Comments

Martin Over a year ago

works like a charm. how do I set this question to answered...? it says "I can accept an anser within 2 min..."

Stian Storrvik Over a year ago

great! don't forget to handle error messages in your sqlite3 queries, if you absolutely have to use it. I would rather recommend Core Data for basically any db-application for iPhone. A nice tutorial is here by Ray Wenderlich, who also has a lot of other useful tutorials :)

Martin Over a year ago

thx, I will remember to handle the error messages. As of now I will use a static db with controlled querys so I hope that wont be a hazzle.

Collectives™ on Stack Overflow

populate array in sqlite while

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