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.
- 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, 2010, 2009, 2007, 2006
- Delphi 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 2005, 7, 6, 5
- C++Builder 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 2005, 7, 6, 5
- Delphi/Object Pascal
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.
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.
Works like TDatabase.
Connects to a DBF/Xbase database file and allows you to manage database level
settings such as encryption.
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.
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
Speedmode (Direct Data Access)
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
- RAD Studio 10.1 Berlin, 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006
- Delphi 10.1 Berlin, 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 2005, 7, 6, 5
- C++Builder 10.1 Berlin, 10 Seattle, XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 2005, 7, 6, 5
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.
If you want to use the 64-bit version of Apollo:
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
- Run the Borland IDE (e.g. Delphi 10 = D10)
- File -> Open and browse to the corresponding Borland IDE sub-directory under
- Open the 2 package files: Apollo9D10.dpk and Apollo9D10d.dpk
(Note: "d" = design-time package).
- Compile Apollo9D10.dpk
- Compile and Install Apollo9D10d.dpk
- The Embarcadero/CodeGear IDE will have added the Apollo components to the Toolbar Palette under the "Apollo" tab
- 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
Creating your first VCL application
- Run Delphi (any of the IDEs listed above)
- Create a new VCL Windows Application
- Click the Apollo tab on the Toolbar
- Drop a ApolloTable component onto your form and press F11
- Directory = C:\Apollo\9.0\x86\Data
- DatabaseName = Test.dbf
- Active = True
- Drop a DataSource component onto your form and press F11
- Drop a DBGrid component onto your form and press F11
- Drop a DBNavigator component onto your form and press F11
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
ApolloQuery1.SQL := 'SELECT * FROM
Person WHERE State = CA';
Single User - Local Access
Single User - File Share or LAN Data
Multiple Users - File Share or LAN Data
Multiple Users - Client/Server Access
Multiple Users - Client/Server Access with Apollo