dsaad
Member
When specifying data selection criteria for a batch version, is there a way to structure the criteria so that you get:
where (((fieldA = value1 or fieldB = value2) and
(fieldC > value3 and fieldD < value4)) or
((fieldA = value5 or fieldB = value6) and
(fieldC > value7 and fieldD < value8)))
simply using
where fieldA = value1 or
fieldB = value2 and
fieldC > value3 and
fieldD < value4 or
fieldA = value5 or
fieldB = value6 and
fieldC > value7 and
fieldD < value8
for the data selection won't give me the correct results.
Is there a way to specify data selection in a way that effects the order per the parentheses outlined above?
XE RELEASE B7333 SP14.2
where (((fieldA = value1 or fieldB = value2) and
(fieldC > value3 and fieldD < value4)) or
((fieldA = value5 or fieldB = value6) and
(fieldC > value7 and fieldD < value8)))
simply using
where fieldA = value1 or
fieldB = value2 and
fieldC > value3 and
fieldD < value4 or
fieldA = value5 or
fieldB = value6 and
fieldC > value7 and
fieldD < value8
for the data selection won't give me the correct results.
Is there a way to specify data selection in a way that effects the order per the parentheses outlined above?
XE RELEASE B7333 SP14.2