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.