Re: LOV (Forms 6.0)

From: Erika Grondzakova <Erika.Grondzakova_at_cern.ch>
Date: Tue, 14 Mar 2000 10:20:23 +0100
Message-ID: <38CE0457.4B7C20F3_at_cern.ch>


Hello,

> How can I specify mask (e.g. '%' for all values) for _NUMBERS_ in LOV
> object to open it (property 'Automatic Display' inconveniently when only
> navigating between records)? Or how can user open the LOV when it is
> necessary?

To open a LOV by user, I use a trigger WHEN-MOUSE-DOUBLECLICK

DECLARE
chosen_value BOOLEAN;
BEGIN
  chosen_value := SHOW_LOV('LOV2',350,150); END;
> For example I need to see in LOV the following:
> 1 Piter
> 2 John
> ...
> and insert in field only ID.
> Any idea?

When you see properties of the LOV, there is a property Column Mapping Properties. Here you define that only your ID will be mapped to some field.

Hth,

Erika

>
> Best regards,
> Andrey Demchenko.
> andrey_at_papir.kiev.ua
Received on Tue Mar 14 2000 - 10:20:23 CET

Original text of this message