List of values with null value Oracle Forms 10g
Hi,
I need to show a list of values that includes a null row. I will use this null row for those cases when the user wants to clear a previous value selected, because the field should not allow the user to enter (or delete) a value with the keyboard. I was wondering if Oracle Forms 10g had some option to allow a null value in the lov automatically, instead of doing this:
select ' ' from dual
union
select * from region;
in the corresponding group of records... The above mentioned query also gives me the problem that i have to order it to show first the blank record, etc.
I also accept suggestions about the properties and/or behavior of those fields that should not accept values entered directly by the user but only list of values selections...
Thanks in advance.