Subscribe ( )

iPhone Programming Tutorials



You must be logged in to post Login Register


SQLite Queries

User Post

7:04 am
October 25, 2008



posts 9


I have two tables

table one is a list of Categories.

Table two is a list of games. with a column CategoryID that is referencing the Cateogry PK field. I have figured transitionning out from table one to table two.  What I am trying to figure out is how to run the query in the appDelegate when I change from the Category tableView to the Game TableView so that it limits the result to just those that match the category that was selected.

Currently I have a NSInteger named cid that is set to the selected Category's id when the tableCell is selected.  It then pushes to the next view.

So basically i need to re-run the query i have setup in the appDelegate Currently looks like:

“SELECT pk FROM game WHERE cid = ?”

thanks for any suggestions.

About the iCodeBlog forum

Currently Online:

3 Guests

Maximum Online: 19


Groups: 2

Forums: 6

Topics: 156

Posts: 503


There are 268 members

There are 1 guests

Brandon has made 81 posts

Top Posters:

bobcubsfan - 48

crazyiez - 30

Uhu - 17

VertigoSol - 17

Nick - 15

Administrator: Brandon | Moderators: VertigoSol

© - Version 3.1.4 (Build 357)  

Share and Enjoy: