Trigger update?

[Linkan]

Hello, I have two tables, looks as follow.

TOPIC
------
TOPIC_ID
STATUS_ID
TOPIC


THREAD
-------
THREAD_ID
TOPIC_ID
STATUS_ID
THREAD
THREAD_DATE
NAME

I want to update STATUS_ID in TOPIC when I post a new THREAD.
I guess the best would be to use a trigger?
Don't know much how you write them so if someone please could help or point me in right direction.
My plan is to always show the updated STATUS_ID in TOPIC while I have history in the THREAD TBL.
I am using MS SQL 7.0

Thanks for a great site.

Linkan

[Jim W]

You could also just use a stored procedure that handles the insert of the new thread and the update of the topic table.

A trigger isn't a bad method to use on this though. But if you want to use it, read up on triggers in books online. Not trying to be brusque, but you'll get a better handle on it that way.

------------
Linkan at 2/21/01 3:02:24 PM


Hello, I have two tables, looks as follow.

TOPIC
------
TOPIC_ID
STATUS_ID
TOPIC


THREAD
-------
THREAD_ID
TOPIC_ID
STATUS_ID
THREAD
THREAD_DATE
NAME

I want to update STATUS_ID in TOPIC when I post a new THREAD.
I guess the best would be to use a trigger?
Don't know much how you write them so if someone please could help or point me in right direction.
My plan is to always show the updated STATUS_ID in TOPIC while I have history in the THREAD TBL.
I am using MS SQL 7.0

Thanks for a great site.

Linkan

[Linkan]

Thanks for your input, I have done some reading in books online and I managed to insert in TOPIC with a trigger fired when a new thread is inserted. I just don't seem to get the UPDATE work. There can be many threads to a topic but I always want to have the latest status_id the TOPIC table.
Following code shows how the trigger looks when it insert.

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

Thanks
//Linkan


------------
Jim W at 2/21/01 3:14:08 PM

You could also just use a stored procedure that handles the insert of the new thread and the update of the topic table.

A trigger isn't a bad method to use on this though. But if you want to use it, read up on triggers in books online. Not trying to be brusque, but you'll get a better handle on it that way.

------------
Linkan at 2/21/01 3:02:24 PM


Hello, I have two tables, looks as follow.

TOPIC
------
TOPIC_ID
STATUS_ID
TOPIC


THREAD
-------
THREAD_ID
TOPIC_ID
STATUS_ID
THREAD
THREAD_DATE
NAME

I want to update STATUS_ID in TOPIC when I post a new THREAD.
I guess the best would be to use a trigger?
Don't know much how you write them so if someone please could help or point me in right direction.
My plan is to always show the updated STATUS_ID in TOPIC while I have history in the THREAD TBL.
I am using MS SQL 7.0

Thanks for a great site.

Linkan