How Does This Work?

[Kenneth Brody]

Quoting John Hemmer (Wed, 25 May 2005 12:57:05 -0400):
[...]
> > >    If:  MY le MO  and  pcbh  and  YR eq mid(MO,"4","2")
> > >  Then: select
> > [...]
> > > pcbh  is not defined anywhere in the selection process.
> > [...]
> > > How does the first selection line work?
> >
> > You have a selection set called "pcbh".
[...]
> (1) So is the name of the selection set assigned a value of true
>       within the processing table?

The selection set is evaluated at the time you "execute" it in the
processing.

> (2) Even if that were so, it does not explain why omitting "pcbh"
>       from the test makes false when the other conditions are true.
>
>       Note: the NO in the second test is a Typo in the email, but not
>       in the processing.

If "A and B and C" is true, then "A and C" must also be true.  I have
to assume that something else is going on and causing the change in
behavior that you are seeing.

Are you absolutely certain that you are comparing the statements with
the same data?

What happens if you try a test:

test1    If:  MY le MO  and  pcbh  and  YR eq mid(MO,"4","2")
test2    If:  MY le MO  and  YR eq mid(MO,"4","2")
         If:  test1 and not test2
       then:  errorbox "Test1 is true, and test2 is false!\nMY = '"
                & MY & "' MO = '" & MO & "' YR = '" & YR & "' MO =
                '" & MO & "'"

Does the errorbox ever appear?

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com