Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server 2000 Trigger & Service Desk 4.5

Highlighted
Vladimir V.B.
Super Collector

SQL Server 2000 Trigger & Service Desk 4.5

Hi
I am use SQL Server trigger for calculate date time value,but I get form "Merge result"(look attach) from SD and trigger's change not commited in SD. How i can resolve this problem
Best Regards
1 REPLY
Vasily Kamenev
Honored Contributor

Re: SQL Server 2000 Trigger & Service Desk 4.5

Hi
you see the Merge when data in DB is changed but in form not.
You need create Rule for calculation, use script the best way or use Rule where you will use one boolean custom field and your trigger must be run after this field is changed.

Vasily
//Add this to "OnDomLoad" event