Re: Forms3 LOV
From: Steven P. Muench <smuench_at_oracle.com>
Date: Sun, 6 Sep 1992 21:47:55 GMT
Message-ID: <SMUENCH.92Sep6134755_at_hqsun4.oracle.com>
Product Manager Received on Sun Sep 06 1992 - 23:47:55 CEST
Date: Sun, 6 Sep 1992 21:47:55 GMT
Message-ID: <SMUENCH.92Sep6134755_at_hqsun4.oracle.com>
IAN -- While Forms4 will make this much easier by allowing the
designer to specify a static group of records at design time on which an LOV will be based at runtime, the simplest way to accomplish this in 3.0 involves only the LOV-Select-Statement. If you'd like the values 'YES','NO', and 'MAYBE' to be shown in the LOV for field CONTROL.RESPONSE, for example, then the LOV-SQL-Statement for CONTROL.RESPONSE could read: SELECT 'YES' INTO :CONTROL.RESPONSE FROM DUAL UNION SELECT 'NO' FROM DUAL UNION SELECT 'MAYBE' FROM DUAL Hope this helps. :-) _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ Steve Muench Email: smuench_at_oracle.comSQL*Forms Development
Product Manager Received on Sun Sep 06 1992 - 23:47:55 CEST