Does anyone know of a method to overcome the 99 Limit on ANDs in SQL Select Statement as outlined in
I need to overcome it using visual basic code
THANKS
I need to overcome it using visual basic code
THANKS
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Limitation
- Thread starter Kennya1
- Start date
I would re-think the logic.
If you have that many criteria due to user selections, then limit the user to selecting so many individual items, and request them to sort/filter the data first, or use > < selections.
Another possibility would be to use THREE queries splitting the main query into two seperate ones and have a third query open on the first two, using a UNION query.
Or just try if a single UNION query will work.
But, if the amount of "AND"'s is because of the way you are coding the statement yourself, then just maybe it is being coded wrong, or the table has too many (option) fields (in which case for the latter you could seperate the table into two or more tables)
If you have that many criteria due to user selections, then limit the user to selecting so many individual items, and request them to sort/filter the data first, or use > < selections.
Another possibility would be to use THREE queries splitting the main query into two seperate ones and have a third query open on the first two, using a UNION query.
Or just try if a single UNION query will work.
But, if the amount of "AND"'s is because of the way you are coding the statement yourself, then just maybe it is being coded wrong, or the table has too many (option) fields (in which case for the latter you could seperate the table into two or more tables)
- Thread starter
- #3
Unfortunately the selection criteria is sound, is not user generated and cannot be reduced. It involves 64 fields with 8 possibilites for each field. Also unfortuatley the queries are exclusionary in nature (use the NOT modifier) so that the union command would not work (at least as far as I can tell)
Did you consider using MSDE rather than Access?
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Thread starter
- #5
Yes and No I have no experience with it and the following issues
1-I am not sure how to implement it
2-Some of the work stations are Win98
3-The program may be used on computers that I have no acess to so the VB setup must not only install the program but set up the MSDE server and configure it automatically
If I cans solve the last three I could deal with #1
1-I am not sure how to implement it
2-Some of the work stations are Win98
3-The program may be used on computers that I have no acess to so the VB setup must not only install the program but set up the MSDE server and configure it automatically
If I cans solve the last three I could deal with #1
- Status
Similar threads
