All, I'm having a problem that I thought I knew the answer to but now it
seems what I "knew" is not working. My environment is Windows 2000, Witango
5 and SQL.
I have a number of selections in a search. For example,
Selection Set 1
and Selection Set 2
and Selection Set 3
and Selection Set 4
and
Selection Set 5
or Selection Set 6
I thought that by right clicking inside of the search Criteria and
dragging a criteria separator where I needed it would allow me to accomplish
the above. It looks good when I drag it but when I close the search object
and reopen it the and on the line by itself goes away and all criteria are
set to ands.
I need the query built as above where all of the first 4 are true and
either of the last two are true. What Witango seems to be giving me is:
Selection Set 1
and Selection Set 2
and Selection Set 3
and Selection Set 4
and Selection Set 5
or Selection Set 6
which is not the same logic at all.
Am I missing something? Shouldn't I be able to do this without using a
direct DBMS action?
Thanks for your help!
Sincerely,
Gene Wolf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
