Description
Assigns a relational boolean operation to join the existing and next condition clauses in this McDBQuery.
-
Return Type
-
None
-
Syntax
-
object.SetBoolOp bop
The SetBoolOp Method syntax has these parts: |
| object | An expression evaluating to an object of type McDBQuery. | | bop | Required. A mcDBBoolOp enumeration, as described in settings. The boolean relation between query elements already set in this McDBQuery and the subsequent element(s) set.
|
Settings The settings for bop are:
|
 | mcdbAND | 1 |
AND (True AND True = True, True AND False = False)
|
| mcdbOR | 2 |
OR (True OR True = True, True OR False = True, False OR False = False)
|
| mcdbXOR | 4 |
eXclusive OR (True XOR True = False, True XOR False = True)
|
| mcdbNOT | 16 |
NOT (unary operator: Not True = False, Not False = True)
|
| mcdbNAND | 17 |
NOT AND (True NAND True = False, True NAND False = True)
|
| mcdbNOR | 18 |
NOT OR (True NOR True = False, True NOR False = False, False NOR False = True)
|
| mcdbNXOR | 20 |
NOT eXcusive OR (True NXOR True = True, True NXOR False = False)
|
Remarks
McDBQuery objects can encapsulate a single query based upon multiple critera (e.g. Name and Type), and must therefore be capable of representing every combination of these dependent queries (e.g. Name=<NameVal> AND Type=<TypeVal>, or Name=<NameVal> OR Type=<TypeVal>), which yield different results.
Exceptions
Notes
If SetBoolOp() is not called between calls to other query Set methods, a boolean operation of mcdbAND is assumed.
|
SetBoolOp Method
