Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying LiveCode Mobile Development Cookbook
  • Table Of Contents Toc
LiveCode Mobile Development Cookbook

LiveCode Mobile Development Cookbook

By : Dr. Edward Lavieri Jr.
3.5 (11)
close
close
LiveCode Mobile Development Cookbook

LiveCode Mobile Development Cookbook

3.5 (11)
By: Dr. Edward Lavieri Jr.

Overview of this book

If you are a LiveCode mobile developer looking to improve your existing skills, add efficiencies to your code, or want a better understanding of LiveCode’s capabilities, then LiveCode Mobile Development Cookbook is a must-have for you. The reader should at least have a basic understanding of LiveCode and mobile application development.
Table of Contents (12 chapters)
close
close
11
Index

Using SQLite


Databases are advanced data repositories known as relational database management systems. SQLite is an embedded database that can be used in your LiveCode mobile apps, giving you tremendous capability to store, retrieve, and manipulate data. Unlike MySQL databases, SQLite databases do not require a server. In this recipe, we will create a mobile app that uses five SQLite functions:

  1. Connect to a database.

  2. Add a table to the database.

  3. Add data to the database table.

  4. Retrieve data from the database.

  5. Close the database.

How to do it...

Use the following steps to create a mobile app that instantiates a SQLite database and add and retrieve information from it:

  1. Create a new main stack in LiveCode.

  2. Set the background color of the main card to black.

  3. Open the Standalone Application Settings dialog box and click on the iOS tab.

  4. Check the SQLite checkbox by navigating to Basic Application Settings | Externals. See the following screenshot for reference:

  5. Open the Standalone Application Settings dialog...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
LiveCode Mobile Development Cookbook
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon