Applies to:

• RAD Studio 11 Alexandria, 10.3 Rio, 10.2 Tokyo, 10.1 Berlin, 10 Seattle,
  XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE,
  2010, 2009, 2007, 2006, 2005
• Delphi 11 Alexandria, 10.3 Rio, 10.2 Tokyo, 10.1 Berlin, 10 Seattle,
  XE8, XE7, XE6, XE5, XE4, XE3, XE2, XE,
  2010, 2009, 2007, 2006, 2005, 7, 6, 5
• C++Builder 11 Alexandria, 10.3 Rio, 10.2 Tokyo, 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

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 want to use the 64-bit version of Apollo:

Substitute:      C:\Apollo\[majorversion.minorversion]\x86
     with:            C:\Apollo\[majorversion.minorversion]\x64

• RAD Studio, Delphi/C++Builder (VCL Components)
• Visual Studio (ADO.NET Data Provider)
• Deploying Apollo to a Web Server (IIS)

---

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

Installing Apollo into Delphi and C++Builder:

[Borland IDE] = one of the following:

• D11-Delphi 11, 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
• CB11-Delphi 11, 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 11 = D11)
2. File -> Open and browse to the corresponding Borland IDE sub-directory under
   C:\Apollo\[majorversion.minorversion]\x86\VCL\[Borland IDE]
3. Open the 2 package files: Apollo9D11.dpk and Apollo9D11d.dpk
   (Note: "d" = design-time package).
4. Compile Apollo9D10.dpk
5. Compile Apollo9D10d.dpk
6. Install Apollo9D10d.dpk (right click, Install)
7. The Embarcadero/CodeGear IDE will have added the Apollo components to the Toolbar Palette under the "Apollo" tab
8. Need to add Apollo to the Library Path here:
9. Delphi 11.x: Tools -> Language -> Delphi -> Library -> edit Library Path ...
10. Delphi 10.x: Tools -> Options -> Environment Options -> Delphi Options -> Library -> edit Library Path ...
11. Add "C:\Apollo\[majorversion.minorversion]\x86\VCL\D11" (or "C:\Apollo\[majorversion.minorversion]\x64\VCL\D10") to your Library Path

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 ApolloDatabase component onto your form and press F11
   • DataPath = C:\Apollo\[majorversion.minorversion]\x86\Data
   • DataPathAlias = apollotest
5. Drop a ApolloTable component onto your form and press F11 (Object Inspector)
   • DatabaseName = apollotest
   • TableName = TEST.DBF
   • Active = True
6. Drop the standard DataSource component onto your form and press F11
   • DataSet = ApolloTable1
7. Drop the standard DBGrid component onto your form and press F11
   • DataSource = DataSource1
8. Drop a DBNavigator component onto your form and press F11
   • DataSource = DataSource1
9. Run.

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;