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>

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.com

  SQL*Forms Development
  Product Manager Received on Sun Sep 06 1992 - 23:47:55 CEST