I currently using ASPRunner 6.0 and am trying to execute a stored procedure from an event after a record is updated. I am using SQL Server as my database.
Needless to say, I am having some issues.
Could you please assist with the proper syntax and how to reference variables on the screen that is being updated?
I tried this but it did not work...I am trying to pass 2 parameters to the stored procedure as follows:
Dbconnection.Execute "exec sp_storedprocedure @docno = " & dict("fieldname") & ", @trantype = 3"