需要帮助如何编码问题 [英] Need help how to code the problem

问题描述

大家好

我需要有关以下问题的帮助:

我有1张桌子，我在其中节省员工的请假(CL)..每个员工每月有1个CL..现在，如果该CL小于0，则它应自动扣除该员工的一日工资

现在我有一个薪水表，其中有一个扣除列..现在我必须将该CL扣除值保存到薪金扣除列中..

请告诉我如何编写此代码...

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...

推荐答案

有两种方法，
1.在cl更新上编写触发程序，它检查cl值是否小于0，并在扣除列上进行交易

2.在您的前端执行较高的工作，更新CL列时它会检查新值，如果新值小于零，则会执行推导过程等.

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.

这篇关于需要帮助如何编码问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！