Home » Developer & Programmer » Forms » Displaying a Popup Message In Login Form (Oracle Froms,10g,Windows server 2003)
Displaying a Popup Message In Login Form [message #437332] Sun, 03 January 2010 23:13 Go to next message
katangur.nikethan
Messages: 31
Registered: December 2009
Location: Hyderabad
Member
Hi all,

I want to display a popup message in my login form whether my password is valid or invalid i am attaching my code below


DECLARE
	pl_id paramList; 
	p_name VARCHAR2(20); 
	TEMP NUMBER;
BEGIN
	p_name := 'logindata';
	pl_id := GET_PARAMETER_LIST(p_name);
	IF NOT ID_NULL (pl_id) THEN
		DESTROY_PARAMETER_LIST(pl_id);
	END IF;
	pl_id := CREATE_PARAMETER_LIST(p_name);
	ADD_PARAMETER(pl_id,'P_ID',TEXT_PARAMETER,:USER_ID);
	SELECT COUNT(*)INTO TEMP FROM TB_TIMESHEET_USER WHERE USER_ID = :TB_TIMESHEET_USER.USER_ID AND PASSWORD = :TB_TIMESHEET_USER.PASSWORD;
	IF(TEMP>0) THEN
		new_form('path of fmx',TO_SAVEPOINT,NO_QUERY_ONLY,PL_ID);
	ELSE
		MESSAGE('INVALID USERNAME AND PASSWORD');
	END IF;
END;



In my log in form the message is dispalyed at the bottom of the form. It should be displayed in the popup message. I am attaching a screen shot of my login from

./fa/7238/0/

  • Attachment: message.GIF
    (Size: 18.02KB, Downloaded 231 times)
Re: Displaying a Popup Message In Login Form [message #437358 is a reply to message #437332] Mon, 04 January 2010 00:45 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create an alert.

Or, try with two MESSAGEs; something like
	ELSE
		MESSAGE('INVALID USERNAME AND PASSWORD');
                MESSAGE('INVALID USERNAME AND PASSWORD');
	END IF;
as it will force one of the messages to appear as "pop-up" as you have to acknowledge the previous message.
Re: Displaying a Popup Message In Login Form [message #437364 is a reply to message #437358] Mon, 04 January 2010 01:06 Go to previous message
katangur.nikethan
Messages: 31
Registered: December 2009
Location: Hyderabad
Member
Thanks we got it
Previous Topic: How to remove menu's hotkeys
Next Topic: Password should not be displayed in the database
Goto Forum:
  


Current Time: Wed Dec 07 18:24:59 CST 2016

Total time taken to generate the page: 0.19075 seconds