Storing an array into SQLite database

Question

I have 2 columns of type VARCHAR(1000) and type TEXT in a SQLite db. My requirement is to store the values in an array into the db. I tried storing the values in the array into a string using the for loop but once the control comes out of the for loop the values displayed for the string is only the last element in the array...

Is there any way using which I can directly store the array into the DB??

Below is my code:

NSString *tempVal=0, *tempFlag=0;
NSString *temp[256], *Flag[256];

    for(int i=0; i<256; i++)
    {
    NSLog(@"HELLO %d", tempVal);
        temp[i] = (NSString*)valMines[i];
        Flag[i] = (NSString*)openFlag[i];

        NSLog(@"ValMines is %d", temp[i]);
        NSLog(@"OpenFlag is %d", Flag[i]);

        tempVal = temp[i];
        tempFlag == Flag[i];

        NSLog(@"ValMines is %d %d", temp[i], tempVal);
    }

NSLog(@"Inside Save Data func");
NSLog(@"ValMines is %d", tempVal);
NSLog(@"OpenFlag is %d", tempFlag);

Would append work on it? How?

Community · Accepted Answer · 2017-05-23 11:55:45Z

1

According to this other post, SQLite does not support arrays directly. It only does ints, text and floats.

How to store array in one column in Sqlite3?

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Sep 9, 2011 at 6:46

Edward Castano

6172 gold badges8 silver badges14 bronze badges

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

Comments

Black Frog · Accepted Answer · 2011-04-16 19:09:56Z

0

Try this:

NSMutableString *tempVal = [NSMutableString stringWithCapacity:1000];
NSMutableString *tempFlag = [NSMutableString stringWithCapacity:256];

for (int i = 0; i < 256; i++)
{      
    NSLog(@"ValMines is %@", valMines[i]);
    NSLog(@"OpenFlag is %@", openFlag[i]);

    // adding a space between each string
    [tempVal appendFormat:@" %@", valMines[i]];
    [tempFlag appendFormat:@" %@", openFlag[i]];
}

NSLog(@"Inside Save Data func");
NSLog(@"ValMines is %@", tempVal);
NSLog(@"OpenFlag is %@", tempFlag);

answered Apr 16, 2011 at 19:09

Black Frog

11.7k1 gold badge37 silver badges67 bronze badges

1 Comment

user688175 Over a year ago

No its not working... I think its taking some junked values and printing it out

Collectives™ on Stack Overflow

Storing an array into SQLite database

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related