Re: Need Help with LOV!!!
Date: 1997/09/11
Message-ID: <5v7us7$hoo_at_info.csufresno.edu>#1/1
In article <01bcbe02$d6bf3b00$1e01070a_at_MorrowD.ci.portsmouth.va.us>,
D Morrow <morrowd_at_ci.portsmouth.va.us> wrote:
>Help!!
> I'm trying to display an LOV in a When-Validate-Item trigger using the
>SHOW_LOV built-in. I tried using LIST_VALUES which the documentation says
>in unrestricted; but, receive error message that can't use restricted
>LIST_VALUES in WVI trigger. I want to use the auto search and complete
>feature such as in LIST_VALUE(RESTRICT) but using SHOW_LOV. Does anyone
>know if this is possible? Is there a property in the designer to set to
>accomplish this? I don't want to set the LOV for validation because the
>user can enter values other than what is in the LOV.
If you REALLY want to do this bad enough, you can do this: From within your WVI trigger, do the selection from your main record group into a secondary record group, selecting only the values that qualify based on the value in the item. This duplicates what the Restrict keyword would do. Then do a Show_LOV on a LOV defined for the secondary record group.
By the way, on-line help from the Forms Designer says both Show_LOV and List_Values are restricted, but I know I have used Show_LOV from a WVI trigger... hmmm...
>Also, is there a way to display a LOV when validating or leaving the record
>instead of just the item?
Before you leave the record, you can set the item to its own value:
:Blk.Itm := :Blk.Itm;
This will force the form to re-run the WVI trigger when you try to
leave the record. I do this in WVI triggers on other items in the
record if the validation for one item depends on the value of another.
>Thanks in advance for any suggestions
>
>Donna Morrow
>City of Portsmouth
>Computer Services
Steve Cosner
http://members.aol.com/stevec5088 Download QA, a dynamic data utility form-- Quick display and update access to any table Received on Thu Sep 11 1997 - 00:00:00 CEST