insert trigger

Question

Hello, 

 

  When i attempt the following trigger on Insert, in inserts all the fields where i assigned a value but it is not insrting the "INSERTED", it shows as null, does any one have an idea on what i am doing wrong?

Thank yoU

ALTER TRIGGER INSERTTEST
ON TESTTABLE
FOR INSERT
AS
INSERT INTO OTHERTABLE(DATE,ID,NAME,DATE_GIVEN)
 
SELECT INSERTED.DATE,DUMMY_ID = '',INSERTED.FIRSTNAME, THEDATE= CAST (CONVERT(varchar,INSERTED.DATE,112) as INT)
FROM INSERTED WHERE SAVEFLAG = '100'

Answer 1

Hi, I tested your trigger and It worked, can you verify if the value inserted of SAVEFLAG is really '100' ?

---

Best regards

Answer 2

Hello Badi,

 

  Well the thing is that i am progrssivly saving that flag (updating the table) until it reachs 100, so i am thinking that it is firing right after i do the first insert... but i wanted to insert into the other table on the last update of the main table..

 

Regards

Answer 3

Hello,

 

 I found the problem hehehe, this is the right code

 

ALTER TRIGGER INSERTTEST
ON TESTTABLE
FOR UPDATE ***
AS
INSERT INTO OTHERTABLE(DATE,ID,NAME,DATE_GIVEN)
 
SELECT INSERTED.DATE,DUMMY_ID = '',INSERTED.FIRSTNAME, THEDATE= CAST (CONVERT(varchar,INSERTED.DATE,112) as INT)
FROM INSERTED WHERE SAVEFLAG = '100'