HI all
I have an item P105_VAL_DRVR display as : Popup key lov (display description, returns key value).
what i have until now in the list of values (in the item )is this :
select id_num || ' ' || id_num as a ,id_seq from employee_s where pntr = :P99_PNTR and id_seq!=1
works great!
now i want to add something like this :
if :P99_IND = 0 THEN
select id_num || ' ' || id_num as a ,id_seq from employee_s where pntr = :P99_PNTR and id_seq!=1
else
select id_num || ' ' || id_num as a ,id_seq from employee_d where pntr = :P99_PNTR and id_seq!=1
end if;
when i did apply changes , it didn't give me any error, but when i'm running the page, it gives me an error.
is it possible to do it ?
thanks in advance
Edited by: naama on Nov 8, 2009 11:09 PM