>I have run into a problem with Advanced Revelation 3.1. Example:
>: SELECT DBFILE WITH SOME_DATE AFTER "1/1/95" AND WITH STATUS "A"
>The problem is that the AND portion of the select statement is
>ignored. I have resorted to successive select statements for AND
>still have no solution for OR conditions. Please Help!!!
There should be no problem with your select statement. Is either of
the two fields multi-valued? Just to prove your theory about the
second condition being ignored, swap the conditions around. If you get
the same results, then your assumptions are wrong. If you get only
records that have a STATUS of "A" then you may be correct and have a
problem with your installation. Also, I would use a comparator symbol
instead of the implied "equal to" assumption.
As a matter of fact, I just executed the same statement with no
trouble. I'll bet your problem is in the use of a multi-valued field.
If you have some specifics, I'd be happy to help you out.