Time for action – creating a foreign exchange list

To create a foreign exchange list perform the following steps:

1. Create a new blank mobile app by clicking on File | New | Titanium Mobile Project. Don't use a template as it will just generate code that gets in the way.

2. We are going to create a SQLite database file containing the foreign exchange pairings we are interested in. Pre-populating the file means that it is available when the app starts. Create a new directory in the new project called db under the resources directory to house the database file.

3. Navigate to the new db directory using the command line / terminal. Then run sqlite3. Notice the parameter to the command that sets the database file.

   Tip

   If you prefer to work with a nice GUI when editing your SQLite files, then you should use the SQLite browser. It's available for free and for both OSX and Windows at http://sqlitebrowser.sourceforge.net/.

   The following are the required commands:

   >sqlite3 currencies.sqlite
   SQLite version 3...