hi all,
i am using Forms [32 Bit] Version 6.0.8.24.1 (Production).
let me explain my problem with an example.
let us consider one text item which is database mandatory field (in which an LOV is attached to it)
so to call lov i have written 'list_values' in k-listval trigger.
so that whenever user press key corresponding to LOV(let us say f9) the corresponding lov will be displayed.
i have a requirement that i should show one button so that when user presses that button the LOV has to be displayed and the values have to be assigned when user selects the value from the list.
in w-b-p trigger i have written
go_item('item_name');
do_key('List_Values');
In essence i should provide an option that user can bring the LOV by pressing f9 or by pressing the above said button.
my problem is i am getting oracle error when user doesn't enter this field.(which i am trying to solve).
If i set the 'required' property of above said item to 'yes' then that error we can avoid but it will not allow to select the list through the button.
note:i have set the property validate from list to 'yes'
Thanks..