| Change password [message #140447] |
Tue, 04 October 2005 05:11  |
SaraC
Messages: 81
Registered: August 2005
|
Member |
|
|
Hi there - have posted before - but noone had any answers so thought Id try again and explain differently. djmartin I tried the search and nothing similar came up.
Heres the problem
When I log into forms and password has expired, I have set up a user profile with a password verify function, to verify the new password being entered. When one of the verification rules is broken e.g. password is <8 characters I get an FRM 40735 Unhandled error returned to Forms - 06502. I cannot understand this as my verify function works exactly the same as the default Oracle one so why are the errors not handled properly - just to add some errors are handled - incorrect username/password and password cannot be reused errors.
I have a manual change password screen that can be used by the user any time they are logged in. And the same verification function works here and errors can be handled.
I have tried to bypass the default change password screen but cannot get the screen to call another form from an ON-ERROR trigger which is where the password expired error is raised.
Please help - getting really bogged down in this now and dont think I will be able to solve it!
Thx
Sara
|
|
|
|
|
|
| Re: Change password [message #140667 is a reply to message #140447] |
Wed, 05 October 2005 02:49  |
SaraC
Messages: 81
Registered: August 2005
|
Member |
|
|
The on-error trigger is at the top level of the form.
Im not sure I understand what you mean - I dont have any selects.
This is what I want to happen
Begin
If error is 28001 - ie password expired then
disable Forms automatic change password screen
Open my own change password screen
end if;
end
|
|
|
|
|
|
| Re: Change password [message #140910 is a reply to message #140447] |
Thu, 06 October 2005 03:01 |
SaraC
Messages: 81
Registered: August 2005
|
Member |
|
|
Yes,
the on-error is in my first form/splash screen. I have trapped the password expire error in this on-error trigger.
and then try to do the call form - Im not sure if the form is actually called but not displayed - will check that one.
Login is by current user - could be a different user everytime so like you say it probably wont show the screen because I am not logged on.
Someone from another forum has suggested that my version of forms is too old to deal with the errors from the verify function and doesnt know how to handle them.
Thx
|
|
|
|
| Re: Change password [message #140929 is a reply to message #140447] |
Thu, 06 October 2005 05:18 |
SaraC
Messages: 81
Registered: August 2005
|
Member |
|
|
Ok Ive tried adding message logs into the password form (the form I am trying to call after the timer has expired) I put messages in On-error, WHEN-NEW_FORM_INSTANCE and WHEN-WINDOW-ACTIVATED. None of these are displayed so Im guessing that the form is not even called.
Ive also added a log in WHEN TIMER EXPIRED and no message is displayed. So doesn't look as if the timer is working right either. This is the code for the timer
.
.
.
timer_id := Find_timer('MY_TIMER');
IF NOT ID_NULL(timer_id) then
delete_timer(timer_id);
END IF;
timer_id := CREATE_TIMER('MY_TIMER','1', NO_REPEAT);
.
.
.
this is the code for WHEN_TIMER-EXPIRED
.
.
.
IF(Get_Application_Property(TIMER_NAME)= 'MY_TIMER') THEN
message('sara show change pwd');
message('');
NEW_FORM('password.fmx');
END IF;
.
.
.
|
|
|
|
|
|
|
|
| Re: Change password [message #141166 is a reply to message #140447] |
Fri, 07 October 2005 05:09 |
SaraC
Messages: 81
Registered: August 2005
|
Member |
|
|
Have got messages before and after the create timer statement and also a message in the when timer expired trigger.
The messages either side of the create timer just fire one after the other and the message from the timer expired trigger is not fired - I was expecting that the one in the expired trigger should be fired in between the 2 before and after the create timer...
|
|
|
|
| Re: Change password [message #141371 is a reply to message #141166] |
Sun, 09 October 2005 22:58 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
No ... the timer fires after the issuing trigger has finished. You do have a When-Timer-Expired trigger, right? This timer stuff is VERY well explained in the Forms Reference doco. Go through it again, make sure you have spelled your timer name the same in all places. If it still doesn't work then you will have to paste the trigger code in this thread for us to verify your work.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
