Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

List of values with null value Oracle Forms 10g

kmocampoJul 9 2009 — edited Jul 9 2009
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2009
Added on Jul 9 2009
4 comments
5,597 views