Creating a trigger

[FengShui1998]

Hello,

I am new to triggers so I need some help.

I would like to have the trigger run a vbscript file when a certain field that was blank is now filled with a string. So I believe this would happen on an UPDATE. Can someone help?

Thanks ahead.

Fengshui1998

 

[markros]

Why does trigger need to run a VBscript? This is a very unlikely task for the trigger.

PluralSight Learning Library

 

[FengShui1998]

It needs to run some system related tasks with certain folders and files.
If this is not possible can you at least post a trigger that would meet the criteria above. I try and figure out what else I could do.

Thanks

 

[markros]

create trigger trUpdate_tbl1
on tbl1 AFTER UPDATE
AS

;with Updates as (select I.* from Inserted I
INNER JOIN Deleted D
ON I.PK = D.PK
WHERE D.SomeField IS NULL and I.SomeField IS NOT NULL)
-- these are the records that updated Some field from nothing to a value

we can do something with them

PluralSight Learning Library