OraFAQ Forum: Forms » Display employee details

Home » Developer & Programmer » Forms » Display employee details

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Display employee details [message #578159]

Mon, 25 February 2013 01:03

suryamm
Messages: 70
Registered: February 2013
Location: Hyderabad

Member

Hello sir,

i want to display employees details when i am passing Deptno and that department employees only display in Oracle Forms

Report message to a moderator

Re: Display employee details [message #578161 is a reply to message #578159]

Mon, 25 February 2013 01:06

Littlefoot
Messages: 16967
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).

Report message to a moderator

Re: Display employee details [message #578443 is a reply to message #578161]

Thu, 28 February 2013 02:40

suryamm
Messages: 70
Registered: February 2013
Location: Hyderabad

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...

Attachment: XXC_SAL_TEST2.fmb
(Size: 532.00KB, Downloaded 28 times)

Report message to a moderator

Re: Display employee details [message #578445 is a reply to message #578443]

Thu, 28 February 2013 03:43

Littlefoot
Messages: 16967
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 ...?

Attachment: forms_formula.JPG
(Size: 12.81KB, Downloaded 102 times)

Report message to a moderator

Re: Display employee details [message #578453 is a reply to message #578445]

Thu, 28 February 2013 05:06

suryamm
Messages: 70
Registered: February 2013
Location: Hyderabad

Member

Thanks, I got it..

Report message to a moderator

Re: Display employee details [message #578561 is a reply to message #578161]

Fri, 01 March 2013 04:26

suryamm
Messages: 70
Registered: February 2013
Location: Hyderabad

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...

Report message to a moderator

Re: Display employee details [message #578565 is a reply to message #578561]

Fri, 01 March 2013 04:58

Littlefoot
Messages: 16967
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Read my first message in this topic once again.

Report message to a moderator

Re: Display employee details [message #578576 is a reply to message #578565]

Fri, 01 March 2013 05:53

suryamm
Messages: 70
Registered: February 2013
Location: Hyderabad

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...

Report message to a moderator

Re: Display employee details [message #578577 is a reply to message #578576]

Fri, 01 March 2013 05:55

cookiemonster
Messages: 9148
Registered: September 2008
Location: Rainy Manchester

Senior Member

Littlefoot's first message tells you how to do that.

Report message to a moderator

Form having all objects... [message #578986 is a reply to message #578565]

Wed, 06 March 2013 22:21

suryamm
Messages: 70
Registered: February 2013
Location: Hyderabad

Member

Hi sir,
I want to create form that having all triggers and buttons , can u please suggest me..

Report message to a moderator

Re: Form having all objects... [message #578996 is a reply to message #578986]

Thu, 07 March 2013 00:03

Littlefoot
Messages: 16967
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/