Free Trial   |  Purchase   |  Products   |  Downloads   |  Support     

Apollo 7.5 - VCL Components


Included with Apollo 7.5

Overview

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

Key Features

  • Create Win32 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
  • Royalty free unlimited distribution

Supported Embarcadero, Borland and CodeGear IDEs

  • RAD Studio XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007
  • Delphi XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 2005, 7, 6, 5
  • C++Builder XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 6, 5

Supported Languages

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

Supported Platforms

  • Win32

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.

Components

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 XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007
  • Delphi XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 2005, 7, 6, 5
  • C++Builder XE7, XE6, XE5, XE4, XE3, XE2, XE, 2010, 2009, 2007, 2006, 6, 5

Installing Apollo into Delphi

Installation

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:

1. Substitute:      C:\Program Files\Apollo7
     with:                C:\Program Files (x86)\Apollo7
2. Substitute:      C:\Windows\System32
     with:                C:\Windows\SysWOW64


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

Installing Apollo into newer XE versions of Delphi and C++Builder:

[Borland IDE] = one of the following:

  • DXE7=Delphi XE7, DXE6=Delphi XE6, DXE5=Delphi XE5, DXE4=Delphi XE4, DXE3=Delphi XE3, DXE2=Delphi XE2, DXE=Delphi XE
  • 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 XE7 = DXE7)
  2. File -> Open and browse to the corresponding Borland IDE sub-directory under
    C:\Program Files\Apollo7\VCL\[Borland IDE]
  3. Open the 2 package files: Apollo7DXE7.dpk and Apollo7DXE7d.dpk
    (Note: "d" = design-time package).
  4. Compile Apollo7DXE7.dpk
  5. Compile and Install Apollo7DXE7d.dpk
  6. The Embarcadero/CodeGear IDE will have added the Apollo components to the Toolbar Palette under the "Apollo" tab
  7. Add "C:\Program Files\Apollo7\VCL\DXE7" (or "C:\Program Files (x86)\Apollo7\VCL\DXE7") to the Library Path here:
    Tools -> Options -> Environment Options -> Delphi Options -> Library

Installing Apollo into legacy versions of Delphi and C++Builder:

[Borland IDE] = one of the following:

  • D2010=Delphi 2010, D2009=Delphi 2009, D2007=Delphi 2007, D2006=Delphi 2006, D2005=Delphi 2005, D7=Delphi 7, D6=Delphi 6, D5=Delphi 5
  • CB2010=C++Builder 2010, CB2009=C++Builder 2009, CB2007=C++Builder 2007, CB2006=C++Builder 2006, CB6=C++Builder 6, CB5=C++Builder 5
  1. Run the Borland IDE (e.g. Delphi 2010 = D2010)
  2. File -> Open and browse to the corresponding Borland IDE sub-directory under
    C:\Program Files\Apollo7\VCL\[Borland IDE]
  3. Open the 2 package files: Apollo7D2010.dpk and Apollo7D2010d.dpk
    (Note: "d" = design-time package).
  4. (Skip this step for Delphi 7, 6, 5 and for C++Builder 6,5)
    From the Project Manager, right-click on the Apollo7D2010.DPK package
  5. Compile Apollo7D2010.dpk
  6. (Skip this step for Delphi 7, 6, 5 and for C++Builder 6,5)
    From the Project Manager, right-click on the Apollo7D2010d.DPK package
  7. Compile and install Apollo7D2010d.dpk
  8. The Borland/Embarcadero/CodeGear IDE will have added the Apollo components in the Toolbar Palette under the "Apollo" tab
  9. Add "C:\Program Files\Apollo7\VCL\D2010" to the Library Path here:
    Tools -> Environment 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:\Program Files\Aopllo7\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;
var
   ApolloDatabase1: TApolloDatabase;
   ApolloQuery1: TApolloQuery;
   fname,lname: string;
   age: integer;
begin

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

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

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

end;

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-2014 Vista Software. All rights reserved.