Without a doubt, Delphi developers have the richest choice of options for accessing ADS. In addition to being able to use ACE (Advantage Client Engine), Delphi developers can use the Advantage ODBC Driver, the Advantage OLE DB Provider, and the Advantage .NET Data Provider. But there is one data access mechanism that beats them all—the Advantage TDataSet Descendant. Using the TDataSet descendant classes, Delphi developers, as well as Kylix and C++Builder developers, can utilize almost every feature available in ADS. Only ACE provides access to more capabilities, but at the expense of being significantly more complicated to use.
If you are using C++Builder or Kylix, install the Advantage TDataSet Descendant for either C++Builder or Kylix, respectively. The TDataSet descendant classes are identical to those described in this chapter. The Kylix code is identical to the Delphi code with few exceptions, all due to working in Linux. For C++Builder code, the methods and properties are the same, but the syntax of C++ is different.
This chapter provides you with examples of using the Advantage TDataSet Descendant classes to perform a wide range of common data-related tasks using Delphi. As is the case with the other chapters in Part III, this discussion assumes that you are already familiar with the development environment being described. Instead, the focus is on code that works with the data dictionary you have been using throughout this book.
If you are using Borland’s Delphi for .NET solution, you will want to use the Advantage .NET Data Provider. See Chapter 15 for information on the Advantage .NET Data Provider.