Question: I would like to run a SQL Server Stored Procedure behind the scenes of
SalesLogix. I would like to click a button that will execute the Stored
Procedure in the background with the ability to close or minimize the
form. The Stored Procedure is taking 10+ minutes to run and I don’t
want the form to be open the whole time. Any idea how I can do this?
Answer: To execute something asynchronously you need to shell out to it. This
can’t be done in the SalesLogix scripting environment. Try building it
as a .NET extension, or even an exe that you kick off when needed.