deliverymaster_delete.sql

来自「通用进销存-visual basic编写」· SQL 代码 · 共 18 行

CREATE TRIGGER DeliveryMaster_Delete
ON DeliveryMaster
FOR Delete
AS
IF @@ROWCOUNT = 0 RETURN
/*定义变量
@CustomerID : 客户编号
@AccountReceivable : 应收帐款
*/
DECLARE @CustomerID Char(10)
DECLARE @AccountReceivable Decimal(12, 0)
/*找出 客户编号, 应收帐款*/
SELECT @CustomerID = CustomerID, @AccountReceivable = AccountReceivable
FROM deleted
/*计算客户的信用额度余额*/
UPDATE Customer SET CreditBalance = CreditBalance + @AccountReceivable
WHERE CustomerID = @CustomerID