OraFAQ Forum: Forms » custom logon screen(new

Home » Developer & Programmer » Forms » custom logon screen(new_form)

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

custom logon screen(new_form) [message #226148]

Thu, 22 March 2007 12:06

vamsik
Messages: 15
Registered: February 2007

Junior Member

Hi Frds,

I have created a custom logon screen and its working fine(running on unix box).On logon trigger i used call_form to call a new form.you can see the code below.What i exactly want is i want to close this form and open a new form when successfully logged into database. I tried to keep new_form instead of call_form. but its not working. Please guide me with good solution asap friends.
***on-logon trigger***
declare
formFlag boolean;
begin
if :block3.userName is not null and :block3.password is not null then
logon(:block3.userName,:block3.passWord||'@'||'sptest',false);
formFlag := form_success;
if formFlag then
--replace_menu('pog_plan_menu');
call_form('pog_plan');
else
message('Invalid user/password. Please try again ');
end if;
end if;
end;
****login button.when button pressed***
logon(null'null'false);

Thanks in advance,
Vamsi.

[Updated on: Thu, 22 March 2007 15:54]

Report message to a moderator

Re: custom logon screen(new_form) [message #226218 is a reply to message #226148]

Thu, 22 March 2007 20:59

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

'New_form' is the correct method.

You say

I tried to keep new_form instead of call_form. but its not working.

What is 'not working'? What happened? Did you get an error message? If so, what is that error message?

David

Report message to a moderator

Re: custom logon screen(new_form) [message #226398 is a reply to message #226218]

Fri, 23 March 2007 09:19

vamsik
Messages: 15
Registered: February 2007

Junior Member

Hi Frd,

Following is the error when i try to use new_form instaed of call_form.

[/url]

I want to close the logon form once i successfully logged in. and then call form2.Please guide me how to defeat this issue.

Thanks,
Vamsi

[Updated on: Fri, 23 March 2007 09:20]

Report message to a moderator

Re: custom logon screen(new_form) [message #226901 is a reply to message #226398]

Mon, 26 March 2007 21:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please put code like this in the When-New-Form-Instance trigger. Reread the documentation, verify whether 'restricted' commands can be run in the trigger in question when you get an error, read the expalnation for a trigger and get an understanding for what Oracle suggestions that that trigger can be used.

David

Report message to a moderator

Previous Topic:	HOW TO ADD CLAUSE
Next Topic:	Oracle forms 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 20:54:35 CST 2025