Triggers i 7.0

2 svar · 212 visningar · startad av ElMaco 28 juni 2001

ElMacoMedlem sedan juni 2000161 inlägg

Trådstart28 juni 2001 17:26#1

Tjena... ...det e jag igen.

Jag har ju inge vidare kolla på vad motsvarande tabeller "deleted" och "inserted" heter i SQL 7.0

Vad skall ändras?

GO
CREATE TRIGGER TR_Companies_Profiles_Delete ON companies FOR DELETE
AS
BEGIN
		SET NOCOUNT ON
		
		DELETE FROM profiles WHERE profiles.companyID =(SELECT companyID FROM deleted.companyID)
END

Felet: "Server: Msg 208, Level 16, State 1, Procedure TR_Companies_Profiles_Delete, Line 6
Invalid object name 'deleted.companyID'."

LarsGMedlem sedan dec. 200012 464 inlägg

28 juni 2001 17:30#2

CREATE TRIGGER TR_Companies_Profiles_Delete ON companies FOR DELETE
AS
BEGIN
SET NOCOUNT ON

DELETE FROM profiles WHERE profiles.companyID in(SELECT companyID FROM deleted)
END

ElMacoMedlem sedan juni 2000161 inlägg

28 juni 2001 17:35#3

Tusen tack.

...dags för kaffe.

*suck*