OraFAQ Forum: Forms » Open new Form and Exit this Form

Home » Developer & Programmer » Forms » Open new Form and Exit this Form

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

Open new Form and Exit this Form [message #379092]

Sun, 04 January 2009 13:47

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

well i create a user name and password form and call to new form

just like this

if
:user='bounti'
then
if
:Pas='kse'
then
OPEN_FORM('c:\production');
exit_form;
else
Message('Invalid Password');
Message('Invalid Password');
end if;
else
Message('Invalid User ID');
Message('Invalid User ID');
end if;

now when i press button its open and new form but its not close the current form what can i do ?

Thanks

Shahzaib ismail

Report message to a moderator

Re: Open new Form and Exit this Form [message #379094 is a reply to message #379092]

Sun, 04 January 2009 15:42

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

Senior Member
Account Moderator

You might open Forms Online Help system and read about the differences between CALL_FORM, OPEN_FORM and NEW_FORM. One of these will do the job (i.e. open a new form and close current form), but I believe that you'll learn something new by reading these few lines by yourself.

Report message to a moderator

Re: Open new Form and Exit this Form [message #379095 is a reply to message #379092]

Sun, 04 January 2009 15:47

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

just a miner mistake Call form and then close form

done with this

if
:user='bounti'
then
if
:Pas='kse'
then
call_FORM('c:\production');
close_form('user');
else
Message('Invalid Password');
Message('Invalid Password');
end if;
else
Message('Invalid User ID');
Message('Invalid User ID');
end if;

Thanks for your reply Little foot

Report message to a moderator

Re: Open new Form and Exit this Form [message #379149 is a reply to message #379095]

Mon, 05 January 2009 02:54

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

Senior Member
Account Moderator

Actually,

Quote:

call_FORM('c:\production');
close_form('user');

is not what I had in mind.

It is the NEW_FORM built-in which is supposed to do that.

Report message to a moderator

Re: Open new Form and Exit this Form [message #379171 is a reply to message #379092]

Mon, 05 January 2009 04:06

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Both trigger working are same

do you know what is difference between them ? ? ?

Report message to a moderator

Re: Open new Form and Exit this Form [message #379243 is a reply to message #379171]

Mon, 05 January 2009 11:58

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

Senior Member
Account Moderator

The final result is the same, of course. CALL_FORM + CLOSE_FORM will do the job. Though, NEW_FORM is designed to do both in a single call: open a new form and close a parent form.

Report message to a moderator

Previous Topic:	unique constraint with duplicate entry
Next Topic:	Getting error ORA-01847:day of month must be between 1st and last day of month

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 02:59:06 CDT 2025