• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1508
  • Last Modified:

Code in WHEN-VALIDATE-ITEM not firing!

I am checking the validity of text entered in the WHEN-VALIDATE-ITEM.  If the character ("status code") isn't in another table, I want to pull up an LOV.  Apparently, I can't display an LOV from the WHEN-VALIDATE-ITEM trigger.  Below is my code.  Is there an alternate way to display an LOV when incorrect data is entered into the text field?

Thanks,
Brian

------------------------

declare
   cursor c_Status is
      select *
         from SEI_Statuscode
         where SEI_Inv_Statuscode = :txtStatusCode
         order by SEI_Inv_Order;
         
   StatusRow c_Status%rowtype;

begin
   open c_Status;
   fetch c_Status into StatusRow;

   if (c_Status%NOTFOUND) then
      -- If I can't display an LOV here, could I instead execute
      -- the click event of a button?
      go_item ('txtStatusName');
      list_values;
   else
      -- The status code is valid, so display the status description.
      :txtStatusName := StatusRow.SEI_Inv_Description;
   end if;

   close c_Status;
end;
0
bek
Asked:
bek
1 Solution
 
FBIAGENTCommented:
BEK,

You can associate an LOV with an item by specifying the name of the LOV in the LOV Properties of a text item.  If you want user input to be validated against the LOV, then you need to set the property LOV For Validation to True.
You don't need the WHEN-VALIDATE-ITEM trigger for the text item if you do the aforementioned.

Also, in your LOV, you can specify the fields to be populated when the user select a value from the LOV via the Column Mapping Property in the LOV.
In your form, you also need a POST-QUERY trigger to populate the control field(s) (just like what you did in the WHEN-VALIDATE-ITEM trigger for :txtStatusName.

Good luck
0
 
santoshmathewCommented:
Hi,

There is an Lov property : I think it is Validate from lov. Set this property to true.

cheers.
0
 
bekAuthor Commented:
Sorry for the delay in giving credit.  I got tied up struggling with my project.  Thanks again!

-Brian
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now