Apollo Embedded VCL Components v7.5 XE7 â Delphi 10.3 Rio Full Source: A Powerful and Lightweight Solution for DBF Data Management
Apollo Embedded VCL Components are native data-aware Delphi components for building 32-bit and 64-bit Windows applications using Delphi and C++Builder. They allow you to create, update and manage CA-Clipper and FoxPro DBF/Xbase database files from code, without requiring the BDE or any other third-party database connectivity solution.
In this article, we will show you how to use Apollo Embedded VCL Components v7.5 XE7 with Delphi 10.3 Rio to create a simple DBF data management application. We will also provide you with the full source code of the project, so you can explore and modify it as you wish.
To use Apollo Embedded VCL Components v7.5 XE7 with Delphi 10.3 Rio, you need to download and install the following files from Apollo's website:
Apollo Embedded (64-bit) or Apollo Embedded (32-bit), depending on your target platform.
Apollo Server (64-bit) or Apollo Server (32-bit), if you want to access and manage DBF data files located on remote servers over TCP/IP.
After installing the files, you will find the Apollo VCL components in the Component Palette under the Apollo tab. You will also find some sample projects in the Samples folder of your Apollo installation directory.
Creating a DBF Data Management Application
To create a simple DBF data management application, follow these steps:
Create a new VCL Forms Application project in Delphi 10.3 Rio.
Save the project as ApolloDemo.dproj and the main form as MainForm.pas.
Add a TApdTable component to the form. This component represents a DBF table that can be opened, edited and queried using SQL commands.
In the Object Inspector, set the following properties of the TApdTable component:
DatabaseName: C:\\Data (or any other folder where you have some DBF files)
TableName: Customers.dbf (or any other DBF file name)
Active: True (to open the table)
Add a TDataSource component to the form. This component provides an interface between a dataset component (such as TApdTable) and data-aware controls on a form.
In the Object Inspector, set the following properties of the TDataSource component:
DataSet: ApdTable1 (to link it to the TApdTable component)
Add a TDBGrid component to the form. This component displays and edits data from a dataset in a tabular format.
In the Object Inspector, set the following properties of the TDBGrid component:
DataSource: DataSource1 (to link it to the TDataSource component)
Align: alClient (to fill the entire client area of the form)
Add a TDBNavigator component to the form. This component provides a graphical user interface for navigating and editing records in a dataset.