SmartSQL Version 1.01 -- Automates Generation of SQL Statements

Category:
Database
Type:
Classes
Difficulty:
Intermediate
Author:
Intelligent Solutions Inc.

Version Compatibility: Visual Basic 6

More information:
The SmartSQL class helps ease the process of generating and tracking complex SQL statements. Using this class, you can do things like create join statements more easily, use an array or collection as the fields list (or values list for INSERT and UPDATE queries), and change parts of the SQL statement by setting properties, as opposed to managing a long string. Complete documentation is included.

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.

Download smartsql.zip