How can I pass named parameters to a SQL Server Stored Procedure.

eg if I have a stpred proc that has optional paramaters I need to pass the name otherwise it gets confused.

This Proc may have input Parameters

Declare @P1 varchar(10) = '', @P2  varchar(10)= '',  @P3  varchar(10)= ''

in SQL I would write

 

Category Survey AutoMate 7 version: 7.1.2 Windows version: Windows 2003

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
Declare @P1 varchar(10) , @Err int output SET @P1 = 'Boo' exec myProc @Input1 = @P1, @errorMessage = @Err output Select @Err

Phillip,

There is a parameters section in the Stored Procedure action that allows you to pass the parameters as you describe.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

That's kinda vague.  Anymore detail?  I have checked all of th tabs in the stored proc window and nothing jumps out. 

Category Survey AutoMate 7 version: 7.1.2 Windows version: Windows 2003

Phillip,

Please see the attached screenshots. The Parameters section is in the bottom left. You will need to click on the add button to add each parameter. I have also attached sample code showing a stored procedure with parameters.

Category Survey AutoMate 7 version: Windows version:

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<AMSQLSTOREDPROC PROCEDURE="test" NAMES="@RETURN_VALUE,@snum,@newExpDate" VARIABLES="&quot;&quot;,&quot;&quot;,&quot;&quot;" TYPES="Integer,String,WideString" DIRECTIONS="ReturnValue,Input,Input" VALUES="&quot;&quot;,%netauto.[Purchase ID]%,%netauto.EndDate%" PRECISIONS="10,0,0" NUMSCALES="0,0,0" SIZES="0,50,10" ATTRIBUTES="&quot;&quot;,Null,Null" />




-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

The parameters section allows you to add parameters but does not use there names.  The output from the example provided would be 

Declare @P1 int output

exec myProc 'boo',  @P1 output

The names pprovided are ignored.  I have to provide the required parameters in the correct order becuase of this.

Category Survey AutoMate 7 version: 7.1.2 Windows version: Windows 2003

Phillip,

Have you attempted to use your string in the SQL Query action? It would be the same way you would write it in SQL management Studio or how you have referenced it in your original post.

Category Survey AutoMate 7 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665