Home » Developer & Programmer » Forms » WHEN LOV DOES NOT RETURN ANY RECORD
WHEN LOV DOES NOT RETURN ANY RECORD [message #130763] Tue, 02 August 2005 06:31 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

I WANT TO DISPLAY THE MESSAGE WHEN LOV DOES NOT RETURN ANY VALUE WHAT I HAVE TO DO.

SAMIT GANDHI
Re: WHEN LOV DOES NOT RETURN ANY RECORD [message #130769 is a reply to message #130763] Tue, 02 August 2005 07:00 Go to previous messageGo to next message
v_mitsuricha
Messages: 4
Registered: August 2005
Location: INDIA
Junior Member
Dear samit
Just fire a count on same lov query and if count value is greater than 0 then open lov or just fire a message.
Richa
Re: WHEN LOV DOES NOT RETURN ANY RECORD [message #130849 is a reply to message #130763] Tue, 02 August 2005 19:58 Go to previous messageGo to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

Dear Richa,

I have tried for that only earlier but it is not working.

Any other alternative u have?

And by the way thanks for your prompt reply.

Samit Gandhi
Re: WHEN LOV DOES NOT RETURN ANY RECORD [message #130850 is a reply to message #130849] Tue, 02 August 2005 20:16 Go to previous message
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

Previous Topic: Call report
Next Topic: WUC-015
Goto Forum:
  


Current Time: Fri Sep 20 02:04:43 CDT 2024