Stored Procedures

Creating a stored procedure

To create a new stored procedure, do the following:

• In the Repository window, open the application folder where you want to create the stored procedure.
• Select the Database folder.
  
• Right-click the Stored Procedures subfolder and choose Insert stored procedure from the context menu. The Insert stored procedure dialog opens:

• Specify a value in the Name field. The Description field is optional. You can copy an existing stored procedure by selecting a name from the Copy From list. Stored procedures that are currently locked will not appear in the Copy From list. Click OK to add the stored procedure.
• The Options screen appears, showing the Name and Description you entered. To complete the specification, see Adjusting a stored procedure below.

Adjusting a stored procedure

When you double-click on a stored procedure name, the "Options" screen for it will be shown by default. You specify further details by clicking the nodes in the left-hand window pane, namely:

On completion, save the stored procedure. You can find the save buttons in the top toolbar of the Developer.

The stored procedure must be checked in first before it can be called from other objects.

Deleting a stored procedure

You can remove a stored procedure from the repository through the Revision Control screen.

Generate the application and reorganize the database

After a stored procedure is added, adjusted or deleted, a Whole System generate is required, followed by a database reorganize.