Code in WHEN-VALIDATE-ITEM not firing!

Posted on 2001-08-24
Last Modified: 2007-12-19
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?



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

   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');
      -- The status code is valid, so display the status description.
      :txtStatusName := StatusRow.SEI_Inv_Description;
   end if;

   close c_Status;
Question by:bek

Accepted Solution

FBIAGENT earned 50 total points
ID: 6423541

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

Expert Comment

ID: 6423596

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


Author Comment

ID: 6444877
Sorry for the delay in giving credit.  I got tied up struggling with my project.  Thanks again!


Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now