What's wrong with this statement

[Bob Ebbert]

This is under the "Trigger Properties" section.

CREATE TRIGGER [TRIGGER NAME] ON [dbo]
FOR INSERT, UPDATE, DELETE
AS

We have very little experience with this so any help will be appreciated. In fact we even tried to hire someone to come out and look at it.... Never called back...????

[Markus]

You have to write separate statements for Insert, Update and /or Delete.
And you should place the tablename after ON


------------
Bob Ebbert at 3/16/01 9:56:03 AM

This is under the "Trigger Properties" section.

CREATE TRIGGER [TRIGGER NAME] ON [dbo]
FOR INSERT, UPDATE, DELETE
AS

We have very little experience with this so any help will be appreciated. In fact we even tried to hire someone to come out and look at it.... Never called back...????

[Martin]

This is not true.
You can have 1 trigger that contain INSERT, UPDATE, DELETE

ex:

CREATE TRIGGER trigger_name
ON table_name
FOR INSERT, UPDATE, DELETE
AS
SELECT ....
.....




------------
Markus at 3/16/01 10:32:14 AM

You have to write separate statements for Insert, Update and /or Delete.
And you should place the tablename after ON


------------
Bob Ebbert at 3/16/01 9:56:03 AM

This is under the "Trigger Properties" section.

CREATE TRIGGER [TRIGGER NAME] ON [dbo]
FOR INSERT, UPDATE, DELETE
AS

We have very little experience with this so any help will be appreciated. In fact we even tried to hire someone to come out and look at it.... Never called back...????