Reg Select-options

Hi all,

I have 3 fields one is new barcode and the other is oldbarcode.now my requirement is If new or old barcode are entered validate against an DB table.and check the third field temp barcode is initial.

these 3 are declared as select-options.though i have taken a local variable and trying to validate as follows its not taking the correct values.What should i do?

My code

if not s_nbarcd or s_obarcd is initial .

clear loc_barcd.

select single zcylbarcd from zmgctcylloc into loc_barcd where zcylbarcd in s_nbarcd or zcylbarcd in s_obarcd.

Regards