Hi,
Can anyone guide me on how to start a process instance from a SQLServer table change? Since this is probably not out-of-the-box any sample code is appreciated!
Thanks,
Adriano
Hi,
Can anyone guide me on how to start a process instance from a SQLServer table change? Since this is probably not out-of-the-box any sample code is appreciated!
Thanks,
Adriano
You could create a SQL trigger that invokes a small .NET console app. The console app should then use K2ROM. Additionally if this is SQL 2005 I suppose you could try writing a .NET CLR stored procedure that is called from the trigger. This CLR trigger would use the K2ROM API.
No matter what path you select you will need to invoke the process via the K2ROM .NET assembly/API. Check the documentation for how to code against K2ROM.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.