Home -> Usenet -> comp.databases.oracle -> forms 3.0 -- list of values

forms 3.0 -- list of values

From: G. Cristian Palma A. <gpalma_at_dcc.uchile.cl>
Date: 1995/10/06
Message-ID: <4543uk$15i_at_antilen.dcc.uchile.cl>#1/1 






Hi ...



I have the next problem: I set one variable in the PRE-FORM trigger



          default_value('1','global.example')



and then I want to use this variable in a list of values associated to
a field of a block


          select a, b
          from   c
          where  d = :global.example





But forms say me



          FRM-30014: No such block GLOBAL; form not created.



:(



Question: is there a form to say it forms that GLOBAL isn't a block, is a
variable ? I tried with


          select a, b
          from   c
          where  d = 'global.example'





or


          select a, b
          from   c
          where  d = "global.example"





etc., but it didn't function



Thanks in advance ...


--

Pd: my english isn't very good :) ...


Received on Fri Oct 06 1995 - 00:00:00 CET












Original text of this message