I do a Login form that take username & password then it check the type of the user ( Manager or Employee ), by that it open a special form for each type.
When I checked the code it is right but it dose not work ! It dose not take me to any where !
Also I had but a button with a trigger for calling new form but it also don’t open the form !!
Could you help me ??
declare
emp_no employee.ecpr%type;
emp_name employee.name%type;
emp_type employee.type%type;
begin
if NVL(LENGTH( :USERNAME ),0)=0 or NVL(LENGTH( ASS_WORD ),0)=0 then
message('please, enter the username and password first');
end if;
select ecpr, name, type into emp_no, emp_name, emp_type from employee
where employee.username=:USERNAME AND employee.password=ASS_WORD;
if emp_type = 'M' then
call_form('C:\Documents and Settings\ALAWIBH\Desktop\Second 2007\ITCS395\Project\MODULE2.fmx');
else
call_form('C:\Documents and Settings\ALAWIBH\Desktop\Second 2007\ITCS395\Project\MODULE2.fmx');
end if;
exception
when NO_DATA_FOUND then
message('Wrong Username OR Password');
end;
CALL TRIGGER:
//When image pressed
begin
call_form('D:\somtting3ty\uob2009\CS395\project\formy\employee.fmx');
exit_form;
end;
Bookmarks