Re: Forms 4.5 LOV with NULLs

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/10/24
Message-ID: <19971024204701.QAA19279_at_ladder01.news.aol.com>#1/1

SELECT empname

    FROM emp
UNION
[Quoted] SELECT null

   FROM dual;

Or to take it one stage further

SELECT empname Employee Name

               , empname
    FROM emp
UNION
SELECT ' <Null>'

                    ,null

   FROM dual
order by 1

In LOV column spec leave return item blank for column Employee Name. Return the second
column to the item you are populating.

Your user now gets to pick <Null> (as is done in Oracle Forms Designer) but you use NULL.

John

---

John C. Lennon
Utility Partners Inc.
4300 West Tropicana Blvd LVO-UPL
Las Vegas NV 89103

FOR UTILITY PARTNERS EMPLOYMENT
OPPORTUNITIES VISIT www.utilpart.com

e-mail: jomarlen_at_aol.com
Web Site: http://members.aol.com/jomarlen/

The views expressed in this message
are those of the author and not
necessarily those of U.P. Inc.
and/or its employees.

---

>I have created an LOV from a query record group. I would like the user
>to be able to select a null value from the LOV. Is there any way to do
>this without having a null entry in the table from which the record
>group is created?
>
>
Received on Fri Oct 24 1997 - 00:00:00 CEST