B
Bharat
Guest
I want to check and filter only if the table has value1 = 005 and value1 = 009. But it seems below query is helping me. I dont know where I am making mistakes. Kindly help to solve this.
Continue reading...
Code:
DEFINE TEMP-TABLE test NO-UNDO
FIELD value1 AS CHARACTER
.
EMPTY TEMP-TABLE test.
CREATE test.
ASSIGN
value1 = "005".
CREATE test.
ASSIGN
value1 = "009".
CREATE test.
ASSIGN
value1 = "001".
FOR EACH test NO-LOCK
WHERE value1 <> ""
AND (value1 = "005" AND value1 = "009")
:
MESSAGE YES.
END.
Continue reading...