Home » Developer & Programmer » Forms » custom logon screen(new_form)
custom logon screen(new_form) [message #226148] Thu, 22 March 2007 12:06 Go to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: custom logon screen(new_form) [message #226398 is a reply to message #226218] Fri, 23 March 2007 09:19 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: HOW TO ADD CLAUSE
Next Topic: Oracle forms 9i
Goto Forum:
  


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

Total time taken to generate the page: 0.12131 seconds