Free Trial   |  Purchase   |  Products   |  Downloads   |  Support     

Apollo 9 - VCL Components

Included with Apollo 9


The Apollo Embedded VCL components are native data-aware Delphi components for building 32-bit and 64-bit Windows applications using Delphi and C++Builder.

Key Features

  • Create Win32 and Win64 applications using Delphi and C++Builder (Borland, Embarcadero, CodeGear)
  • Create, update and manage CA-Clipper and FoxPro DBF/Xbase database files from code
  • BDE not required
  • Over 30x smaller than the BDE (500KB vs 20MB)
  • Includes Delphi VCL source code to components
  • Compatible with VCL data aware components including TDataset and 3rd party components
  • Samples with full source code
  • Easily scalable from embedded to client/server configuration with little code changes
  • Apollo DBF Utility for visually managing DBF data files
  • Apollo Query Tool for running interactive SQL commands on DBF data
  • Royalty free unlimited distribution

Supported Embarcadero, Borland and CodeGear IDEs

  • RAD Studio 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE
  • Delphi 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE
  • C++Builder 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE

Supported Languages

  • Delphi/Object Pascal
  • C++Builder/C++

Supported Platforms

  • Win32
  • Win64

Borland BDE Replacement

The BDE is an awkward collection of database technologies that performs various unrelated functions including third party database connectivity and native database management of legacy dBASE and Paradox database files. This collection of unrelated functionality adds needless overhead to your applications and is the source of many configuration, deployment and BDE versioning issues -- all of which can be avoided by replacing the BDE with Apollo. Among other reasons to avoid developing applications that use the BDE is the fact that Borland has deprecated the BDE and has not issued updates to the BDE since 1999. In summary, there is no future in using the BDE.

TDataset Compatible

Apollo VCL components are fully compatible with Borland's TDataset architecture, which means Apollo is fully compatible with all data aware components including TDBGrid, TDBEdit etc. Apollo is also compatible with all popular third party products such as InfoPower, RAVE, DevExpress, and more.


TDataSet Components

  • TApolloDatabase
    Works like TDatabase. Connects to a DBF/Xbase database file and allows you to manage database level settings such as encryption.
  • TApolloTable
    Works much like TTable. Connects to DBF/Xbase tables allowing you to add, delete, update, filter and find data, along with other table related operations. TVDBTable works with TDatasource and is fully compatible with data aware components.
  • TApolloQuery
    Works much like TQuery. Runs SQL-92 queries and commands to manage database files. The Query object supports all the common SQL statements such as SELECT, INSERT, UPDATE, DELETE and more. TApolloQuery works with TDatasource and is fully compatible with data aware components.

Speedmode (Direct Data Access™)

  • TApolloTable.Speedmode
    property tells TApolloTable to bypass TDataSource (i.e. disable data-aware compatibility) and provide high speed direct data access. Speedmode provides on average a 50% to 100% faster performance boost which is ideal for non-visual data processing.

Using & Sample Code

Installing Apollo into Delphi/C++Builder

Applies to:

  • RAD Studio 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE
  • Delphi 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE
  • C++Builder 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE

Installing Apollo into Delphi


This explains how to install Apollo into the supported IDEs. Apollo provides native components that integrate directly into popular development IDE's such as Embarcadero/CodeGear/Borland Developer Studio and Visual Studio.

Windows 64-bit:
If you are running a 64-bit version of Windows:

Substitute:      C:\Apollo\9.0\x86
     with:                C:\Apollo\9.0\x64

Borland/Embarcadero/CodeGear Delphi/C++Builder (VCL Components)

Installing Apollo into Delphi and C++Builder:

[Borland IDE] = one of the following:

  • D10=Delphi 10, DXE8=Delphi XE8, DXE7=Delphi XE7, DXE6=Delphi XE6, DXE5=Delphi XE5, DXE4=Delphi XE4, DXE3=Delphi XE3, DXE2=Delphi XE2, DXE=Delphi XE
  • CB10=C++Builder 10, CBXE8=C++Builder XE8, CBXE7=C++Builder XE7, CBXE6=C++Builder XE6, CBXE5=C++Builder XE5, CBXE4=C++Builder XE4, CBXE3=C++Builder XE3, CBXE2=C++Builder XE2, XE=C++Builder XE
  1. Run the Borland IDE (e.g. Delphi 10 = D10)
  2. File -> Open and browse to the corresponding Borland IDE sub-directory under
    C:\Apollo\9.0\x86\VCL\[Borland IDE]
  3. Open the 2 package files: Apollo9D10.dpk and Apollo9D10d.dpk
    (Note: "d" = design-time package).
  4. Compile Apollo9D10.dpk
  5. Compile and Install Apollo9D10d.dpk
  6. The Embarcadero/CodeGear IDE will have added the Apollo components to the Toolbar Palette under the "Apollo" tab
  7. Add "C:\Apollo\9.0\x86\VCL\D10" (or "C:\Apollo\9.0\x64\VCL\D10") to the Library Path here:
    Tools -> Options -> Environment Options -> Delphi Options -> Library

Steps to building your first app

Creating your first VCL application

  1. Run Delphi (any of the IDEs listed above)
  2. Create a new VCL Windows Application
  3. Click the Apollo tab on the Toolbar
  4. Drop a ApolloTable component onto your form and press F11 (Object Inspector)
    • Directory = C:\Apollo\9.0\x86\Data
    • DatabaseName = Test.dbf
    • Active = True
  5. Drop a DataSource component onto your form and press F11
    • DataSet =ApolloTable1
  6. Drop a DBGrid component onto your form and press F11
    • DataSource =DataSource1
  7. Drop a DBNavigator component onto your form and press F11
    • DataSource =DataSource1
  8. Run.

Sample Code

Apollo's VCL components are fully Borland TDataSet compatible, which mean they are fully compatible with Borland's and third party data aware controls. The VCL provides high-speed access into a Apollo database. The Apollo VCL components include TApolloDatabase, TApolloTable and TApolloQuery.

Delphi sample using Apollo VCL components

procedure TryApollo;
   ApolloDatabase1: TApolloDatabase;
   ApolloQuery1: TApolloQuery;
   fname,lname: string;
   age: integer;

// Use the TApolloQuery object
// Create a connection object to a Apollo database
 ApolloDatabase1 := TApolloDatabase.Create('C:\MyData\MyDB.DBF');

// Create a query object and open the SQL
 ApolloQuery1 := TApolloQuery(ApolloDatabase1);
 ApolloQuery1.SQL := 'SELECT * FROM Person WHERE State = CA';

// Traverse all the records
 while not ApolloQuery1.EOF do
   fname = ApolloQuery1.FieldByName('FirstName').AsString;
   lname = ApolloQuery1.FieldByName('LastName').AsString;
   age = ApolloQuery1.FieldByName('Age').AsInteger;
   WriteToScreen( fname, lname, age);


Architecture Diagrams


Single User - Local Access


Single User - File Share or LAN Data Access


Multiple Users - File Share or LAN Data Access


Multiple Users - Client/Server Access


Multiple Users - Client/Server Access with Apollo Relay Server


  Products Technologies Support Company
© Copyright 1999-2016 ApolloDB. All rights reserved.