by C.J. (13 Submissions)
Category: Object Oriented Programming (OOP)
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (5 Votes)
The ocx will buid simple sql queries
Inputs
The inputs to the ocx can be found in the sample app
Assumes
There is a lot of room for enhancements on this control. Please comment if you have any suggestions on how to make the criteria selection more user friendly.
Code Returns
Sql query string
Side Effects
When adding the criteria for a query (WHERE) the full table names and field names must be supplied. This is only relevant if there is more than one table involved.
Download Query Builder (25 KB)