This topic is locked

Cannot get an MS SQL Server Stored Procedure to run before the add page opens

6/22/2024 11:03:47 AM
ASPRunnerPro General questions
C
Conrunner author

Hello

I have looked on the net for answers to this but there do seem to be any different answers. I simply want to get a stored procedure to truncate a table to run before the add page to that table has opened but keep getting errors. I have tried dbConnection.Execute "EXEC TRUNCATETABLES" and DB::Exec("EXEC TRUNCATETABLES") on the events page of ASPRunner Pro but nothing seems to work. Could anybody please tell me what the correct syntax is?