Re: forms 3.0 -- list of values

gpalma_at_dcc.uchile.cl (G. Cristian Palma A.) wrote:
>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 :) ...

Try adding a field in your master or control block on page 0 of the same data type as your global variable and make it non-basetable.

Select your global variable into this field.

     e.g. Select :global.example into :control.example from dual;

Then reference the field instead of the variable.

     Select a , b
       from c
      where d = :control.example ;

It's worth a try.

-- 

Michael Tharp

St. Paul, Minnesota USA
mtharp_at_minn.net