OraFAQ Forum: Forms » Triggers linking to another CANVAS

Home » Developer & Programmer » Forms » Triggers linking to another CANVAS

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

Triggers linking to another CANVAS [message #86955]

Tue, 23 November 2004 18:07

erika
Messages: 2
Registered: April 2002

Junior Member

I'm using Oracle Forms Developer and I am trying to create a login screen.

I have username and password and then a submit button.

I already have a dataset with username and password,

My question is how do you write the code so that if someone enters in the right username and password and hits the submit button, they get a message that says "login successful" versus if they don't and get a message that says "login unsuccessful"?

Thanks for your help

Erika

Report message to a moderator

Re: Triggers linking to another CANVAS [message #86968 is a reply to message #86955]

Wed, 24 November 2004 17:40

xyz
Messages: 9
Registered: January 2002

Junior Member

use message built-in.
b4 calling new form or canvas.

Report message to a moderator

Re: Triggers linking to another CANVAS [message #87003 is a reply to message #86968]

Sun, 28 November 2004 08:34

Just John
Messages: 69
Registered: November 2004

Member

I would do the following:

when button pressed
-------------------

SELECT max('X') --save exception for no_data_found
INTO valid_user
FROM allowed_users
WHERE users_name = :users_name
AND users_pswd = :users_pswd
AND rownum = 1 --save exception for too_many_rows.

IF valid_user = 'X' THEN
message('valid user');
ELSE
message('invalid login');
END IF;

Report message to a moderator

Previous Topic:	key commit problem
Next Topic:	Closing all the forms from the menu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 15:55:42 CDT 2024