Form Problem [message #511227] |
Fri, 10 June 2011 05:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mrnaveed
Messages: 74 Registered: December 2009 Location: Pakistan
|
Member |
|
|
Dear All when i have made form in developer 6i it works with forms 6i but when i run this form using oracle forms 10g it did not call the form i.e when i run the form enter the user name and password then i does nothing here my code please help
DECLARE
un varchar2(60);
pass varchar(30);
a number;
CURSOR c1 IS select username,password from login;
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO un,pass;
if un = :login.user_name and pass =:login.password then
CALL_FORM('d:\project\opt_form.fmx',no_hide,no_replace);
exit_form(no_validate,no_commit);
end if;
if un<>:login.user_name and pass <>:login.password then
a:=show_alert('Unsucessfull');
clear_form(no_validate,no_commit);
end if;
EXIT WHEN c1%NOTFOUND;
END LOOP;
CLOSE c1;
END;
Thanks in advance. Here the form
-
Attachment: Login1.JPG
(Size: 75.72KB, Downloaded 594 times)
|
|
|
|
|
|
|
|
|