I need a VB6 program to dynamically build an SQL statement based on table entry.
I have attached a screen shot for this to give you a better
understanding of what I'm trying to achieve. (the screen info are stored in a SQL Server 2000 table)
On the screen shot. The service type column represent the field that is used to lookup the values. The group column represent the field that is use to define "AND/OR" operators.
Values within the same group use the "OR" operator. When the group change we use the "AND" operator. Use brackets to keep the groups together "("
or ")"
Example:
type begin end group
REV 100 110 1
REV 130 180 1
REV 200 220 2
statement:
(REV between 100 and 110 or REV between 120 and 180) AND (REV between 200
and 220)
Note: what makes this difficult is that we are using "AND" operator on the same field "REV"
An additional bonus will be awarded... if this can be completed by 11:00PM EST.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
VB6, SQL Server 2000 Database