|
|
|
Re: WHEN LOV DOES NOT RETURN ANY RECORD [message #130850 is a reply to message #130849] |
Tue, 02 August 2005 20:16 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Try the following code in a KEY-LISTVAL trigger for your item/*
** Built-in: SHOW_LOV
** Example: Display a named List of Values (LOV)
*/
DECLARE
a_value_chosen BOOLEAN;
BEGIN
a_value_chosen := Show_Lov ('my_employee_status_lov');
IF NOT a_value_chosen THEN
Message ('You have not selected a value.');
Bell;
RAISE Form_Trigger_Failure;
END IF;
END;
David
PS This is copied straight out of the doco.
[Updated on: Tue, 02 August 2005 20:25] Report message to a moderator
|
|
|