Hello folks,
I'm trying to check multiple fields against a group of values. Instead of saying
IF (FIELD1 EQ 'BLAH1' OR 'BLAH2' OR 'BLAH3') OR
(FIELD2 EQ 'BLAH1' OR 'BLAH2' OR 'BLAH3') OR
(FIELD3...
I'd like to say
IF (FIELD1 EQ 'ck list of values in the variable') OR
(FIELD2 EQ 'ck list of values in the variable') OR
(FIELD3 EQ 'ck list of values in the variable'...
In my attempt to do this, I have something like
-SET &GRP = 'BLAH1,BLAH2,BLAH3';
and in the DEFINE
IF (FIELD1 EQ '&GRP.EVAL' OR
FIELD2 EQ '&GRP.EVAL' OR
FIELD3 EQ '&GRP.EVAL')...
There's obviously something I don't quite understand about what I supposed to do with this. I'm getting an error msg:
(FOC016) THE TRUNCATED FIELDNAME IS NOT UNIQUE: O
However, there is no 'O' value in my list at all.
Am at all on the right track or do I need to do something entirely different? Can somebody please clue me?
Thanks--Mary E.
I'm trying to check multiple fields against a group of values. Instead of saying
IF (FIELD1 EQ 'BLAH1' OR 'BLAH2' OR 'BLAH3') OR
(FIELD2 EQ 'BLAH1' OR 'BLAH2' OR 'BLAH3') OR
(FIELD3...
I'd like to say
IF (FIELD1 EQ 'ck list of values in the variable') OR
(FIELD2 EQ 'ck list of values in the variable') OR
(FIELD3 EQ 'ck list of values in the variable'...
In my attempt to do this, I have something like
-SET &GRP = 'BLAH1,BLAH2,BLAH3';
and in the DEFINE
IF (FIELD1 EQ '&GRP.EVAL' OR
FIELD2 EQ '&GRP.EVAL' OR
FIELD3 EQ '&GRP.EVAL')...
There's obviously something I don't quite understand about what I supposed to do with this. I'm getting an error msg:
(FOC016) THE TRUNCATED FIELDNAME IS NOT UNIQUE: O
However, there is no 'O' value in my list at all.
Am at all on the right track or do I need to do something entirely different? Can somebody please clue me?
Thanks--Mary E.