Apollo 7 - VCL Components

Applies to Delphi 2010, 2009, 2007, 2006, 2005, 7, 6, 5 and C++Builder 2010, 2009, 2007, 2006, 6, 5

Installing Apollo into Delphi

1. Run the Borland IDE (e.g. Delphi 2010)
2. File | Open and browse to the corresponding Borland IDE sub-directory under
   C:\Program Files\Apollo7\VCL\[Borland IDE]
   where [Borland IDE] is 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
3. Open the 2 package files: Apollo7D2010.dpk and Apollo7D2010d.dpk
   (Note: The extra "d" in the name is the design-time package).
4. From the Project Manager, right-click on the Apollo7D2010.DPK package
   (Skip this step for Delphi 7, 6, 5 and for C++Builder 6,5)
5. Compile Apollo7D2010.dpk
6. From the Project Manager, right-click on the Apollo7D2010d.DPK package
   (Skip this step for Delphi 7, 6, 5 and for C++Builder 6,5)
7. Compile and install Apollo7D2010d.dpk
8. The Borland/Embarcadero/CodeGear IDE will now have installed the Apollo components in the Toolbar Palette under the "Apollo" tab
9. Tools -> Environment Options -> Library, add "C:\Program Files\Apollo7\VCL\D2010" to the Library Path

Creating your first VCL application

1. Run Delphi 2010 (or any of the Borland IDEs listed above)
2. Create a new VCL Windows Application
3. Click on 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.

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, TApolloQuery and TApolloDirect.

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;