Stored Procedures List Window
The Stored Procedures List window is launched
from one of two places:
- The popup menu for the schema, or
- The Show Procedures
button on the Add/Modify Stored Procedure Call notebook.
It contains the following list elements:
- Stored Procedures in Database - Click the Get Stored Procedures button
to populate the list by connecting to the Database and retrieving the names of all stored
procedures in it.
- Imported Stored Procedures List
- Contains the names of all stored procedures from Database that have been defined to Data Access Builder.
- To add one from the list above,
select it and click the Import
button. It will be added to the Imported list.
- You can view and modify its
definition by selecting it in the Import list and
clicking the Modify button.
Often, stored procedure definitions cannot be
read from the database, and so you must modify
the definition of an imported procedure before
using it.
- If you cannot connect to the Database, or cannot retrieve a definition from
it, you can define stored procedures to Data
Access Builder by clicking Add,
and providing the definition yourself. In this
case, there is no way of checking that your
definition is correct, so be sure to make it
accurate.
- To remove an imported stored
procedure definition, select it and click the Delete
button. This does not delete the stored procedure
from the database, but it does delete all
user-defined methods that call the selected
stored procedure.
- To copy a stored procedure
definition, select it and click the Copy
button.
- Close - Click the Close
button to exit the window.
- Help - Click the Help
button to display online help for the window.

User-Defined
Methods

Add User-Defined
Methods That Are Stored Procedure Calls
Define
Stored Procedures
Modify
Stored Procedure Definitions

Add/Modify Stored Procedure
Window
Add/Modify Stored
Procedure Call Window