dear vb master
saya lagi belajar trigger pada sql server 2000 dng script sbb:
CREATE TRIGGER tgr_Insert_Sales_Confirmasi_details
ON dbo.Surat_jalan_details FOR INSERT
AS
DECLARE @Artikel_SC CHAR(35), @No_Sales char(18) , @Qty_Sisa INT,
@Qty_kirim INT
SELECT @Artikel_SC=Artikel_SC , @No_Sales=No_Sales ,
@Qty_Kirim=Qty_Kirim FROM inserted
SELECT @Qty_Sisa=Qty_Sisa FROM Sales_Confirmasi_Details WHERE
[EMAIL PROTECTED] and [EMAIL PROTECTED]
SELECT Artikel_SC,No_Sales FROM Sales_Confirmasi_Details WHERE
[EMAIL PROTECTED] and [EMAIL PROTECTED]
IF @@ROWCOUNT = 0
ROLLBACK TRANSACTION
ELSE
UPDATE Sales_Confirmasi_Details SET [EMAIL PROTECTED] - @Qty_Kirim
WHERE [EMAIL PROTECTED] and [EMAIL PROTECTED]
setelah run gak ada yang salah tapi tidak ada reaksi. Mohon dong
dikoreksi apa yang salah. terima kasih
