Handling SQL Data – Leveraging SQL Stored Procedures in Workflow

For every project I develop, there’s a high probability that a custom-made SQL database is going to be useful to the process I’m working on.  I’m going to detail my process here, which should be a good follow-up to my SQL primer here.

Note that while this is not intended to be a tutorial on how to use SQL, I will be covering the SQL basics needed to complete this demo.  Send me a note if you have any issues with any of the steps.

For this project, we’re going to build an integration library with two components.  One component is going to be a simple data query component that we’ll use to validate a proposed data write before committing; the second will be the Stored Procedure caller that will handle updates, inserts, and deletes.  The same component can also be used for other, more specific tasks, such as order changes and re-sorting.  Let’s start with the second component – the Stored Procedure caller.

Continue reading

Workflow Short – Adjust Default Debugger Browser

I haven’t personally been a fan of Internet Explorer for a long, long time.  Because of this, when the Workflow debugger insisted on opening forms in IE, I had to insist in return that it do otherwise.

These instructions will help you swap out IE for Chrome, but you can tailor these instructions to use whatever supported browser you’d like.

Continue reading