OraFAQ Forum: Forms » Display employee details

Home » Developer & Programmer » Forms » Display employee details

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

Display employee details [message #578159]

Mon, 25 February 2013 01:03

mist598
Messages: 1195
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

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: 21813
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

mist598
Messages: 1195
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...

Attachment: XXC_SAL_TEST2.fmb
(Size: 532.00KB, Downloaded 1090 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: 21813
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:

/forum/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 1255 times)

Report message to a moderator

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

Thu, 28 February 2013 05:06

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior 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

mist598
Messages: 1195
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...

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: 21813
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

mist598
Messages: 1195
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...

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: 13925
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

mist598
Messages: 1195
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..

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: 21813
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 /forum/fa/3314/0/

.

So, could you explain what you meant to say?

Report message to a moderator

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

Thu, 07 March 2013 00:11

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok , I understood , but using some triggers only i want

Report message to a moderator

Re: Form having all objects... [message #579000 is a reply to message #578999]

Thu, 07 March 2013 00:12

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

Report message to a moderator

Re: Form having all objects... [message #579001 is a reply to message #578999]

Thu, 07 March 2013 00:13

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok Thanks..

Report message to a moderator

Re: Form having all objects... [message #579044 is a reply to message #579001]

Thu, 07 March 2013 03:16

mist598
Messages: 1195
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..

Attachment: XXC_DEPT_FIND.fmb
(Size: 596.00KB, Downloaded 1069 times)

Report message to a moderator

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

Thu, 07 March 2013 03:36

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

Report message to a moderator

Re: Display employee details [message #579055 is a reply to message #579054]

Thu, 07 March 2013 03:37

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

My form is in 10g version..
and ok Thanks

Report message to a moderator

Previous Topic:	Making form read only
Next Topic:	FORMS and AFTER INSERT TRIGGER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:25:52 CDT 2024