CHAPTER 14:
Charting with Databases
Introducing the TDBChart component by integrating some basic charts into a Delphi ADO based application to quickly make graphs directly for the data in recordsets without requiring any code.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 15:
Lookup!
See how to use lookup fields in Delphi to achieve faster, better and safer data editing. Also, find how to create a new field for a dataset and discuss some of the key lookup properties. Plus, take a look at how to place a combo box inside a DBGrid.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 16:
Compacting an Access database with ADO and Delphi
While working in a database application you change data in a database, the database becomes fragmented and uses more disk space than is necessary. Periodically, you can compact your database to defragment the database file. This article shows how to use JRO from Delphi in order to compact an Access database from code.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 17:
Database reports with Delphi and ADO
How to use QuickReport set of components to create database reports with Delphi. See how to produce database output with text, images, charts and memos - quickly and easily.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 18:
Data Modules
How to use the TDataModule class - central location for collecting and encapsulating DataSet and DataSource objects, their properties, events and code.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 19:
Handling database errors
Introducing error handling techniques in Delphi ADO database application development. Find out about global exception handling and dataset specific error events. See how to write an error logging procedure.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 20:
From ADO Query to HTML
How to export your data to HTML using Delphi and ADO. This is the first step in publishing your database on the Internet - see how to create a static HTML page from an ADO query.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 21:
Using ADO in Delphi 3 and 4 (before AdoExpress / dbGO)
How to import Active Data Objects (ADO) type-libraries in Delphi 3 and 4 to create a wrapper around components that encapsulate the functionality of ADO objects, properties and methods.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 22:
Transactions in Delphi ADO database development
How many times have you wanted to insert, delete or update a lot of records collectively wanting that either all of them get executed or if there is an error then none is executed at all? This article will show you how to post or undo a series of changes made to the source data in a single call.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 23:
Deploying Delphi ADO database applications
It is time to make your Delphi ADO database application available for others to run. Once you have created a Delphi ADO based solution, the final step is to successfully deploy it to the user's computer.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 24:
Delphi ADO/DB programming: Real Problems - Real Solutions
In real world situations, really doing database programming is much more complex than writing about. This chapter points to some great Delphi Programming Forum threads initiated by this Course - discussions that solve problems on the field.
CHAPTER 25:
TOP ADO programming TIPS
Collection of frequently asked questions, answers, tips and tricks about ADO programming.
Discuss about questions, comments, problems and solutions related to this chapter!
CHAPTER 26:
Quiz: Delphi ADO Programming
What would it look like: Who Wants to be a Delphi ADO Database Programming Guru - the trivia game.
Discuss about questions, comments, problems and solutions related to this chapter!
