Re: forms 3.0 -- list of values

Hi,

You need to assign the value of :global.example to a non-base-table field in your form - eg :control.nbt_example - and then use that field in the WHERE clause of your LOV.

Cheers,

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 :) ...
Received on Sat Oct 07 1995 - 00:00:00 CET