|
|
|
|
Re: create a menu [message #413280 is a reply to message #412665] |
Wed, 15 July 2009 02:03 |
blaxmi
Messages: 36 Registered: May 2008 Location: Hyderabad
|
Member |
|
|
hi
in the main user login form place one button to enter into the actual application.In when-button-pressed trigger u just write the code as below: I'm sure it will definately work.
declare
curr_pwd varchar2(30);
user_type1 varchar2(15);
user_id1 varchar2(50);
log_in1 date;
begin
select password,user_type into curr_pwd,user_type1
from user_master
where user_id=:user_master.user_id ;
:global.g_user_id :=:user_master.user_id;
if curr_pwd=:password then
--if user_type1='PROGRAMMER' or user_type1='VALIDATION'or user_type1='SUPER USER' then
new_form('D:\ECTS_server\proj_code.fmx');
--new_form('proj_code.fmx');
exit_form(no_commit);
--end if;
else
message('W R O N G Password');
message('W R O N G Password');
raise form_trigger_failure;
end if;
end;
|
|
|