Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I keep the code as below, but the "where" condition doesn't working, who can help?
Thanks
Join(P_AUX)
Load
%ITM,
'Selecting' as SELT,
[UMCONV] as QTYS
resident ITEM WHERE left([Segm 3],2)<>'WF' OR [Segm 3]<>'STU' OR [Segm 3]<>'REJ' OR [Segm 3]<>'GOA' OR [Segm 3]<>'SVA';
do you have field [Segm 3] in the ITEM table?
Is it possible that the problem is really in the P_AUX table, where you want to join this table (maybe there is a problem with field names) ?
BR, Miha
All the records will pass the test because you use 'not equal' (<>) combined with OR.
Replacing the OR with AND will solve your problem.
Huub
you are true man, thanks.