Creat A login Page

[romi]

Hello all,

i am new in this forum and also in oracle forms9i.i have made a login screen, in my page ther is 3 component i.e userid,password and a button(go). i want that when user put userid and password then it matches to table(login having 2 column userid and password).if it matches then it will go on another page otherwise it should give alert massage.

but i am unable to do it.Plz help me.

thanks in advance

[anuj13singhal]

Hello all,

i am new in this forum and also in oracle forms9i.i have made a login screen, in my page ther is 3 component i.e userid,password and a button(go). i want that when user put userid and password then it matches to table(login having 2 column userid and password).if it matches then it will go on another page otherwise it should give alert massage.

but i am unable to do it.Plz help me.

thanks in advance

------------------------------------------------------------------------------------------------------------------
Suppose your userid item name is userid_1 and password item name is password_1 and your block name is block2

In button press trigger of go button write :

declare
cursor c1(uid,pwd) is select * from login where userid=uid and password=pwd;
userid1 varchar2(20);
passwd varchar2(20);
begin
open c1(:block2.user id_1,:block2.pa ssword_1);
if c1%found then
fetch c1 into userid1,passwd;
close c1;
else
show alert('msg_aler t');
end if;
end;
---------------------------------------------------------------------------------

create a alert with name msg_alert before compilingh the form.

Hope this will work..