This topic is locked

Calling a Stored Procedure from ASPRunnerPro / Button to call Stored Procedure

8/13/2024 4:58:16 AM
ASPRunnerPro General questions
C
Conrunner author

Hello there

I have a stored procedure on a Microsoft SQL Server database which runs fine when executed from MSSQL Management Suite. For the life of me however I cannot seem to get the stored procedure to run by inserting code in the events section of ASPRunnerPro. I have looked on the internet and there seem to be several different options for code, I have tried all of them, but none of them seem to work as they all result in errors and I wondered if anybody could possibly tell me what the correct code to run a stored procedure is? I am using the most recent version of ASPRunnerPro. The stored procedure is very simple; it just truncates a table. No parameters.

Also I wondered if anybody could direct me toward guidance on how to get a custom button to run a stored procedure when the button is clicked? I do have the ASPRunnerPro manual but I do find it rather confusing I am afraid.

I would be extremely grateful for any wants help or suggestions.

Thx

Con