Re: Forms 4.5 LOV with NULLs

From: Jomarlen <jomarlen_at_aol.com>
Date: 1997/10/28
Message-ID: <19971028172301.MAA27996_at_ladder02.news.aol.com>#1/1


RUBBISH there is no problem at all in using a union in the SQL to populate a record group. I've done it many times in every release of Forms 4.5 from beta onwards.

Just for the record I've also just tried the following in Forms 4.5.7.1.6 and Forms 5 beta rel 3 (5.04.11.3) and it works just fine.

SELECT ename from emp
UNION SELECT null from DUAL

>Record Group does not allow to use UNION clause in SQL statement
>(I'm using D2000r1.2), but you can create a view ...
>
>> 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
>>
>
 

>Dmitry, moprok_at_ropnet.ru
>
>
>
>
>
>
>
Received on Tue Oct 28 1997 - 00:00:00 CET

Original text of this message