Sunday, May 06, 2012 12:15 PM
I want to create a web application that invokes an approval process when an update is made in a separate application. The separate application is from a 3rd part vendor but has a sql backend. Within the the SQL there is a table that I want to kick off a process every time something is inserted into it. I want to know the following.
- Is it possible to invoke an approval workflow without writing a trigger on the table (therefore invalidating the 3rd party support agreement). Is there another way to listen to the table?
- can the workflow be invoked from a change made in SQL Table?
it would be handy to see an example of question 2
Many thanks in advance for your help.
Monday, May 07, 2012 3:30 AMModerator
I'd suggest you check the discussion in the following thread. Basically, we must manually combine the code of monitor database and control workflow.
Start workflow on database update
- Marked As Answer by LeoTangModerator Sunday, May 13, 2012 6:12 AM