TRIGGER

[roxy31]

tom31 - 11-23-2010 13:49
hello

i have a table named Articles with the fields idarticle, namearticle, price

i have another table named Ware with another fields but the most important is
amount

i have a table named existence with the fields idarticle, namearticle,
existence

i made a trigger in Articles table so when i add they will insert into
existence

but i need to make another trigger in Ware table so when i insert the amount
it will insert into Existence table too but in the row that belongs. I mean i
had made one trigger but the amount was inserted in a new row and it has to
be inserted in the row where its idarticle belongs.

any help? i will be really grateful

 

[ousoonerjoe]

Maybe this example will lead you to what you're needing:

CREATE TRIGGER trg_AssemblyLine_Audits
ON AssemblyLine
FOR INSERT, UPDATE
AS
UPDATE AssemblyLine
SET ModifiedBy = SUSER_SNAME(),
	ModifyHost = HOST_NAME(),
	ModifyDate = GETDATE()
FROM AssemblyLine al
	[b]INNER JOIN Inserted i on al.AsyLineId = i.AsyLineId[/b];

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------