Home » Developer & Programmer » Forms » Display employee details
Display employee details [message #578159] Mon, 25 February 2013 01:03 Go to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hello sir,

i want to display employees details when i am passing Deptno and that department employees only display in Oracle Forms
Re: Display employee details [message #578161 is a reply to message #578159] Mon, 25 February 2013 01:06 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The simplest way is to create a form based on the EMP table (if it is Scott's schema), simply by following the Wizard. Run the form, enter query mode. Enter department number into its item, execute query.

If that's not what you are looking for, perhaps you should describe what you really have (maybe even attach a form screenshot).
Re: Display employee details [message #578443 is a reply to message #578161] Thu, 28 February 2013 02:40 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hello Sir,
I have 2 tables emp,dept with Relation , I added additional columns Sal*0.10,Sal*0.20 for Salary Increment, for this i created Formula column in Template.fmb
, But i run this program in Apps it shows Error "invalid Sal*0.10,Sal*0.20" text item, Please help me...
Re: Display employee details [message #578445 is a reply to message #578443] Thu, 28 February 2013 03:43 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I can't open your form with my Forms version so I can't check what you did.

However, where did you "add additional columns Sal*0.10,Sal*0.20 for Salary Increment"? A formula column is created rather easily - here's a screenshot:

./fa/10677/0/

(EMP is my data block name, SAL is column/item name). So, did you do it as I did, or did you (for example) "forget" to precede item name with a colon (:) sign, or ...?
Re: Display employee details [message #578453 is a reply to message #578445] Thu, 28 February 2013 05:06 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Thanks, I got it..
Re: Display employee details [message #578561 is a reply to message #578161] Fri, 01 March 2013 04:26 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Sir,
I want to display emp details , When i am passing Deptno 10 , I have Only One block,
suppose,In Reports We create Parameters like,in Forms also...
Re: Display employee details [message #578565 is a reply to message #578561] Fri, 01 March 2013 04:58 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Read my first message in this topic once again.
Re: Display employee details [message #578576 is a reply to message #578565] Fri, 01 March 2013 05:53 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Ok and i am sorry for that , My question is Only display Empno no , based on the deptno and only display particular deptno's empnumber , i have a emp table...
Re: Display employee details [message #578577 is a reply to message #578576] Fri, 01 March 2013 05:55 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Littlefoot's first message tells you how to do that.
Form having all objects... [message #578986 is a reply to message #578565] Wed, 06 March 2013 22:21 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hi sir,
I want to create form that having all triggers and buttons , can u please suggest me..
Re: Form having all objects... [message #578996 is a reply to message #578986] Thu, 07 March 2013 00:03 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this a new question, or is it still related to the previous "display employee details" one?

Anyway: what do you mean by "all triggers and buttons"? There can be zillion triggers and buttons in a form, so I'm not sure I understood what "all" actually means. You shouldn't create triggers here and there, just because but when you need them for implementing business requirements. If you don't need triggers at all (which would be a default form, created by wizard), you simply don't create them ./fa/3314/0/.

So, could you explain what you meant to say?
Re: Form having all objects... [message #578999 is a reply to message #578996] Thu, 07 March 2013 00:11 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Ok , I understood , but using some triggers only i want
Re: Form having all objects... [message #579000 is a reply to message #578999] Thu, 07 March 2013 00:12 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I said: you use them when you need them. Do you need them? If so, use them.

I don't know which triggers you need so I can't suggest anything.
Re: Form having all objects... [message #579001 is a reply to message #578999] Thu, 07 March 2013 00:13 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Ok Thanks..
Re: Form having all objects... [message #579044 is a reply to message #579001] Thu, 07 March 2013 03:16 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hello sir,
please find the error, I got like 'pr-popup-menu' trigger, please please find the error help me and attached my form..
Re: Display employee details [message #579054 is a reply to message #578445] Thu, 07 March 2013 03:36 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Littlefoot wrote on Thu, 28 February 2013 10:43
I can't open your form with my Forms version so I can't check what you did.

Sorry.
Re: Display employee details [message #579055 is a reply to message #579054] Thu, 07 March 2013 03:37 Go to previous message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
My form is in 10g version..
and ok Thanks
Previous Topic: Making form read only
Next Topic: FORMS and AFTER INSERT TRIGGER
Goto Forum:
  


Current Time: Thu Apr 17 11:57:05 CDT 2014

Total time taken to generate the page: 0.25020 seconds