I am trying to set up a server script to execute a sql statement that calls a procedure in that database. I have one script that collects that information for parameters to pass, there are two. Sets a variable with the parameters in it. This than calls the script with the execute sql statement, passing the parameters to it.
It runs correctly if I just use Perform Script but when I use Perform Script on Server I get an OBDC error that two parameters were expect and it recieved zero.
Test Clone call Copy2 -script to collect data
Set Variable [ $$pickup; Value:job::job_id ]
Show Custom Dialog [ Title: "New Job Number"; Message: "Enter a new job number"; Default Button: “OK”, Commit: “Yes”; Button 2: