Re: Cant read second table from same sqlite database iphone
Re: Cant read second table from same sqlite database iphone
- Subject: Re: Cant read second table from same sqlite database iphone
- From: charisse napeÿfffff1as <email@hidden>
- Date: Sun, 11 Apr 2010 18:50:48 -0700 (PDT)
I forgot to change the index to 1 but anyway I finally got it working. I guess its a copy problem from my createDatabaseIfNeeded function. since I already have a copy of the databse in the Users/Documents in the iphone simulator, after I've added data inside the second table, it wouldn't reflect in the query because my copy of the databse is outdated. I had to delete the existing database inside so my code can generate a new updated copy. My mistake is that I added data in the second table even after I have already used it.
________________________________
From: Andrew Farmer <email@hidden>
To: charisse napeÿfffff1as <email@hidden>
Cc: email@hidden
Sent: Monday, April 12, 2010 4:10:21
Subject: Re: Cant read second table from same sqlite database iphone
On 10 Apr 2010, at 18:02, charisse napeÿfffff1as wrote:
> //get the name and the score
> int iDen = sqlite3_column_int(statement, 0);
> NSString* name = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)];
Surely column 0 cannot be both an integer and text. Which one is it?
Get your preferred Email name!
Now you can @ymail.com and @rocketmail.com.
http://mail.promotions.yahoo.com/newdomains/aa/
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden