Free Delphi Database Programming Course
Free online database programming course for beginner Delphi developers. Focus on ADO techniques. This online course is perfect for Delphi database beginners as well as for those who want a broad overview of the art of database programming with Delphi.
ADO: Delphi Reference Library
ADOExpress Step-by-Step-from-Scratch Tech Notes, ADO Resources, ADO Tips. Features: UDL files -- Microsoft Data Link Files; DBF Files -- With and Without ADO; Delphi 5, ADOExpress, Access and Images; SQL Query Using ADODataSet; ADO Master/Detail and File Locking; Running ADO Applications in Windows 95; Briefcase: UDL and ADTG; ...
Data access dilemma
With Delphi 5 programmers are faced with the choice of using the BDE or ADO for database access. Typically, the answer to the question "Which database technology should I use?" is "It depends."
Accessing Databases Using ADO and Delphi
This paper will show how to access and update ADO data using either Variants or interfaces. Find out how to install and access an ADO Database, and how to use Delphi to access ADO data sources. The subject matter of this paper is very easy to understand, and the code shown, should work with any version of Delphi 3 or 4. This article does not cover the ADO components found in Delphi 5 (and +). Instead, it was written against Delphi 4, and is meant to show how to access ADO if you do not have the Delphi ADO components. The code should work fine in Delphi 5, however it shows how to work with ADO using a relatively low level API.
Implementing OLAP in Delphi Applications
"In this article, we will talk about using ADO for On-Line Analytical Processing (OLAP) – the data management techniques that are widely used in decision support systems and data warehousing. We will also discuss two ways of implementing OLAP with ADO and Delphi, such as using client-side OLAP and server-side one."
You find the dbGO component from Borland are missing something, try with the following third-party ADO VCL components:
TBetterADODataset
TBetterADODataSet is a direct descendent of Borland's TADODataSet which means that if and when Borland releases a new patch and/or version of their ADOExpress and/or DbGo library it won't break any existing code written to use this descendant. Farther more, it will transparently inherit any bug-fixes and new features that Borland may have released. Many of the features implemented by TBetterADODataSet were provided, proposed or otherwise contributed by members of the borland.delphi.ado newsgroup. Free.
