Presentation for Pacific Northwest Delphi Users Group 04/05/2001
I gave a presentation on SQL Tester, a standalone program for testing SQL
statements with the capability of including them in a database for later
correction, usage, etc. This tool would work with BDE- or ADO- databases,
and to have a reasonably sized database to make things interesting, I chose
a couple of Microsoft Access Databases I had created on Books and CDs. As
I worked with these using ODBC and ADO it became obvious that there was more involved than
simply setting up a BDE-database. Since this was preparation for using the
databases with SQL Tester, I covered this, SQL Tester, and basic Structured
Query Language (SQL).
The following is a zip file containing the powerpoint presentation (approx.
10 Kbytes Zipped Presentation)
While not shown as part of the presentation there is also a zipped
presentation of images demonstrating the steps to generate an connection via
BDE and ODBC and the databases use in a DBGrid in an application. This file
is approx 702 Kbytes. ODBC images
Another image file illustrates use of a data module and connection to via ADO
to the database. This file is approx 1 Mbyte. ADO images