HomeХобби и стильRelated VideosMore From: profgustin

iOS 6 SQLite3 Database - Retrieve Records (Part 5)

67 ratings | 15693 views
Part of the SQLite3 Database series. This demonstrates how to retrieve records from a SQLite3 database and populate a table view with the results. These are the videos in the iOS 6 SQLite3 Database Series: Basic Database Terminology http://www.youtube.com/watch?v=z8136vWng3c iOS 6 - SQLite3 Database Intro (Part 1) http://www.youtube.com/watch?v=kUb2F1NLCBc iOS 6 - Setting Up a SQLite3 Database (Part 2) http://www.youtube.com/watch?v=hMhkc8qaQG8 iOS 6 - Creating a Database Table (Part 3) http://www.youtube.com/watch?v=C3eMdrjPYkM iOS 6 - SQLite3 Adding Records (Part 4) http://www.youtube.com/watch?v=uxoeZ-1yCMc iOS 6 - SQLite3 Database - Retrieve Records (Part 5) http://www.youtube.com/watch?v=RQ34P_GkNe8
Html code for embedding videos on your blog
Text Comments (33)
Sumit Choudhary (2 years ago)
sir please tell me how to delete and update table in that code......and also give me that code thanks in advance
xi xiong tan (3 years ago)
Hi, this video is really helpful but how do i delete the record in the tableview as well as the database? Is it  possible to create another video on how to delete the record from database as well as the tableview? Much appreciated your help
fish330 (4 years ago)
Hi Prof, Wonderful wonderful instructional technique. PLEASE PLEASE and PRETTY Please, can you do one quick Tutorial to show how to delete a record from the sqlite3 database and the tableview. XXX
Robert McLeod (4 years ago)
It's the same thing.
Cheng Yang (4 years ago)
Hi! I did this on my program. However, every time I run it, the program always unexpectedly stop on line: cell.textLabel.text = [self.entries objectAtIndex:indexPath.row]; Could you help me out?  Thanks so so much!!
o0oDBSKsoulo0o (5 years ago)
Thank you so much for this great series of tutorials on SQLite, it helped me a lot!
Dilum Navanjana (5 years ago)
great tutorial...... watched all parts...... Thank you very much.....
Hugo Sanchez (5 years ago)
Really good tutorial. Thanks.
C Farrugia (5 years ago)
Can you make a new video showing how to delete a record? Thanks a lot
Amit Farkash (5 years ago)
Hello and thanks for this tutorial. I'm new to sqlite3 but shouldn't you call sqlite3_finalize() on the statement when done, if you're going to use sqlite3_prepare_v2() and sqlite3_step() ?? Also it would be nice to add updateEntry(), findEntry() and deleteEntry() for the completeness of the tutorial. Thanks again.
Luke Horton (5 years ago)
it'd be cool to be able to download the source
liang wang (5 years ago)
where is the bp.sql location?
Brad Haber (5 years ago)
Thank you so much! Everything is working great!
aelohin (5 years ago)
Great tutorial! it works like a charm. Thanks so much!
kawaiiyojang (5 years ago)
great tutorial thx. very helpful ^______^
John Doe (5 years ago)
Please please please expand on this and add updating and deleting 3 :-D
Mohammad Najafi (5 years ago)
Thank you. very helpful
jameson200 (5 years ago)
Thank you for such a great video, very inspirational. You explain each step extremely well, your videos are very enjoyable!! Would it please be possible for you to demonstrate how to remove records created from the db and the tableview? I have had ago myself but as I am a complete novice I am not having a lot of luck getting it to work, its very frustrating however I will not give up :). All the best and Thank you again!
Darrell Nicholas (5 years ago)
Just finished all parts of this exercise. Great job, I love the way you explain everything. Can't wait to start another one of your lessons. Keep up the good work, it IS appreciated! I have some experience with languages like Python, Ruby, and PHP. This is really helping me learn Objective-C and Xcode. Thanks again.
Alvaro Rausell (5 years ago)
Excuse me, when i run it it pauses and says: Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[FlipsideViewController tableView:numberOfRowsInSection:]: unrecognized selector sent to instance 0x745fc3
John Doe (5 years ago)
yes please editing and deleting continuous to these videos would be awesome ! :) Thank you this was sooo helpful :)
Johan Vassallo (5 years ago)
the web is such a wonderful place with tutorials like these..thnks!
Lorenz De Guzman (5 years ago)
pls add deleting and editing tutorials..LOVE your videos..really really helpful!
Chad Nixon (5 years ago)
I like the way that you do your tuts. I would like to have what you have here but I would like to be able to edit the text of table you have entered. Do you know of a link or do you have one that you have made?
NukedenE (5 years ago)
waiting delete row from database :)
Christopher Wilcox (6 years ago)
Great tutorial. Would it be difficult to explain how to use a DB file that already exists?
Riving Amin (6 years ago)
Is it possible to save a PDF file in the database and retrieve it from the App ?
sh4keNbake (6 years ago)
In order to be able to delete, would we need to use an ID? Or can we delete a row based on the date or something else?
sh4keNbake (6 years ago)
You are a fantastic teacher! Please, oh please do another video showing how to delete records.
profgustin (6 years ago)
Yep, hopefully I'll have time soon to add editing and deleting.
will kerswell (6 years ago)
Dont know if you are making one but a deleting record would be great ;)
chang simon (6 years ago)
nice~you are a teacher!!thanks a lot!
will kerswell (6 years ago)
Hey thanks for the great videos :) Im quite new to programming. Quick question. I see that we are reusing a few bits on code in the second viewController scaling this up would it be good practice to put the code we are going to use more than once in a sperate class and call that when it is needed? Like a Database function class. Thanks again!

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.