This content has been marked as final. Show 9 replies
Look at the Set_Item_Property() built-in.
VALIDATE_FROM_LIST is the property for validating, but I did not find any that attaches or detaches an LOV
Set_Item_Property( ..., LOV_NAME, 'your lov'); to set
Set_Item_Property( ..., LOV_NAME, ''); to unset
I do not think you can detach a lov at run time.
I am not sure what you want to do, but I think there might be a work around.Can you use key_listval trigger on your text item to conditionly display or not display the LOV? like
if ...TRUE... then
I do think, and I am completely sure that you can "detach" a LOV. Pass a null string ( '' ) to the Set_Item_Property(..., LOV_NAME) built-in.
Yes. you are right. I thought about set the lov_name to null but
I only looked the help says
"LOV_NAME Specify the VARCHAR2 name of an LOV to be associated with the given item. If the LOV name does not exist, you will get an error message. "
but did not do my own test.
I did the test, trust me ;-)
I trust what you said ;-) I did it too.
Put a KEY-LISTVAL on your item and put your dynamic logic there, that's simplest.
e.g. IF <condition> THEN