Home » Developer & Programmer » Forms » Logon form (Forms 6i)
Logon form [message #484952] Sat, 04 December 2010 01:16 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Dear All,

I just need to create a login form ..its like user will login using his given id and password will be encryted when entering and i just need to simple validation that if he has entered corrected password it will display message ok or else wrong password.How i can do it.Please guide me.
Re: Logon form [message #484960 is a reply to message #484952] Sat, 04 December 2010 05:33 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

Declare
P varchar2(25);
begin

  Select  UserPassword into P   from Duser
  where  username='NZ';
 
   If  (:password=P ) then
	    
     	 Call_form( 'E:\abc.fmx',Hide);
  	 Clear_form;
  	   
    else
	Message('Please Enter the Correct Password');
	Message('Please Enter the Correct Password');
	Clear_form;
		
   end if;
 end;




I hope you'll get idea.



Regards,

Irfan
Re: Logon form [message #484961 is a reply to message #484960] Sat, 04 December 2010 05:36 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

Thanks irfan , but i newbie to forms and can you give me when to enter the code on the button or if you have sample for i would appriciate.
Re: Logon form [message #484962 is a reply to message #484960] Sat, 04 December 2010 05:37 Go to previous message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

and how to enter the password in encrypt mode.
Previous Topic: Export Data from SQL Plus To MS Excel (merged)
Next Topic: Exit without saving
Goto Forum:
  


Current Time: Thu Sep 19 00:11:42 CDT 2024