Last week you created a table called possession in the application’s database file. Today you will learn how to do the following tasks: Add records in the database file Fetch all records from the database file Display the database records in the Master view’s Table View control The Item Class Now, before we get started […]

Once you’ve created a SQLite database file in the Documents folder of the application sandbox, the next logical step is to open the database file and create a table in it. As you already know, a database table is for storing the application’s data. A table’s schema (pronounce skee-ma) consist of columns and rows. Each column contains a different […]

In this lesson you will learn how to create, open and close a SQLite database file; but first, run the application and you will see output shown in the first image below. Click the + button and you will see output shown in the second image below. Clicking the Add view’s back button, will return […]

If you are a new visitor to our site, please read the Getting Started guide and the tableView Workshop series. The main goal of this tutorial series is to show how to use the SQLite engine in an iOS application to execute these fundamental SQL commands: CREATE TABLE – This command is for creating a table in a […]

Wouldn’t it be nice to display dots at the bottom of the Third scene (see image below) letting the user know how many pages of images there are. Further, the user should be able to scroll the view by swiping the current image or a dot. Well, to perform above mentioned tasks, you’ll have to launch […]