Click here to Skip to main content
13,458,506 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hi all

I need help regarding the below issue:

i am having 1 table where i m saving employee casual leave(CL)..each employee is having 1 CL per if that CL become less then 0 then it should automatically deduct one days salary of that employee

Now i have one salary form where i have one deduction i have to save that CL deduction value to the salary deduction column..

please tell me how to code this...
Posted 3-Oct-12 7:34am
Updated 3-Oct-12 7:37am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

there are two ways,
1. code a triger on cl updates, it checks if the cl value is becoming less than 0, it does the transaction on the deduction column

2. in your front end do the upper job, when updating CL column it checks the new value and if the new value is less than zero, it does the deduction process etc.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180323.1 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100