accountpayablemaster_insert.sql

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

CREATE TRIGGER AccountPayableMaster_Insert
ON AccountPayableMaster
FOR INSERT 
AS
/* 如果修改记录数是0就结束触发程序 */ 
IF @@ROWCOUNT = 0 RETURN
/* 定义变量 
@SupplierID : 供应商编号
@Prepaid : 暂付款
*/
DECLARE @SupplierID Char(8)
DECLARE @Prepaid Decimal(12, 0)
/* 找出新增的供应商编号, 暂付款 */
SELECT @SupplierID = SupplierID, @Prepaid = Prepaid
FROM inserted
/*计算暂付款*/
UPDATE Supplier SET Prepaid = Prepaid + @Prepaid                       
WHERE SupplierID = @SupplierID