any idea ???
Try the following example, it might help you understand how it all fits together.
Once you have added a Popup LOV item to your page, create a Popup LOV using the following SQL query. Not the first column is the displayed text, while the second column it the underlying value:
select 'one' name, 1 val
select 'two', 2
select 'three', 3
you can either ensure that only values in the list can be used at anytime by setting the "Display Extra Values" to No.
To set the default value, change the Default type to be "PL/SQL Function Body". and add the following code to the PL/SQL Function Body block:
If you have set the "Display Extra Values" to No, in order for the default fault to display it must be a value that can be found in the result set of the query used for your LOV. In this example I use a simple block with a return statement returning the number 1 (You can used sql or pl/sql to determine what the value will be).
Hope that helps.
i had to enable 'display extra values'
no it is workign well when i set a default value