I seem to remember wrestling with something like this a while back...
What I came up with to make it work the way I wanted was this:
Selection Set 1
and Selection Set 2
and Selection Set 3
and Selection Set 4
and Selection Set 5
or
Selection Set 1
and Selection Set 2
and Selection Set 3
and Selection Set 4
and Selection Set 6
I'm sure there are better ways, and surely someone who has more experience
than I will post them.
Tom Ferguson
> -----Original Message-----
> From: Wolf, Gene [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 30, 2003 1:52 PM
> To: '[EMAIL PROTECTED]'
> Subject: Witango-Talk: Criteria Separator
>
>
> 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
>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
