How to output rows in sqlite database in iphone app

Hi there, I'm making a iphone app that allows a user to retrieve data via some sql queries.

Basically I have made an app with a sqlite database that I have populated with 1 table and 2 rows (for now) until I get the app working. At that time, I'll add more data.

May I ask how you would recommend I output the data from each rows to the app screen? I have a ui like this:I enter data into a text field, push a button, and I need data to appear in the table view below. But how?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi Mark,

It sounds like you need to get up to speed with the basics.  It is good you are doing some test.  You need to understand and in my opinion use CoreData and not try to go directly to the sqlite database.  This will save you a lot of time and also allow for better cacheing of data like on a UITable where only the data needed will be loaded.

Thus I strongly suggest you doe any and all of Ray Wenderlichs tutorials.  I leant Core Data and did all of his example so that I understood how it worked.

Getting Started with CoreDate

Once you are up and runnng with Core data then you need to know about NSFetchedResultsController

but have a look at all of his tutorials under saving and loading data.

If you have a specific questions on this or any initial worries on why you should do these tutorials then just ask.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark_CoAuthor Commented:
Thank you :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.