Click here to Skip to main content
11,578,739 members (66,541 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: 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 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
Edited 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
0 Peter Leow 135
1 Frankie-C 115
2 OriginalGriff 113
3 Richard MacCutchan 85
4 Afzaal Ahmad Zeeshan 85
0 OriginalGriff 933
1 Sergey Alexandrovich Kryukov 740
2 Abhinav S 573
3 F-ES Sitecore 420
4 Dave Kreskowiak 419

Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2015
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