OraFAQ Forum: Forms » verify password

Home » Developer & Programmer » Forms » verify password (Developer Forms 4.5 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

verify password [message #480812]

Wed, 27 October 2010 06:48

onkar07
Messages: 7
Registered: August 2009
Location: Navi Mumbai

Junior Member

Dear all,

IS THERE ANY ROUTINE TO CHECK MY NEW PASSWORD IS NOT SAME AS MY PREVIOUS PASSWORDS WHICH ARE STORED IN A AUDITE TABLE .

Report message to a moderator

Re: verify password [message #480824 is a reply to message #480812]

Wed, 27 October 2010 07:39

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Declare
P varchar2(25);
begin

  Select  UserPassword into :Global.P   from Duser
  where  username='NZ';
 
   If  (:password=:Global.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

Report message to a moderator

Re: verify password [message #480828 is a reply to message #480824]

Wed, 27 October 2010 07:51

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Why did you declare a variable (P) and then selected value into a GLOBAL variable?

If you choose to use a local variable, then VARCHAR2(25) might not be enough (as Oracle limited it to 30 bytes) (see "Len" below):

SQL> create user lf_test identified by a234567890123456789012345678901;
create user lf_test identified by a234567890123456789012345678901
                                  *
ERROR at line 1:
ORA-00972: identifier is too long


SQL> select dump('a234567890123456789012345678901') from dual;

DUMP('A234567890123456789012345678901')
----------------------------------------------------------------------------------------------------
Typ=96 Len=31: 97,50,51,52,53,54,55,56,57,48,49,50,51,52,53,54,55,56,57,48,49,50,51,52,53,54,55,56,5
7,48,49

SQL> create user lf_test identified by a23456789012345678901234567890;

User created.

SQL> select dump('a23456789012345678901234567890') from dual;

DUMP('A23456789012345678901234567890')
----------------------------------------------------------------------------------------------------
Typ=96 Len=30: 97,50,51,52,53,54,55,56,57,48,49,50,51,52,53,54,55,56,57,48,49,50,51,52,53,54,55,56,5
7,48


SQL>

Report message to a moderator

Re: verify password [message #480832 is a reply to message #480828]

Wed, 27 October 2010 08:13

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear Littlefoot,

I was Just given them Idea Not to write complete code for them.

Copy - Paste from my form.

Report message to a moderator

Previous Topic:	Running Concurrent Report from FORM
Next Topic:	No. Of Checkbox clicked at a time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:40:12 CDT 2024