Login Credential (Oracle9i Form Developer)

[meLady]

Hello,

I have a table which called users and it has two fields username and password.

Also, I have a form that has a log in text items and they are:
username.txt and password.txt. + okay button

So, I would like to know how the code goes for this type of idea. I want the user to insert his/her username and password in the login form and then when pressing the okay button, the system will check and varify the username and password in the users table.

as usual if it wrong ... the error message will be displayed and if it right the next form will be opened ...

I will be more delighted if you could help me in providing the right solutions for my queries.

[meLady]

any reply to my queries?????

[anuj13singhal]

Hi,

Perform the following steps

on button pressed trigger write the following code

 declare 
v varchar2(1);
begin
select 'X' into v from table_name where username = :block2.username
and password = :block2.password;
if v='X' then
call_form('form_name');
else
message('Please enter username and password again');
:block2.password := null;
:block2.username := null;
end if;
end;
 
 

Hopw this helps !!

any reply to my queries?????

[meLady]

Hi,

Perform the following steps

on button pressed trigger write the following code

declare
v varchar2(1);
begin
select 'X' into v from table_name where username = :block2.username
and password = :block2.password;
if v='X' then
call_form('form_name');
else
message('Please enter username and password again');
:block2.password := null;
:block2.username := null;
end if;
end;



Hopw this helps !!

Hello anuj13singhal,

Thanks a lot for the steps (^_^) and I will try ... sorry for not replying to your reply because of exam semester ... Again thanks a lot and I will surely inform you about the steps that you provided me.