Stored Procedure Call Editor

The Stored Procedure Call Editor is the editor which allows you to alter any aspect of a stored procedure call definition: its parameters, the parameter mappings and its code generation information. You open a stored procedure call definition in its Stored Procedure Call Editor by selecting it in the Project Explorer and then right-clicking it and selecting 'Edit...', or by pressing cntrl-shift-O.

The Stored Procedure Call editor consists of the following main parts:

Parameters tab
This tab contains the information and editors for working with the parameters of the stored procedure call definition
Parameter mappings tab
This tab contains the information and editors for working with the mappings of the parameters of the stored procedure call definition on the parameters of the target stored procedure in the Relational Model Data
Code generation info tab
This tab contains the information and editors for the code generation related data of the stored procedure call.

At the top of the Stored Procedure Call Editor you'll find the following editor elements:

Stored Procedure Call name
This is the name of the stored procedure call definition
Group name
This is the name of the group the stored procedure call definition is in. You can select an existing one or specify a new one. If left empty, the stored procedure call definition is in the unnamed group

The General Stored Procedure Call Editor

The designer also offers a General Stored Procedure Call Editor. This is a special kind of Stored Procedure Call editor which allows you to edit the Stored Procedure Call which is currently selected in the project explorer. This editor is opened by selecting Project -> General Stored Procedure Call Editor in the menu, or by clicking button in the toolbar.

The advantage of the General Stored Procedure Call Editor is that it keeps the current sub tab selected when you select another stored procedure call in the project explorer, which allows you to e.g. edit the mappings of several stored procedure calls without a lot of clicking through tabs.