Re: [Programmer-VB] Trigger Update

[Fountain Melody]

Wah...   Trims berat Pak Ronald, juga trims yang sama beratnya buat Pak Andrey, Anda berdua sangat membantu saya.   ----- Original Message ----- From: Ronald Irawan To: Programmer-VB@yahoogroups.com Sent: Monday, June 20, 2005 10:39 AM Subject: Re: [Programmer-VB] Trigger Update field table transaksi : no_faktur, jumlah, quantity field table history: no_faktur, total (yg merupakan jumlah*quantity) CREATE TRIGGER triggerUpdate ON tTransaksi   FOR Update AS declare @faktur varchar(50),         @nilai        decimal declare csUpdate cursor for select a.no_faktur,a.qty * a.jumlah from inserted a inner join deleted b on a.no_faktur=b.no_faktur open csupdate fetch csupdate into @faktur,@nilai while not @@fetch_status=0 begin         update thistory set [EMAIL PROTECTED] where [EMAIL PROTECTED] fetch csupdate into @faktur,@nilai end close csupdate deallocate csupdate Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.