Re: F45 question
Date: 1996/02/04
Message-ID: <4f3dlv$o07_at_gossamer.itmel.bhp.com.au>#1/1
In article <3111139B.7F08_at_motown.ge.com>, "Ted M. Troccola" <ttroccol_at_motown.ge.com> says:
>
>Using F45 on Solaris.
>
>What trigger should be used to accomplish the following.
>(I don't need PL/SQL code, just which trigger to use)
>
> I have a text item that I populate from an LOV.
>
> I do have the text item 'LOV for validation' propery = TRUE;
>
> I want to check the value that was entered in the text item
> and depending on the value, navigate to one of N items.
>
>Thanks,
>Ted
>
>please respond via email to ttroccola_at_motown.ge.com
>--
If I understand your problem correctly, you dont want a trigger at all.
The LOV has a property called (from memory) Column Values.
Here you can specify, for each column in the record group, the item
into which the selected record's value will go.
With LOV for validation = TRUE, this means that all values which have
an associated return value will bring back the value once
you hit enter in the item which has the LOV (or display the lov if the
value typed is invalid).
We use this as a standard.
eg. product_code and product_description are displayed on the canvas
Product_code is a base item, and product_description is a non-base
item, in the same base block as product_code, ORDERS. product_code
and product_description may be looked up in a non-base table called
PRODUCTS.
we create a record_group, with something like:
select product_code, product_description from products order by product_code
and create an LOV from this.
The LOV's Column Values property has values: orders.product_code and
orders.product_description, respectively.
product_code has LOV For Validation set to True.
This means that:
when we enter a product code correctly, the product description will automatically appear.
If we enter an incorrect code the LOV window will appear.
HIH
Lee
------/\/\------+---------------------------------------------------
/ / /\ | Lee Levy, ISSD Systems Development, Del Code (34)
/ / / \ | BHP Information Technology, ACN 006 476 213
/ / / /\ \ | PO Box 261, Warrawong, NSW 2502, Australia
\ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
\ / / / | Internet : levy.lee.ls_at_bhp.com.au
-----\/\/\/-----+---------------------------------------------------Opinions expressed are mostly my own, so give me some credit. Received on Sun Feb 04 1996 - 00:00:00 CET