Still cant get my trigger to work?

[Linkan]

Hello,

I am new to this and on my way to learning. I hope someone can help me with a trigger. I want to update status of one table when I insert a new threat in another. This is what I have come up with so far.

CREATE TRIGGER [trg_Update_Status] ON tForumThread
FOR INSERT
AS
BEGIN
UPDATE tJournalTopic (STATUS_ID)
SELECT STATUS_ID
FROM Inserted

Thanks,
Linkan

 

[foxdev]

UPDATE tJournalTopic (STATUS_ID)
SELECT STATUS_ID
FROM Inserted

Somewhat unusual, since usually you would be inserting a record into the other table. To use the UPDATE statement, you'll need to use the form SET COLUMNNAME=

when I insert a new threat
Sounds like a pretty violent application.

Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org