kalo di run di query analyzer pasti ga ada hasil apa2, cm di bagian trigger ada triger baru tgr_Insert_Sales_Confirmasi_details. triger ini baru jalan kalo di tabel Surat_jalan_details di-insert record baru (ON dbo.Surat_jalan_details FOR INSERT)
sekian. --- In [email protected], "sunardi_kss" <[EMAIL PROTECTED]> wrote: > > 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 >
