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