Michael Mullan
24-May-2010, 10:57 AM
IN VRW how does on replicate this DF constraint?
(pos(SCHED.STAFF_DISP, "OK|MF|MH") > 0))
I tried setting the filter in the selection, but the EQ selections seem to be "AND" not "OR".
SCHED.STAFF_DISP = "OK" AND
SCHED.STAFF_DISP = "MF" AND
SCHED.STAFF_DISP = "MH"
rather than
SCHED.STAFF_DISP = "OK" OR
SCHED.STAFF_DISP = "MF" OR
SCHED.STAFF_DISP = "MH"
(pos(SCHED.STAFF_DISP, "OK|MF|MH") > 0))
I tried setting the filter in the selection, but the EQ selections seem to be "AND" not "OR".
SCHED.STAFF_DISP = "OK" AND
SCHED.STAFF_DISP = "MF" AND
SCHED.STAFF_DISP = "MH"
rather than
SCHED.STAFF_DISP = "OK" OR
SCHED.STAFF_DISP = "MF" OR
SCHED.STAFF_DISP = "MH"