Book Image

Expert Delphi

By : Paweł Głowacki
Book Image

Expert Delphi

By: Paweł Głowacki

Overview of this book

Delphi is the most powerful Object Pascal IDE and component library for cross-platform native app development. It enables building natively compiled, blazingly fast apps for all major platforms including Android, iOS, Windows, Mac, and Linux. If you want to build server-side applications, create web services, and have clear GUIs for your project, then this book is for you. The book begins with a basic primer on Delphi helping you get accustomed to the IDE and the Object Pascal language and will then quickly move on to advanced-level concepts. Through this book, we’ll help you understand the architecture of applications and will teach you the important concepts of the FireMonkey library, show you how to build server-side services, and enable you to interact with the Internet of Things. Towards the end, you will learn to integrate your app with various web services and deploy them. By the end of the book, you will be able to build powerful, cross-platform, native apps for iOS and Android with a single code base.
Table of Contents (14 chapters)

Accessing databases with FireDAC

To keep the demo app simple, we are going to use SQLite as the database engine and our To-Do List app will have just one database table, called ToDos. SQLite has a simple type system and effectively, a column can store null, integer, real, text, or blob values.

In our design, we are going to use as a primary key an integer Id value. We will also need Title and Category text fields. The key FireDAC component that we will need is the FireDAC database connection. There will also be query components connected to the database connection. Drop the TFDConnection component onto the data module. Change its Name property to fdconnToDos. Now double-click on the connection component to display the FireDAC database connection editor window. Select SQLite in the Driver ID combo-box. This should display the list of different parameters specific to working with...