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 <andf...@gmail.com>
To: charisse napeÿfffff1as <cnape...@yahoo.com>
Cc: cocoa-dev@lists.apple.com
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 (Cocoa-dev@lists.apple.com)
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:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
