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
where SEI_Inv_Statuscode = :txtStatusCode
order by SEI_Inv_Order;
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?
-- The status code is valid, so display the status description.
:txtStatusName := StatusRow.SEI_Inv_Description;