Object Oriented Filtering (OOF) - Dragan S. Pusonjic
Previous Table of Contents Next

The illustration presents two objects. ‘.AND.’ operator has been introduced in cxWhereCond, however, it has not been potrayed in the illustration. Well, where exactly is ‘.AND.’ operator? Simply, there is not any; it is not presented in the illustration. This explanation deserves considerable attention. Default operator of the filtering object is ‘.AND.’ operator. Mathematicians would proclaim me a jeretics (there is no difference between AND I OR operator; they are of the same level). But ‘.AND.’ operator has much more frequently utilized in from table data fitering. ‘.AND.’ operator will only be implied in order to avoid higher illustration complexity. It is to be noticed that the operator itself is associated with the following filtering object,  which is to be obvious in the following illustration:

                           

 AND/OR operator                                   
Operator OR is reality and it must be present in our filtering objects. How could it be introduced into our existing object illustration without changing the dimension of our object. In the situation of having more filtering objects in one form, the object dimensions come to be very important.
 We would like to solve the following problem:

SELECT * ;
                        FROM order ;
                        WHERE ;
                                    value_invoice >= 2000 .OR. ;
                                    BETWEEN(order_date ,23/05/1995 , 28/06/1995)

We shall present it with our object:

                           

We introduced OR operator, but we enlarged the object image. However, we will not change the original dimensions of the object image.
Main switches will be moved to the word positon “Low”  and  “High” so that some room is made for OR operator or any of its images.

                           

How can we change this condition? The object term “Date order” is free temporarily. We shall use the opportunity to have the right mouse click free. In given circumstances, the following should be observed.
            1)       “OR” operator  can be altered provided that one of the main swithes (or both) is active;

2)       In case of repeated activity (right mouse click), the negation of the previous operator will be performed and the image will return to the previous condition.


Previous Table of Contents Next