View Single Post
  #1 (permalink)  
Old March 12th, 2007, 07:58 AM
sweetraskels sweetraskels is offline
Registered User
 
Join Date: Mar 2007
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default error help plz...

am not able to use for each row in trigger

this is my code

create trigger trig_delete_tblworkdocketchild
on tblworkdocketchild
for each row delete
as
update tblmaterialin set tblmaterialin.quantity= deleted.rused +tblmaterialin.quantity
from tblmaterialin,deleted
where tblmaterialin.material = deleted.rpaper

i dnt know wi i get error...
helep me to fix this error