‎2008 Sep 30 7:21 AM
i have to take fields from RESB table..based on RSNUM..
XLOEK,SCHGT,DUMPS,KZEAR..if the record is 'X for all these'..i don want to display the rec...
if the value is 'X'..want to diplay this fields...XWAOK,POSTP..
if any of the field have "X" in both of these cond ...don want to dispaly...
if ERFMG AND ENMNG are equal ..i want to display...
pls send the coding for this.ASAP
‎2008 Sep 30 7:51 AM
Use this code ;
select single XLOEK SCHGT DUMPS KZEAR from RESB into ( RESB-XLOEK, RESB-SCHGT, RESB-DUMPS, RESB-KZEAR )where RSNUM eq RSNUM.
if RESB-XLOEK is not initial RESB-SCHGT is not initial and RESB-DUMPS is not initial and RESB-KZEAR is not initial.
display the value ( write the code to display the value )
elseif ERFMG eq ENMNG .
display the value ( write the code to display the value )
endif.
Regards,
Saran