hey!
i need to create a customised table "Employee" in which i have to insert employeeid,employeename and salary...on inserting the salary,the table should automatically calculate Hra(10% of basic salary),DA(9% of basic salary) and hence calculate net salary...so...plz guide me...how to do this?
simransuri
-4
Newbie Poster
Recommended Answers
Jump to Postso, what you have done so far ?
Jump to Posthow to do this
Don't. Do not store calculated values in your database. If Hra and DA are percentages of another database field, create a view which calculates them instead of storing them.
All 6 Replies
debasisdas
580
Posting Genius
Featured Poster
smantscheff
265
Veteran Poster
simransuri
-4
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
simransuri
-4
Newbie Poster
debasisdas
commented:
you need to read carefully, don't expext to be spoon feed here.
-2
smantscheff
265
Veteran Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.