when_button_pressed (4 threads merged by bb) [message #539455] |
Mon, 16 January 2012 02:20 |
|
furqan
Messages: 115 Registered: January 2012 Location: Hyderabad
|
Senior Member |
|
|
declare
a_value_chosen boolean;
begin
a_value_chosen := Show_Lov('lov130');
IF NOT a_value_chosen THEN
message('You have not selected your Department Name');
bell;
RAISE form_trigger_failure;
END IF;
END;
i write the above code on push button but still even
without choosing anything from the list..if i directly press
the login button its not showing the messgae 'You have not selected your Department Name' and getting navigated to other form.
iam really new to form but had learned a lot since last 1 month,its really an interesting field..
thanks in advance for your help..
|
|
|
|
Re: when_button_pressed (3 threads merged by bb) [message #539514 is a reply to message #539458] |
Mon, 16 January 2012 11:24 |
|
Tomcrzy
Messages: 101 Registered: December 2011 Location: Chennai,India
|
Senior Member |
|
|
Hi furqan,
Quote:
i write the above code on push button but still even
without choosing anything from the list..if i directly press
the login button its not showing the messgae 'You have not selected your Department Name' and getting navigated to other form.
I don't think so. May be you had made some mistakes.
I will give you the steps
button->trigger(when_Button_Pressed->write your code ->Write the message two times if you want to see it in a window or as inside a message box
DECLARE
a_value_chosen BOOLEAN;
BEGIN
a_value_chosen := Show_Lov('lov130');
IF NOT a_value_chosen THEN
MESSAGE('You have not selected your Department Name');
MESSAGE('You have not selected your Department Name');
bell;
RAISE form_trigger_failure;
END IF;
END;
After compilation when you pressing the button it will throw an error(FRM-40202 Field must be entered )
then enter somedata inside the field and press the button the LOV will displays->cancel it
Quote:
the login button its not showing the messgae 'You have not selected your Department Name' and getting navigated to other form.
the message will displays.
Better you can go for when_new_form_instance trigger.
Thanks &Regards
Tom
[Updated on: Mon, 16 January 2012 11:28] Report message to a moderator
|
|
|
|
|
|
|
|
|
|