Home » Developer & Programmer » Forms » create a menu
create a menu [message #412665] Fri, 10 July 2009 07:49 Go to next message
sbaiju
Messages: 7
Registered: July 2009
Location: BOTSWANA
Junior Member

I'm a new oracle forms 6i programmer. I dont know how to create a menu that will call forms. please help me
Re: create a menu [message #413267 is a reply to message #412665] Wed, 15 July 2009 01:12 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Create a menu. Do a 'call_form'.

David
Re: create a menu [message #413271 is a reply to message #413267] Wed, 15 July 2009 01:22 Go to previous messageGo to next message
sbaiju
Messages: 7
Registered: July 2009
Location: BOTSWANA
Junior Member

call_form('path').its not working.tellme the path how the extension is mmb or mmx .both i tried not working
checking username /password [message #413273 is a reply to message #413271] Wed, 15 July 2009 01:29 Go to previous messageGo to next message
sbaiju
Messages: 7
Registered: July 2009
Location: BOTSWANA
Junior Member

how to check using trigger in a pushbutton how to check username & password is correct or not.if correct i want to pass to next form otherwise i want to show msg'invalid username/password'
Re: create a menu [message #413280 is a reply to message #412665] Wed, 15 July 2009 02:03 Go to previous message
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;
Previous Topic: migration from oracle 9i to 10g
Next Topic: Forms_ddl insertion problem
Goto Forum:
  


Current Time: Tue Dec 03 17:46:56 CST 2024