SmartSQL Version 1.01 -- Automates Generation of SQL Statements
Version Compatibility: Visual Basic 6
Thank you to Brian Gillham for correcting a bug in version 1.0 and adding additional functionality to version 1.01.
This is the first of two classes that generate SQL statements based on parameters passed to it; the other is at http://www.freevbcode.com/ShowCode.Asp?ID=1375. This one supports Access and SQL Server and has some features the other one does not. On the other hand, the other version supports Access and Oracle, 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.