SQL Composer: Automates Generation of SQL
Version Compatibility: Visual Basic 6
This is the second of two classes that generate SQL statements based on parameters passed to it; the other is at http://www.freevbcode.com/ShowCode.Asp?ID=75. This one supports Access and Oracle SQL and has some features the other one does not. On the other hand, the other version supports Access and SQL Server, and includes some features that this one doesn't have. Therefore, you should evaluate both and decide which one works best you.
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.