OraFAQ Forum: Forms » help plzzzzzzzzz!!!!!!!!!!!!!1

Home » Developer & Programmer » Forms » help plzzzzzzzzz!!!!!!!!!!!!!1

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

help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118306]

Wed, 04 May 2005 04:32

sam2
Messages: 7
Registered: May 2005

Junior Member

hi

i am new to plsql and form builders!!!!!!!!!
i need a func that calculates the comission for each employee at the end of each day, and inserts a new record for employee in performence table.

here are the tables: -

employee:
emp no
empname
emptel
position

performence:
empno
performence date
comission

any help would be apreciated!!!!! Razz

Report message to a moderator

Re: help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118312 is a reply to message #118306]

Wed, 04 May 2005 05:22

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Dear

Also mention the table(s) from where you plan to calculate commission and store in performance table.

Wishes
Jawad

Report message to a moderator

Re: help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118345 is a reply to message #118306]

Wed, 04 May 2005 09:58

sam2
Messages: 7
Registered: May 2005

Junior Member

this is the only two tables that can be used the others are not important although there is dispatch ass. and sales assistant tables but im not sure if they r going to be used..

Report message to a moderator

Re: help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118390 is a reply to message #118306]

Wed, 04 May 2005 18:33

sam2
Messages: 7
Registered: May 2005

Junior Member

CAN ANY 1 PLZ HELP ME IT IS URGENT

THANKZZ

Report message to a moderator

Re: help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118405 is a reply to message #118306]

Wed, 04 May 2005 21:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at http://www.orafaq.com/forum/m/116433/67467/?srch=commission#msg_116433 and tell us what else you need.

David

Report message to a moderator

Re: help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118467 is a reply to message #118306]

Thu, 05 May 2005 08:00

sam2
Messages: 7
Registered: May 2005

Junior Member

thanks mate!!!

one more thing :

how do i insert a new record for each employee after i have calculted total comission for each employee.

Report message to a moderator

Re: help plzzzzzzzzz!!!!!!!!!!!!!1 [message #118566 is a reply to message #118306]

Thu, 05 May 2005 20:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do the insert when you do the monthly pay run. This record contains the salary. Then apply the deductions. Finally when the sales have been run you do an UPDATE to work out the commissions.

Alternatviely, if you have all the other information available then you probably don't need to do the work in a form but just have a button which calls a PL/SQL script (package, procedure, or function) that scans the other tables and perform an insert for all active employees.

Go to http://otn.oracle.com/pls/db92/db92.homepage. There is a SQL, PL/SQL, and SQL*Plus link that will lead you to the 'insert' statement.

David

Report message to a moderator

Previous Topic:	need interview questions for forms 6i
Next Topic:	FRM-99999 Error 408 Occurred

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 08 06:17:06 CST 2024