Click here to Skip to main content
12,446,703 members (52,700 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB SQL-Server VB.NET
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 month..now 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 column..now 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
Code-Hunt7.1K
Updated 3-Oct-12 7:37am
v2

1 solution

Rate this: bad
 
good
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.
  Permalink  

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 | Mobile
Web02 | 2.8.160811.3 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2016
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