Related Resources • free DB Course.TOC • more Database articles

Hello, and welcome to the 24th chapter of the free Delphi ADO database course. Only two more chapters and the course is over. The intention of the course was to bring database development with ADO more closer to Delphi developers. I hope that we managed to learn some valuable techniques in the last 23 chapters of this course.

The Course focused on the most common uses of ADO in a Delphi application: connecting to a database using TADOConnection, work with Tables and Queries, handle database exception, create reports, etc. We've managed to cover most of the situations that arise in real world database application situations. Of course, some topics were not discussed, covering everything you can do with Delphi and ADO could hardly be placed in a single book. As stated in the first chapters, this free online course is targeted towards Delphi database beginners as well as for those who want a broad overview of the art of database programming with Delphi.

My intention, it this chapter, is to point you to some great Delphi Programming Forum threads initiated by the topics we covered through the Course. In most cases, Forum discussions are real solutions to your real problems!

   Real Problem 1
Delphi, MS Access... "Should we use Delphi / ADO combination when doing database applications? Are there a big differences in the Delphi program which we are going to create by using different databases? Maybe not everybody do have Access. On the other hand Lotus Approach and Interbase 6 are free meanwhile."
Real Solution 1

   Real Problem 2
ADOExpress / dbGo, BDE, ODBC... "I only can use the ADO when I have Delphi 5 Enterprise Edition / Delphi 6 Professional! Is it possible to use Delphi 4/3 as a front end to a local Access database?"
Real Solution 2 A
Real Solution 2 B

   Real Problem 3
Using TADOConnection, TADOQuery, TADOTable and similiar... "I'm using Delphi 5 with ADO connected to MS-SQL server 7. I designed and coded a program using TADOQuery and DBGrid to view all of the records from 7x,xxx records view with joining from 2 tables but the response is very slow (about 2 minutes return). Do you have any others method to improve the speed?"
Real Solution 3 A

"Wouldn't it be nice, to have opportunity to manipulate "Connection String" after the application is compiled? For example if MDB is in a different path or you want to switch to another version of it. That's a question mostly of the application support..."
Real Solution 3 B

"If I write the SQL statement without parameters it runs perfectly, but if I have the same SQL statement substituting some numeric values by parameters and then fill in the parameters with the same values they were before, the TADOQuery returns no data. I need parameters because these values change according to user choices so I can't have them fix on the SQL property. "
Real Solution 3 C

"I have a multiuser application wherein I need to display data in the DBGrid from SQL Server. The problem is that the table being used has lot of data and so I don't want to display all the data at the same time in the DBGrid. Instead based on user navigating through the navigation button I want to fill the DBGrid with maybe some fixed number of records every time. User can navigate back or forward..."
Real Solution 3 D

   Real Problem 4
Seeking, Locating and Searching for data ... "I am working with a Access 97 database using Windows 2000 and Delphi 5. I have a problem with the ADO datasets Seek method. I am unable to use the Seek method, I get an error about my database does not support the operation?"
Real Solution 4 A

"Is there any way I can apply a filter to a detail table? I get an error when I try to do that, but it's really important to me right now. Is there any way to "fool Delphi" and do it anyway? "
Real Solution 4 B

   Real Problem 5
Using data modules... "I have set up a data module using an ADOConnection, ADOTable and a Datasource. On my TabSheet, I have dropped a dbGrid component and connected it up to my datasource, set everything to live and the data displays. However, as soon as I run the project the data does NOT display..."
Real Solution 5

   Real Problem 6
Creating a database from code... "How to create an MS Access database without the MS Access. How to add an index to an existing table, how to join two tables and set up referential integrity?"
Real Solution 6

   Real Problem 7
Deploying Delphi ADO solutions "Here are some problems when I build my 1-st db-application: AutoNumber as a key filed and the 'The key value for this row has been changed or deleted at the data source. The local row is now deleted.'..."
Real Solution 7

   Real Problem 8
Delphi, ADO, Access and the rest of the MS Office family "I have a problem, I receive multiple price lists from a bunch of companies each week in Microsoft Excel spreadsheets. I need to put these prices into a database. I need to read the data as I see fit, cell by cell, row by row..."
Real Solution 8

   Real Problem 9
Database reports with Delphi and ADO "I have two forms .... the first one I used ADOQuery to search the Table and put the result in the DBGrid .... the second form is to print the result in the DBGrid to the QReport .... the question is how could I get the data from the DBGrid to the QReport ??? "
Real Solution 9

   Real Problem 10
I'm a newbie! "Where can I find about/learn database programming with ADO and Delphi for free?"
Real Solution 10

   To the next chapter
If you need any kind of help at this point, please post to the Delphi Programming Forum where all the questions are answered and beginners are treated as experts.

DB Course Next Chapter >>
>> TOP ADO programming TIPS - DB/25