Re: Forms 4.5 LOV with NULLs

Jomarlen <jomarlen_at_aol.com> ÚÁÐÉÓÁÎÏ × ÓÔÁÔØÀ <19971024204701.QAA19279_at_ladder01.news.aol.com>...
> SELECT empname
> FROM emp
> UNION
> 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
>

[Quoted] Record Group does not allow to use UNION clause in SQL statement (I'm using D2000r1.2), but you can create a view ...

[Quoted] Dmitry, moprok_at_ropnet.ru Received on Tue Oct 28 1997 - 00:00:00 CET